ado.net

Question

how can we update the data from frontend(asp.net) to the backend(sqlserver database).

Thavaselvan Palanivel · Answer

buddy, row=ds.Tables[0].Rows.Find("xx") returns datarow. if the data is available then you will get the row position. by using below code row[0].ToString() . else you will get the null value

Khargesh Rajput · Answer

http://www.c-sharpcorner.com/UploadFile/718fc8/save-delete-search-and-update-record-in-ado-net/

Thavaselvan Palanivel · Answer

my suggestion is go with disconnected architecture (Ado.net). for example i'm having text box and submit button in front end, now get the value of the text box (eg string Name= txtName.Text;) As part of ado dotnet part create a connection string and play with the ado dotnet part Refer: http://codex.blog.com/source-code/ado-dot-net/

Vincent Maverick Durano · Answer

When using Find() method of DataRow make sure that the value exist and the value is the primary key. Also check for null before accessing the result. For example: DataRow foundRow = table.Rows.Find(pkValue); // check the value of column if it's null if(foundRow != null){ //do stuff }

Siva Poola · Answer

i m implementing program using disconnection architecture. im getting errors...... i hav few doubts..... can u explain below statement ?.... DataRow row = ds.Tables[0].Rows.Find(txteno.Text); [i m getting error at this line] where ds is dataset object my doubt is "what can we do with Find() in above statement"

ado.net

Answers (5)