Advertisement
Guest User

asp snippet

a guest
Aug 17th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.60 KB | None | 0 0
  1. string connectionString = @"Data Source=(LocalDB)\v11.0;AttachDbFilename=|DataDirectory|\dbITP.mdf;Integrated Security=True;Connect Timeout=30";
  2. using (SqlConnection connection = new SqlConnection(connectionString))
  3. {
  4.  
  5. if (comboBox1.Text == "User")
  6. {
  7. sda = new SqlDataAdapter("select * FROM [Table] WHERE (User LIKE '%" + textBox1.Text + "%')", connection);
  8. DataTable dt = new DataTable();
  9. sda.Fill(dt);
  10. tableDataGridView.DataSource = dt;
  11. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement