Easy Question

Question

For example i have this Table: Name, ID, Address and i have some data in it and added to a listbox when i insert new data using the command.ExecuteNonQuery() its just ok, but when i have to update my listbox the newly inserted data doesn't appear in the listbox. What seems to be the problem? Can anyone help me? i'm just a beginner.

Answer 1

hey i tried this in some different way just give it a try,
i am using ABC Table as you give in the above example and considering the column you gave in it.
if the attached code is also taking time then try with using query hints like (nolock) , creating index on table columns etc.

Thanks!

Answer 2

Hi,

i think here is the typo in date insted of 2/1/2009 you have put 2/2/2009 name,1/1/2009 2/2/2009

if possible can you please put your query/code here. to see where you are missing.

Thanks!