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. These functions enable the SqlDataAdapter to flawlessly recuperate and populate data into the DataSet, which in turn makes data management and manipulation easy and efficient.The below C# program uses SelectCommand property of SqlDataAdapter to fetch 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()); } } } }