C#

using System.Runtime.InteropServices;<br />
<br />
public class MyCaret<br />
{<br />
<br />
[DllImport("user32.dll")]<br />
public static extern int ShowCaret(IntPtr hwnd);<br />
<br />
[DllImport("user32.dll")]<br />
public static extern int HideCaret(IntPtr hwnd);<br />
<br />
}

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtSearchPart.Text;<br />
			ds = new DataSet();<br />
			//SqlParameter param = new SqlParameter("@PartID", strPartNumberInputReference);<br />
			ds=SqlHelper.ExecuteDataset(this.connectionString, "dbo.GetPartInfo", param);<br />
			Session["ds"]=ds;<br />
			dt = ds.Tables[0];<br />
			Session["dt"]=dt;<br />
			dgParts.DataSource=dt;<br />
			dgParts.DataBind();<br />
			txtSearchPart.Text = "";<br />
			<br />
		}

public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters)<br />
		{<br />
			SqlCommand cmd = new SqlCommand();<br />
			PrepareCommand(cmd, connection, (SqlTransaction)null, commandType, commandText, commandParameters);<br />
			SqlDataAdapter da = new SqlDataAdapter(cmd);<br />
			DataSet ds = new DataSet();<br />
			da.Fill(ds);			<br />
			// detach the SqlParameters from the command object, so they can be used again.			<br />
			cmd.Parameters.Clear();<br />
			<br />
			//return the dataset<br />
			return ds

private void BindData()<br />
		{<br />
			 ds = new DataSet();<br />
			ds= SqlHelper.ExecuteDataset(this.connectionString, "dbo.GetEmployees", null);<br />
			Session["ds"]=ds;<br />
			dt = ds.Tables[0];<br />
			Session["dt"]=dt;<br />
			DataGrid1.DataSource=dt;<br />
			DataGrid1.DataBind();<br />
			<br />
		}

private void BindData2()<br />
		{<br />
			strPartNumberInputReference = txtPartNumberInput.Text;<br />
			string SQLString = "SELECT c.cost, ct.Description AS ctDescription, p.PartNumber, 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 LEFT JOIN CostTypes ct on ct.Id = c.CostTypeId WHERE p.PartNumber = @PartID"; <br />
			<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 />
			adapter.Fill(ds);<br />
<br />
			<br />
			dgParts2.DataSource = ds;<br />
			dgParts2.DataBind();<br />
			txtPartNumberInput.Text = "";<br />
			<br />
		<br />
		}

CREATE PROCEDURE [dbo].[GetPartInfo]<br />
@PartID int AS<br />
SELECT c.cost, ct.Description AS ctDescription, p.PartNumber, pt.description, dd.DrawingNumber, dd.DrawingRevision, dd.DwgPath<br />
FROM costs c INNER JOIN Parts p ON c.PartID = p.Id <br />
INNER JOIN PartTypes pt on pt.ID = p.PartTypeID <br />
LEFT JOIN DraftingData dd on dd.PartID = p.ID LEFT JOIN CostTypes ct on ct.Id = c.CostTypeId <br />
WHERE p.PartNumber = @PartID;<br />
GO

public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)<br />
		{<br />
			//create & open a SqlConnection, and dispose of it after we are done.<br />
			using (SqlConnection cn = new SqlConnection(connectionString))<br />
			{<br />
				cn.Open();<br />
<br />
				//call the overload that takes a connection in place of the connection string<br />
				return ExecuteDataset(cn, commandType, commandText, commandParameters);<br />
			}<br />
		}