C# ADO.NET SqlDataAdapter

SqlDataAdapter Class is a part of the C# ADO.NET Data Provider and it resides in the System.Data.SqlClient namespace. SqlDataAdapter provides the communication between the Dataset and the SQL database. We can use SqlDataAdapter Object in combination with Dataset Object. DataAdapter provides this combination by mapping Fill method, 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.

SqlDataAdapter adapter = new SqlDataAdapter(); adapter.Fill(ds);

The SqlDataAdapter Object and DataSet objects are combine to perform both data access and data manipulation operations in the SQL Server Database. When the user perform the SQL operations like Select , Insert etc. in the data containing in the Dataset Object , it won't directly affect the Database, until the user invoke the Update method in the SqlDataAdapter.

Full Source C#
using System; using System.Windows.Forms; using System.Data; using System.Data.SqlClient; namespace WindowsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { string connetionString = null; SqlConnection sqlCnn ; SqlCommand sqlCmd ; SqlDataAdapter adapter = new SqlDataAdapter(); DataSet ds = new DataSet(); int i = 0; string sql = null; connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password"; sql = "Select * from product"; sqlCnn = new SqlConnection(connetionString); try { sqlCnn.Open(); sqlCmd = new SqlCommand(sql, sqlCnn); adapter.SelectCommand = sqlCmd; adapter.Fill(ds); for (i = 0; i <= ds.Tables[0].Rows.Count - 1; i++) { MessageBox.Show(ds.Tables[0].Rows[i].ItemArray[0] + " -- " + ds.Tables[0].Rows[i].ItemArray[1]); } adapter.Dispose(); sqlCmd.Dispose(); sqlCnn.Close(); } catch (Exception ex) { MessageBox.Show("Can not open connection ! "); } } } }







Related Topics
  1. C# ADO.NET Connection
  2. C# SQL Server Connection
  3. C# OLEDB Connection
  4. C# ODBC Connection
  5. C# ADO.NET Command
  6. C# ADO.NET SqlCommand - ExecuteNonQuery
  7. C# ADO.NET OleDbCommand - ExecuteNonQuery
  8. C# ADO.NET SqlCommand - ExecuteScalar
  9. C# ADO.NET OleDbCommand - ExecuteScalar
  10. C# ADO.NET SqlCommand - ExecuteReader
  11. C# ADO.NET OleDbCommand - ExecuteReader
  12. C# ADO.NET DataReader
  13. C# ADO.NET SqlDataReader
  14. C# ADO.NET OleDbDataReader
  15. C# Multiple Result Sets
  16. C# Table Schema from SqlDataReader
  17. C# Table Schema from OleDbDataReader
  18. C# ADO.NET DataAdapter
  19. C# ADO.NET OleDbDataAdapter
  20. C# ExecuteReader and ExecuteNonQuery
  21. System.Data.SqlClient.SqlException: Login failed for user


Related Topics
  1. Stored Procedures in C#
  2. C# Stored Procedure with Parameter