Fill DataGrid using SQL + C#

OK, I see. I was wrong. You declare SQLConnection as da. But SQLConnection class does not have Fill() method, so your code should never compile. This method belongs to SQLDataAdapter class. Try this: private void Form2_Load(object sender, System.EventArgs e) { SqlConnection da = new SqlConnection( @"Data Source= xxxxxxx;"+ "Initial Catalog = drmTest;" + "Network Library=DBMSSOCN;"+ "user id =xx;"+ "Password=xxxxx"); da.Open(); SqlCommand thisCommand = da.CreateCommand(); thisCommand.CommandText = "SELECT * FROM License"; Object countResult = thisCommand.ExecuteScalar(); DataSet ds = new DataSet(); sqlDataAdapter1 = new SQLDataAdapter("SELECT * FROM License", da); sqlDataAdapter1.Fill(ds, "License"); dataGrid1.DataSource = ds.Tables["License"].DefaultView ; da.Close(); }

The Full Code: using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data.SqlClient; using System.Data; namespace WindowsApplication3 { ///

/// Summary description for Form2. ///

public class Form2 : System.Windows.Forms.Form { private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1; private System.Data.SqlClient.SqlCommand sqlSelectCommand1; private System.Data.SqlClient.SqlCommand sqlInsertCommand1; private System.Data.SqlClient.SqlConnection sqlConnection1; private System.Windows.Forms.DataGrid dataGrid1; ///

/// Required designer variable. ///

private System.ComponentModel.Container components = null; public Form2() { // // Required for Windows Form Designer support // InitializeComponent(); // // TODO: Add any constructor code after InitializeComponent call // } ///

/// Clean up any resources being used. ///

protected override void Dispose( bool disposing ) { if( disposing ) { if(components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code ///

/// Required method for Designer support - do not modify /// the contents of this method with the code editor. ///

private void InitializeComponent() { this.dataGrid1 = new System.Windows.Forms.DataGrid(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit(); this.SuspendLayout(); // // dataGrid1 // this.dataGrid1.DataMember = ""; this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid1.Location = new System.Drawing.Point(8, 8); this.dataGrid1.Name = "dataGrid1"; this.dataGrid1.Size = new System.Drawing.Size(536, 360); this.dataGrid1.TabIndex = 0; this.dataGrid1.Navigate += new System.Windows.Forms.NavigateEventHandler(this.dataGrid1_Navigate); // // Form2 // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(552, 373); this.Controls.Add(this.dataGrid1); this.Name = "Form2"; this.Text = "Form2"; this.Load += new System.EventHandler(this.Form2_Load); ((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit(); this.ResumeLayout(false); } #endregion private void Form2_Load(object sender, System.EventArgs e) { SqlConnection da = new SqlConnection( @"Data Source= xxxxxxx;"+ "Initial Catalog = drmTest;" + "Network Library=DBMSSOCN;"+ "user id =xx;"+ "Password=xxxxx"); da.Open(); SqlCommand thisCommand = da.CreateCommand(); thisCommand.CommandText = "SELECT * FROM License"; Object countResult = thisCommand.ExecuteScalar(); DataSet ds = new DataSet(); da.Fill(ds, "License"); dataGrid1.DataSource = ds.Tables["License"].DefaultView ; da.Close(); } private void dataGrid1_Navigate(object sender, System.Windows.Forms.NavigateEventArgs ne) { } } }