Stack Overflow
Stack Overflow

Questions tagged [sqldataadapter]

Represents a set of data commands and a database connection that are used to fill the DataSet and update a SQL Server database.

The SqlDataAdapter, serves as a bridge between a DataSet and SQL Server for retrieving and saving data. The SqlDataAdapter provides this bridge by mapping Fill, which changes the data in the DataSet to match the data in the data source, and Update, which changes the data in the data source to match the data in the DataSet, using the appropriate Transact-SQL statements against the data source.

438 questions
-3
votes
1 answer

How to pass parameters to SqlDataAdapter

I have a Vb.net program that queries a database to get a bunch of records. I can't quite figure out how to pass parameters. below is my code: Dim connectionString As String Dim sqlCnn As SqlConnection Dim sqlCmd As SqlCommand Dim sql…
Shmewnix
  • 1,553
  • 10
  • 32
  • 66
-3
votes
1 answer

Not able to update specifc DataTable in DataSet

private void Form1_Load(object sender, EventArgs e) { da = new SqlDataAdapter("select * from record",@"database=student;server=arun-pc\mypc;integrated security=true"); da.Fill(ds,"record"); } private void button1_Click(object sender,…
Vibhu Mishra
  • 29
  • 8
-3
votes
2 answers

Which one will run faster?

Possible Duplicate: Is datareader quicker than dataset when populating a datatable? public DataTable GetReviewsId(Objects myObjects) { DataTable tblBindReviews = new DataTable(); string Query = ""; try { Query =…
Niar
  • 532
  • 2
  • 11
  • 23
1 2 3
…
29
30