Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
5
Reply
Search Query with multiple fields Winforms
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Rose Rouge
8 years ago
302
1
Reply
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;
}
}
Please help me !
Thanks in Advance.
Post
Reset
Cancel
Answers (
5
)
Next Recommended Forum
add two Binary number
How can i Datagridview column format