lundi 19 juin 2017

Getting checks to populate in checkboxes after select statement has been executed in c#

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