C#

protected void dg_bind() {<br />
<br />
System.Data.SqlClient.SqlConnection SqlCon = new System.Data.SqlClient.SqlConnection( "server=localhost;database=northwind;trusted_connection=true;" );<br />
System.Data.SqlClient.SqlDataAdapter SqlDa = new System.Data.SqlClient.SqlDataAdapter( "SELECT TOP 10 ProductName FROM Products", SqlCon );<br />
ds = new System.Data.DataSet( );<br />
SqlDa.Fill( ds, "Products" );<br />
System.Data.DataRow BlankRow = ds.Tables[ "Products" ].NewRow( );<br />
BlankRow[ "ProductName" ] = "<font color=\"red\">add new product</font>";<br />
ds.Tables[ "Products" ].Rows.InsertAt( BlankRow, 0 );<br />
dg.DataSource = ds.Tables[ "Products" ];<br />
}

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtPartNumberInput.Text;<br />
			string SQLString = "SELECT c.cost, pt.description, dd.DrawingNumber, dd.DrawingRevision, dd.DwgPath FROM costs c INNER JOIN Parts p ON c.PartID = p.Id INNER JOIN PartTypes pt on pt.ID = p.PartTypeID LEFT JOIN DraftingData dd on dd.PartID = p.ID  WHERE p.PartNumber = @PartID";<br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", strPartNumberInputReference);<br />
			SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
			DataSet ds = new DataSet();<br />
			adapter.Fill(ds);<br />
			dgParts.DataSource = ds;<br />
			dgParts.DataBind();<br />
		}