I am currently working on a database that has 21 text box inputs and 25 check boxes. I would like to be able to execute a select statement that would populate the text boxes with the correct text as well as populate any check boxes that have the value of one in the database. I am able to search and get the results to the text boxes just fine , however I cannot seem to get a check to pop up when expected. On the database side I have the data types of the check boxes as int , where 1 = checked and 0 = unchecked. Here is a snippet of my code for my select statement.
SqlConnection con = new SqlConnection(@"Data Source=CD-FS02;Initial Catalog=engineering;Integrated Security=True");
SqlDataAdapter da;
DataTable ss = new DataTable();
private void btnSearch_Click(object sender, EventArgs e)
{
con.Open();
string str = "select * from engineering where (JobNumber like '%' + @search + '%' "
+ "AND DateOrdered like '%' + @search1 + '%' "
+ "AND Title like '%' + @search2 + '%' "
+ "AND PhysicalAddressComplete like '%' + @search3 + '%' "
+ "AND County like '%' + @search4 + '%' "
+ "AND Client like '%' + @search5 + '%' "
+ "AND Contact like '%' + @search6 + '%' "
+ "AND ContactTitle like '%' + @search7 + '%' "
+ "AND MailingAddressComplete like '%' + @search8 + '%' "
+ "AND BusinessPhone like '%' + @search9 + '%' "
+ "AND CellPhone like '%' + @search10 + '%' "
+ "AND Email like '%' + @search11 + '%' "
+ "AND OpenStatus like '%' + @search12 + '%' "
+ "AND CloseStatus like '%' + @search13 + '%' "
+ "AND Cabinet like '%' + @search14 + '%' "
+ "AND Roll like '%' + @search15 + '%' "
+ "AND Drawer like '%' + @search16 + '%' "
+ "AND ConstructionDrawings like '%' + @search17 + '%' "
+ "AND Fee like '%' + @search18 + '%' "
+ "AND ConstructionCost like '%' + @search19 + '%' "
+ "AND ProjectDescription like '%' + @search20 + '%' )";
SqlCommand xp = new SqlCommand(str, con);
xp.Parameters.Add("@search", SqlDbType.NVarChar).Value = txtProjectNumber.Text;
xp.Parameters.Add("@search1", SqlDbType.NVarChar).Value = txtDateOrdered.Text;
xp.Parameters.Add("@search2", SqlDbType.NVarChar).Value = txtProjectName.Text;
xp.Parameters.Add("@search3", SqlDbType.NVarChar).Value = txtProjectAddress.Text;
xp.Parameters.Add("@search4", SqlDbType.NVarChar).Value = txtCounty.Text;
xp.Parameters.Add("@search5", SqlDbType.NVarChar).Value = txtClient.Text;
xp.Parameters.Add("@search6", SqlDbType.NVarChar).Value = txtClientContact.Text;
xp.Parameters.Add("@search7", SqlDbType.NVarChar).Value = txtContactTitle.Text;
xp.Parameters.Add("@search8", SqlDbType.NVarChar).Value = txtBillingAddress.Text;
xp.Parameters.Add("@search9", SqlDbType.NVarChar).Value = txtBusinessPhone.Text;
xp.Parameters.Add("@search10", SqlDbType.NVarChar).Value = txtCellPhone.Text;
xp.Parameters.Add("@search11", SqlDbType.NVarChar).Value = txtEmail.Text;
xp.Parameters.Add("@search12", SqlDbType.NVarChar).Value = txtOpenStatus.Text;
xp.Parameters.Add("@search13", SqlDbType.NVarChar).Value = txtCloseStatus.Text;
xp.Parameters.Add("@search14", SqlDbType.NVarChar).Value = txtCabinet.Text;
xp.Parameters.Add("@search15", SqlDbType.NVarChar).Value = txtRoll.Text;
xp.Parameters.Add("@search16", SqlDbType.NVarChar).Value = txtDrawer.Text;
xp.Parameters.Add("@search17", SqlDbType.NVarChar).Value = txtDrawings.Text;
xp.Parameters.Add("@search18", SqlDbType.NVarChar).Value = txtFee.Text;
xp.Parameters.Add("@search19", SqlDbType.NVarChar).Value = txtCost.Text;
xp.Parameters.Add("@search20", SqlDbType.NVarChar).Value = txtProjectDescription.Text;
try
{
xp.ExecuteNonQuery();
da = new SqlDataAdapter();
da.SelectCommand = xp;
da.Fill(ss);
Showdata(pos);
if ((int)ss.AsEnumerable().First()["engineering"] == 1)
{
this.chkDesign.Checked = false;
}
else
{
this.chkDesign.Checked = true;
}
}
catch
{
MessageBox.Show("No Record Found");
}
con.Close();
}
Any help or knowledge on this would be appreciated.
Aucun commentaire:
Enregistrer un commentaire