C#

SqlCommand cmd = new SqlCommand();<br />
cmd.Connection = new SqlConnection(strConnectSQL);<br />
cmd.CommandText = SQLString;<br />
cmd.Parameters.Add ("@PartID", partNumber);

leckey wrote:

do I have to go through the SqlCommand cmd = new SqlCommand again?

private void btnSearchPartNumber_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInput = txtPartNumber.Text;<br />
			int partNumber = Convert.ToInt32(strPartNumberInput);//THIS IS WRONG. First, partNumber is a varchar so can get rid of this. But need the Parts.ID which is a number.<br />
			string SQLString = "Select * FROM Costs where Costs.PartID = @PartID"; <br />
			SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			cmd.Parameters.Add ("@PartID", partNumber);<br />
			BindGrid (strConnectSQL, SQLString, DataGrid1 );<br />
		}

private void btnSearchPartNumber_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInput = txtPartNumber.Text;<br />
			int partNumber = Convert.ToInt32(strPartNumberInput);<br />
			string SQLString = "Select * FROM Costs c INNER JOIN Parts p ON c.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", partNumber);<br />
			BindGrid (strConnectSQL, SQLString, DataGrid1 );<br />
		}

private void btnSearchPartNumber_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInput = txtPartNumber.Text;<br />
			int partNumber = Convert.ToInt32(strPartNumberInput);<br />
			string SQLString = "Select * FROM Costs c INNER JOIN Parts p ON c.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", partNumber);<br />
			//BindGrid (strConnectSQL, SQLString, DataGrid1 );<br />
			BindGrid (strConnectSQL, cmd, DataGrid1);<br />
		}

BindGrid(cmd, DataGrid1);

private void BindGrid (SqlCommand cmd, System.Web.UI.WebControls.DataGrid DGrid)
{
    // create data adapter
    SqlDataAdapter adapter = new SqlDataAdapter(command);
 
    // create and fill dataset 
    DataSet ds = new DataSet();
    adapter.Fill(ds);
 
    // fill and bind data to Datagrid
    DGrid.DataSource = ds;
    DGrid.DataBind();

    // Close Connection
    conn.Close();
}

leckey wrote:

Since 'conn' is not in BindGrid, I'm not sure what to close

rcwoods wrote:

In my CustomerTabPage class, acustomer.Name brings back a null value.