Answer Posted / dinesh shrimali
Data adapter is bridge between Connection and DataSet ,
Data adapter in passing the sql query and fill in dataset
Eg.
Dim sqlStr as string
Dim DA as SqlDataAdapter
Dim DS As New DataSet
Sqlstr=”SELECT * FROM emp”
DA=New SqlDataAdapter(sqlstr, “Connection name”)
DA.Fill(DS)
| Is This Answer Correct ? | 74 Yes | 10 No |
Post New Answer View All Answers
What is the difference between SqlCommand and SqlCommandBuilder?
What are the parameters that control most of connection pooling behaviors?
What is the namespaces being used to access oracle database?
What is the difference between data grid and data repeater?
Explain what are the steps to connect to a database?
What is ado.net in mvc?
Which database is the ado.net sql connection object designed for?
What is the difference between executequery and executenonquery?
What are dcl commands?
Is bulk insert faster than insert?
What is ole db and odbc?
What is concurrency? How will you avoid concurrency when dealing with dataset? (One user deleted one row after that another user through his dataset was trying to update same row. What will happen? How will you avoid the problem?)
Does executenonquery return a value?
What do you mean by performing asynchronous operation using command object?
What is microsoft ado.net?