Answer / umar topia

Have one column with in Database table with datatype as
TimeStamp and while selecting the row we will read the
TimeStamp value, which we can compare at the time of updation,

if both values are same then we can update that row
otherwise we can resist the user from updating saying that
someone has updated the row, you can't update it.

Answer / kiranmadiraju

You can use one primary key and one timestamp field to sort
out the problem of concurrency.
The steps are like this
1.Fetch the record from database and store the primary key
value and timestamp in the session.
2.Update the same record with new values other fields using
the same session values for primary key and timestamp fields.

Answer / shweta

we can have to use exclusive locks on the table thats why
we can't change data at a time..

Answer / gt

provide the transactionlevels

What is a dataview?

0 Answers  

---

What is ole db query?

0 Answers  

---

OleDbDataAdapter ole=new OleDbDataAdapter(new OleDbCommand ("select * from login",oleDbConnection1)); OleDbCommandBuilder cmd=new OleDbCommandBuilder(ole); ole.Fill(dataSet11,"login"); DataRow drow=dataSet11.Tables ["login"].NewRow(); drow[0]=textBox1.Text; drow[1]=textBox2.Text; drow[2]=textBox3.Text; dataSet11.Tables["login"].Rows.Add (drow); ole.UpdateCommand=cmd.GetUpdateCommand(); ole.Update(dataSet11,"login"); MessageBox.Show("one row added"); this gives exception.how to solve it

1 Answers   Nimaya,

---

How to connect and retrieve data from database using dataset

0 Answers  

---

What is DataReader Object?

0 Answers  

---

Diff B/W DataSet vs DataTable

6 Answers   Star Wire,

---

What is an ado connection?

0 Answers  

---

How is entity framework different from ado.net?

0 Answers  

---

How do we invoke queries from the application ?

2 Answers   ICICI, Microsoft,

---

What is meant by executenonquery?

0 Answers  

---

Is entity framework better than ado.net?

0 Answers  

---

ADO and ADO.NET differences ?

2 Answers   Microsoft,

---