How to DataAdapter in Sql Server

SqlDataAdapter provides the communication between the Dataset and the Data Source with the help of SqlConnection Object . The SqlConnection Object has no information about the data it retrieves . Similarly a Dataset has no knowledge of the Data Source where the data coming from. So the SqlDataAdapter manage the communication between these two Objects.

A DataAdapter is used to retrieve data from a data source and populate tables within a DataSet. The DataAdapter also resolves changes made to the DataSet back to the data source. We can use Fill method of the SqlDataAdapter for populating data in a Dataset. The following c# source code shows a simple program that uses SqlDataAdapter to retrieve data from Data Source with the help of SqlConnection Object and populate the data in a Dataset .

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