I don't understand completely::confused: If all of these forms are in the same application then why don't you have form10 call form2's timer and tell it to stop.

ok! thanks! i got it already... thank you so much to all those who help! ;)

in codes, there is BOOK_LOCATOR.DataSet1 and you got error like 'BOOK_Locator.Dataset1'.So may be this because of case sensitive..Check for that too...Otherwise, take a fresh dataset and try once. suchitamanandhar@hotmail.com

Don't cross post. --- single minded; short sighted; long gone;

Rharzkie wrote: no, its not follow-up i already connect my database using connection wizard... In other words, it's a follow-up. A good place for a follow-up is in the same thread. Rharzkie wrote: but when i write my codes, the program is not running bec. of the error,it says that the dataset11 is not defined... whats the meaning of that???? That's not the same error that you quoted in your previous post. What is the error message exactly? If the compiler says that something is not defined, then it's because it's not defined. Why do you think that it should be defined? Have you defined it? If so, where? --- single minded; short sighted; long gone;

As others have said, don't cross post. That is very rude. Rharzkie wrote: Type 'BOOK_Locator.Dataset1' is not declared That pretty much tells you the problem. Is the error occurring within the scope of where you have it declared? "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon

http://support.microsoft.com/kb/295297[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips

http://support.microsoft.com/kb/295297[^] Vasudevan Deepak Kumar Personal Homepage Tech Gossips

i dont know how to use oledbcommandbuilder... i have a primary key in my database, my primary key there is the studname...

the menus in both two forms that i made are almost the same, and composed of same items. i did not change any of the properties of the two menus. how come that the other one is not visible?

No - your original SQL statement is correct in as far as it goes, but will crash if any of your text inputs include apostrophes. Because SQL uses apostrophes to mark the start and end of text fields, another one occuring within a field causes problems. To get round this, SQL accepts two consecutive apostrophes as marking not the end of the text field but an apostrophy within it - thus if your txtcourse.text = "smith's" the SQL statemt would fail, "smith''s" would be accepted. To take acount for this in all cases, simply use the replace method to replace all apostrpohes within text fields with double apostrophes - thus: str = "Insert into students (studname, year, course) values ('" & txtname.Text.Replace("'", "''") & "', '" & txtyear.Text.Replace("'", "''") & "', '" & txtcourse.Text & "')" cheers Fred

at the first time you should set your listbox datasourse it will be your table in your dataset and then set displayMember it will be the column name of the table it will be shown to user and then set valueMember it will be the column name that is not been shown to user .

OK THANKS...

how can i declared all the variables there? will i put in form_load or in listbox1_SelectedIndexChanged???

Hi Rharzkie, In your first part of your code you didn't pass parameter for the case. It should be Select Case Case 0 Dim subjects As New subjects subjects.Show() Me.Hide() Case 1 Dim file_maintenance As New file_maintenance file_maintenance.Show() Me.Hide() Case 2 Dim grade_entry As New grade_entry grade_entry.Show() Me.Hide() End Select Senthil

Rharzkie wrote: but i already try your example, and it works, thanks for that.. Your welcome. my friend. If it is useful for you, don't forget to vote the message. Thank you too. :) Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. :)

That is all. _____________________________________________ Flea Market! It's just like...it's just like...A MINI-MALL!

But giving things descriptive names is part of good programming practice. It is never acceptable to leave something in place that cannot be easily identified at a later stage. The important thing to remember here is that it only takes you a couple of seconds to rename them before there is any code present, but as soon as you have code that refers to it, you have to take much more care and this takes time. Please visit http://www.readytogiveup.com/ and do something special today. Deja View - the feeling that you've seen this post before.

1. Drag one label in your form and name it lblID 2.In your GridView1 selectedIndexChange event (I am giving this example for asp.net) set text of selectedrow and specify cell's text then set text to lblID. (In this case select row which contain name Risa) lblID.Text = GridView1.SelectedRow.Cells[1].Text;//Instead index 1 in Cells property can differ from my example 3. In Update button set update command : " Update YourTableName set Grade='95' where [ID]='"+lblID.Text+"'"; 4.Then bind GridView1. GridView1.DataBind(); I Love SQL

Rharzkie wrote: The ComboBox1 is for the list of the subject code. Yes, but ComboBox1 still isn't a good name for it, is it? Rharzkie wrote: OleDbDataAdapter1 Rharzkie wrote: OleDbDataAdapter3 :omg: How do you keep track of what each of these does? Rharzkie wrote: Is this correct? I have no idea. This code is obviously a mess. My suggestion is to start by naming things properly. Then it might be an idea to create a DAL and remove all your database interaction out of the user interface classes. It might also be an idea to do what I asked in my previous post and answer the question I asked. ("What does ComboBox1.SelectedItem return?" - And I want actual values and object types, not what you think it should return) Upcoming events: * Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ... "I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless." Ready to Give up - Your help will be much appreciated. My website