I need to write a SQL Query for search with multiple fields .
I wrote this sql query but i can't make it work correctly
(User select check-box, choose a date between two dates and select Client Name from ComboBox.)
My query something like this :
- private void btnRechercher_Click(object sender, EventArgs e)
- {
- if (radBtnExport.Checked==true||radBtnImport.Checked==true||radBtnTransit.Checked==true||dateFin.Value>dateDebut.Value||comboBox1.SelectedValue.ToString()=="")
- {
- SqlConnection con = new SqlConnection("Data Source=Admin-PC\\SQLEXPRESS;Initial Catalog=timar;Integrated Security=True");
- SqlDataAdapter sda = new SqlDataAdapter("Select * from Devis_C_L,Client where Devis_C_L.ClientId = Client.idClient and NomClient='" + comboBox1.Text + "' or Sense='Transit' or Sense='Export' or Sense='Import' and DateTransport between '" + dateDebut.Value.Date.ToShortDateString() + "' and'" + dateFin.Value.Date.ToShortDateString() + "' ", con);
- DataTable dt = new DataTable();
- sda.Fill(dt);
- dataGridView1.DataSource = dt;
- }
- }
Thanks in Advance.
ketan borsdiyaPosted Jun 30, 2016, 6:34 AM
Rose RougePosted Jun 30, 2016, 6:24 AM
Rose RougePosted Jun 30, 2016, 5:52 AM
Vinay SinghPosted Jun 30, 2016, 5:38 AM
- SqlDataAdapter sda = new SqlDataAdapter("Select * from Devis_C_L,Client where Devis_C_L.ClientId = Client.idClient and NomClient='" + comboBox1.Text + "' and (Sense='Transit' or Sense='Export' or Sense='Import' ) and DateTransport between '" + dateDebut.Value.Date.ToShortDateString() + "' and'" + dateFin.Value.Date.ToShortDateString() + "' ", con);
Please check the bold part of the code. just apply bracket and then checkMunesh SharmaPosted Jun 30, 2016, 5:33 AM
SqlDataAdapter ad =
new SqlDataAdapter("SELECT name FROM DATABASENAME WHERE columnname >= @Date1 AND modified_time <= @Date2", ssl);
ad.SelectCommand.Parameters.AddWithValue("@Date1", dateTimePicker1.Value);
ad.SelectCommand.Parameters.AddWithValue("@Date2", dateTimePicker2.Value);
string a = dateTimePicker1.Value.ToString("yyyy-MM-dd");
string b = dateTimePicker2.Value.ToString("yyyy-MM-dd");
string query = "SELECT name FROM DATABASENAME WHERE columnname >='" + a + "' AND modified_time <= '" + b + "'";
SqlDataAdapter ad = new SqlDataAdapter (query, ssl);