ASP.NET

using System;<br />
using System.Collections;<br />
using System.ComponentModel;<br />
using System.Data;<br />
using System.Drawing;<br />
using System.Web;<br />
using System.Web.SessionState;<br />
using System.Web.UI;<br />
using System.Web.UI.WebControls;<br />
using System.Web.UI.HtmlControls;<br />
using System.Data.SqlClient;<br />
using System.Configuration;<br />
<br />
namespace WebBasedPartsDB<br />
{<br />
	/// <summary><br />
	/// Summary description for WebForm2.<br />
	/// </summary><br />
	public class WebForm2 : System.Web.UI.Page<br />
	{<br />
		protected System.Web.UI.WebControls.TextBox txtSearchPart2;<br />
		protected System.Web.UI.WebControls.DataGrid DataGrid2;<br />
		protected System.Web.UI.WebControls.Button btnSearch2;<br />
		protected string strPartNumberInput2;<br />
<br />
		//Get the SQL connection string from the web.config file<br />
		public String strConnectSQL = (ConfigurationSettings.AppSettings["ConnectionString"]);<br />
	<br />
		private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			// Put user code to initialize the page here<br />
		}<br />
<br />
		#region Web Form Designer generated code<br />
		override protected void OnInit(EventArgs e)<br />
		{<br />
			//<br />
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.<br />
			//<br />
			InitializeComponent();<br />
			base.OnInit(e);<br />
		}<br />
		<br />
		/// <summary><br />
		/// Required method for Designer support - do not modify<br />
		/// the contents of this method with the code editor.<br />
		/// </summary><br />
		private void InitializeComponent()<br />
		{    <br />
			this.btnSearch2.Click += new System.EventHandler(this.btnSearch2_Click);<br />
			this.DataGrid2.SelectedIndexChanged += new System.EventHandler(this.DataGrid2_SelectedIndexChanged);<br />
			this.Load += new System.EventHandler(this.Page_Load);<br />
<br />
		}<br />
		#endregion<br />
<br />
		private void btnSearch2_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInput2 = txtSearchPart2.Text;<br />
			string SQLString = "SELECT c.cost, c.costtypeid, ct.description, pt.description as ptDescription FROM costs c INNER JOIN Parts p ON c.PartID = p.Id INNER JOIN PartTypes pt on pt.ID = p.PartTypeID INNER JOIN CostTypes ct on ct.ID = c.costtypeid WHERE p.PartNumber = @PartID";<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 INNER 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", strPartNumberInput2);<br />
			BindGrid(cmd, DataGrid2);<br />
		}<br />
<br />
	<br />
		//**********************************************************<br />
		//BindGrid()<br />
		//**********************************************************<br />
		private void BindGrid (SqlCommand command, System.Web.UI.WebControls.DataGrid DGrid)<br />
		{<br />
			SqlDataAdapter adapter = new SqlDataAdapter(command);<br />
			DataSet ds = new DataSet();<br />
			adapter.Fill(ds);<br />
			DGrid.DataSource = ds;<br />
			DGrid.DataBind();<br />
<br />
		}<br />
<br />
		private void DataGrid2_SelectedIndexChanged(object sender, System.EventArgs e)<br />
		{<br />
		<br />
		}<br />
			<br />
	}<br />
}