Posts by Ramy Mahrous

Please mark this thread as solved :)

blabla blabla blabla I don't understand anything.
Logically you need to update the two columns of table2 when the primary key of table1 changes?

Jerry is well answered.

Is ASP.NET user has permission to delete files on the server?

It would be fine if the form refreshes whenever the user adds new record to the table.

You need to work with SqlCacheDependency http://msdn.microsoft.com/en-us/library/system.web.caching.sqlcachedependency.aspx

I've question you need to update the result form every change user makes or every some time period?
I see you shouldn't overload the Show method rather make another one has two parameters dataset, string
gridview.datasource = dataset
gridview.DataBind()
And call this method from main form once user changes the criteria.

This question is a bit related to ASP.NET developers, I think they can guide you to the best path http://www.daniweb.com/forums/forum18.html

You can use triggers as said in the KB.

foreach(DataRow row in table.Rows)
{
if(row["columnName"] == value)
//display the row, otherwise escape.
}

It's remote server?

Kruskal code

void swap ( ref Node a, ref Node b )
		{
			///<Rizk>
			Node c = a ;
			a = b ;
			b = c ;
			///</Rizk>
		}

		/// <summary>
		/// Calculate the Left Child node of a Parent
		/// Used in Heap
		/// </summary>
		/// <param name="i"></param>
		/// <returns></returns>
		int left ( int i )
		{
			///<Rizk>
			return i * 2;
			///</Rizk>
		}

		//Calculate the right Child node of a Parent
		//Used in Heap

		int right ( int i )
		{
			///<Rizk>
			return i * 2 + 1;
			///</Rizk>
		}

		// Arrange the Heap to Exatract the Minimum

		void Min_Heapify ( Node [] a, int i, int Heap_Size )
		{
			///<Rizk>
			int min;
			int l = left ( i );
			int r = right ( i );

			if ( l <= Heap_Size &&  a[ l - 1 ].key < a [ i - 1 ].key )
				min = l;
			else
				min = i;

			if ( r <= Heap_Size && a[ r - 1 ].key < a [ min - 1 ].key )
				min = r;

			if ( min != i )
			{
				swap ( ref a [ i - 1 ], ref a [ min - 1 ] );
				Min_Heapify ( a , min , Heap_Size );
			}
			///</Rizk>
		}

		// Bulid the Heap

		void Build_Min_Heap ( Node [] a, int Heap_Size )
		{
			///<Rizk>
			for ( int i = a.Length/2; i >= 1; i--)
				Min_Heapify ( a , i , Heap_Size );
			///</Rizk>
		}

		//Extract the …

onedizzydevil

You are not setting the Num variable to value that was entered into the textbox; therefore, it will always be 0.

By Ramy Mahrous

Hey friends!!!! how could you answer their question without looking at their code?!!!! which line they assigned textbox value to Num object?!!!!!

Didn't you see my reply?!!

It has. And he can use SMO, to enumerate every object in the server.
But it's not applicable in business application development except in very critical situations.

Pirate, in business application development, we can't rely on auto discovery tool there's something called connection string, which holds database server IP\name, user credentials, some other properties, etc..; may be encrypted or may be not. and you configure it at clients' place.
And you said ODBC. and this is correct.

You're welcome please mark it as solved.

Put it in shared location on lan and access it. But the question is Access able to handle more than one user concurrently? the answer is no.

Thanks Teme, so much, I tried to convert my C# knowledge to VB.NET but seems it doesn't work :D
Thank you so much really..

It doesn't occur with me, but try to reinstall the framework, or I recommend you to report this bug to http://microsoft.com/connect ->Select visual studio and report a bug

Tell me the error please, or send me the access file, to try.
<EMAIL SNIPPED>

Never mind, I understood you :)

If it works with you please mark this thread as solved.

SELECT  Subjects.Subject_ID, Subjects.SubjectCode, Subjects.SubjectName, Visits.Date, Visits.Comment
FROM Subjects INNER JOIN Visits ON Subjects.Subject_ID = Visits.Subject_ID 
Where Subjects.Subject_ID = (select distinct Subjects.Subject_ID from Subjects)
HAVING Visits.Visit_ID = Max (Visits.Visit_ID)

Or

SELECT  Subjects.Subject_ID, Subjects.SubjectCode, Subjects.SubjectName, Visits.Date, Visits.Comment
FROM Subjects INNER JOIN Visits ON Subjects.Subject_ID = Visits.Subject_ID 
Where Subjects.Subject_ID in (select distinct Subjects.Subject_ID from Subjects)
HAVING Visits.Visit_ID = Max (Visits.Visit_ID)

My team and I developed those two algorithms in C#, when I back home I'll attach you the source code. Please remind me after 8 hrs from now.

Here you're

SELECT     WorkOrders.ID, employees.name, employees_1.name AS Expr1
FROM         WorkOrders LEFT OUTER JOIN
                      employees AS employees_1 ON WorkOrders.submitted_by = employees_1.id LEFT OUTER JOIN
                      employees AS employees ON WorkOrders.completed_by = employees.id

- Read every hex 85, 1F, etc
- Parse every hex to covert it to char

Dim c as char
c = (char)int.Parse(hex, System.Globalization.NumberStyles.HexNumber)

- you can add 'if' statement to escape 85 and replace it with '\r\n'

Please copy your code here, instead of writing a new piece of code to you.

Because you add in your dictionary two keys with the same name.

Yes you, can and using Datagridview by clicking in Datagridview's smart arrow and configure columns.

Are you running on SQL Server?

Give us more explanation.
What the table you need to update its values by which table?

It may help http://www.autoitscript.com/forum/index.php?showtopic=66397

If it solved please mark it as solved. Otherwise tell us any problem you face.

You can use BackgroundWorker component which has something to do and has event "work compeleted"

Copy your query here which raises this error.

Remove alias and use the table name directly. Replace every T1 & T2 with tblEmailClub

Look try just to update field "Lock" by "ID" instead of by username.

After digging I came with bad performance solution :s but I think it works,

SELECT 
T1.address1,
tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,
tblEmailClub.email,
tblSourceHistory.datereg,
tblEmailClub.active,
tblEmailClub.address2,
tblEmailClub.city,
tblEmailClub.state,
tblEmailClub.zip,
tblSourceHistory.source FROM tblEmailClub
INNER JOIN tblSourceHistory
ON tblEmailClub.emailclub_id = tblSourceHistory.emailclub_id
WHERE tblSourceHistory.dateReg BETWEEN '3/1/2009' AND '4/1/2009' 
AND T1. address1 IN
(SELECT T2.address1 
FROM tblEmailClub AS T2
GROUP BY T2. address1 
HAVING COUNT(T2.address1)=1
)
AND tblSourceHistory.source LIKE '%family.asp%'
ORDER BY tblSourceHistory.datereg ASC

Please check it if you have any problem please contact me.
NOTE: try to read also in distinctrow it may help you http://office.microsoft.com/en-us/access/HP010322051033.aspx

I got this solution from my friend Ahmed Gamal: http://vb4arab.com/vb/member.php?u=3

You've right, I'll try something else and reply you.

No, distinct works on column and it removes the duplication, I tried it myself.

It depends!
Why you need to save user searches or you don't intend to?
please tell me more about your scenarios what you need to keep track on and so on; to guide you to good design.

Thank you so much, I didn't notice that before, I don't know it's with latest daniweb update or what :)
Thank you, again.

No, It just gets the most recent fixed number of reputations not all. I said all reputations since the member join the community.

What should I do if I want to get all reputation I took in Daniweb, whatever it's good\bad?!

From the solution which you develop your application, right click then add new project->Other project types->Setup and deployment->setup wizard.
This will create for you ClickOnce installation project which let you setup your application on any client machine.
Once you accept the default settings, you'll be able to deliver the .msi package, but if your application has some special configuration, prerequisites assemblies, etc.. You'll need to add your specific configuration in setup wizard project.

hmmm, That's because of obligation of being distinct in first place

SELECT 
DISTINCT (tblEmailClub.address1),
tblEmailClub.emailclub_id,
tblEmailClub.firstname,
tblEmailClub.lastname,
tblEmailClub.email,
tblSourceHistory.datereg,
tblEmailClub.active,
tblEmailClub.address2,
tblEmailClub.city,
tblEmailClub.state,
tblEmailClub.zip,
tblSourceHistory.source FROM tblEmailClub
INNER JOIN tblSourceHistory
ON tblEmailClub.emailclub_id = tblSourceHistory.emailclub_id
WHERE tblSourceHistory.dateReg BETWEEN '3/1/2009' AND '4/1/2009'
AND tblSourceHistory.source LIKE '%family.asp%'
ORDER BY tblSourceHistory.datereg ASC

On button click event handler

YourList.Items.Add(TextBox.Text)

Yes, I understand you. and your answer confused me. Anyway good answer and never mind, you're old friend :)

I didn't understand your question. You need user to type in textbox then press on button, which will take textbox text and add it to list?

System.XML contains everything to do with xml files. But if you need quick help look at this tutorial http://www.c-sharpcorner.com/UploadFile/mahesh/ReadWriteXMLTutMellli2111282005041517AM/ReadWriteXMLTutMellli21.aspx You'll just 1 line of code to wirte in text files.

For every subject ==> group by subject ID
The highest result ==> having Visit_ID = Max (Visit_ID)