How to Handle the exceptions in Sqlsrver2000
Answers were Sorted based on User's Feedback
Answer / bolisettyvaas
In SQL Server 2000 there is no powerful error handling like
.Net. But you can use one global variable @@ERROR. So after
every dml statement, you can retrieve this variable value
and verify if the value is not equal to 0 then it means some
error occured. otherwise no errors in the last executed
statement.
Is This Answer Correct ? | 3 Yes | 0 No |
What providers does Ado.net uses?
What is a sqldataadapter?
What is executescalar and executenonquery?
Is ado.net dead?
Explain how to copy the contents from one table to another table and how to delete the source table in ado.net?
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
What is the purpose of using adodb?
Which object needs to be closed?
what is the syntax code to oledb to connect oracle
what are the differences between dataset and datareader?
Define the data provider classes that is supported by ado.net?
Explain ado.net features? Benefits? Drawbacks?