//ds is the typed Data Set //UserloginsDataTable is the table where the occupation is saved //Occupation is the name of the column try this one if(ds.Tables["UserloginsDataTable"].Select("Occupation=Student").Length>0) { } ds.Tables["UserloginsDataTable"].Select("Occupation=Student") will return a datarow array. and if the array length is<1 then ther are no records else records exixts. hope this helps you. Ramesh.Kanjinghat

freshonlineMax wrote: change below definition of textBox1: private System.Windows.Forms.TextBox textBox1; To : public static System.Windows.Forms.TextBox textBox1; :omg: Why make fields in a class private, why not make them public?[^] "On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog

Ohh thanks... I arranged the quotes and it worked out Thanks a lot!!

string query = "UPDATE Marks SET subjectMarks = '" + marks + "' WHERE userName = '" + cUserNameVar + "'" This assumes that the username is unique in the Marks table, since every record with that user name will be changed to have the new subjectMarks value. Either that, or you need an ID column - when you INSERT the name into the table from the login btn, get the ID and use that in the WHERE clause of the UPDATE when you put the subjectMarks in later. ---------- There go my people. I must find out where they are going so I can lead them. - Alexander Ledru-Rollin

Something like this (not tested): Binding binding = this.txtDOB.DataBindings.Add("Text", DBHandler.DS, "UserLogInsteacher.DateOfBirth"); binding.Format += new ConvertEventHandler(binding_Format); and private void binding_Format(object sender, ConvertEventArgs e) { DateTime dt = (DateTime)e.Value; e.Value = dt.ToShortDateString(); } Some error handling etc should be added (like checking for DbNull etc.)

Correct, next question for 10 points :-D

just use an INVISIBLE TextBox control to store the track and count of the clicks.:zzz:

I don't think you understood me. I disabled the form but I would like that when I close the About form, the main form will be enabled again. How can I do that? thanks

Ohh I made it, Thanks a lot people for helping me! :-D