DataAdapter Select Command - Sql Server

The SqlDataAdapter, which is an integral component of the ADO.NET Data Provider, facilitates the communication between the Dataset and the Data Source by utilizing the SqlConnection Object. It plays a vital role in establishing a connection and retrieving data from the data source, working seamlessly with the DataSet to provide a disconnected data retrieval mechanism.

SelectCommand property

The SqlDataAdapter's SelectCommand property represents a Command object responsible for retrieving data from the data source. To populate a DataSet with the results obtained from the SelectCommand, the Fill method of the DataAdapter is utilized. The Fill method accepts arguments such as a DataSet to be populated and a DataTable object (or the name of the DataTable) to be filled with the rows returned from the SelectCommand. By using these functionalities, the SqlDataAdapter streamlines the process of retrieving and populating data within a DataSet, promoting efficient data management and manipulation.The following C# program shows the SqlDataAdapter using its SelectCommand property to retrieve the data from the Data Source.

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 = new SqlDataAdapter(); 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.SelectCommand = new SqlCommand("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[1].ItemArray[1].ToString()); } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } } }