coding in sql server or vb.net?

[faisal]

I have one query regarding SQL server and vb.net 2010. Suppose I made one database in sql server and created a table. Now for the insertion, deletion, alteration I have created one form in vb.net 2010. I put one object, say (command button) on the form, and I coded that command button to connect to sql server and retrieve data for a particular field but after sometimes you came to know that another field data is coming in that field.

My question is for rectify that error i have to do coding in sql server or vb.net? Can i code in sql server? or sql server is just for select, append and for different queries only to see the database? and if it is possible in sql server to code and resolve that issue then again i have to make coding changes in vb.net too?

 

[jmcilhinney]

Let me just confirm exactly what you're asking for. Are you saying that you are retrieving data from the database to edit and save but it's possible for another user to edit and save that data before you, and you want to know how to handle that?

 

[faisal]

there is no another user. i am just asking, if you have to rectify an error in sql database programatically then you have to do coding in vb.net or sql itself. Because i made a form in vb.net and put one button to connect to sql server. Or if i can do programming in sql to rectify that error then i have to amend the vb code also which i have written.?