Advertisement
Guest User

Untitled

a guest
Oct 22nd, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.68 KB | None | 0 0
  1.             SqlDataAdapter da2 = NEW SqlDataAdapter();
  2.             SqlCommand cmd = NEW SqlCommand();
  3.             cmd.CommandText = "SELECT * FROM dataraw WHERE TagID = '101010' AND  Date_Time >= @p_StartDate AND Date_Time < @p_EndDate";
  4.             cmd.Parameters.ADD("@p_StartDate", SqlDbType.DateTime).VALUE = dateTimePicker1.VALUE.DATE;
  5.             cmd.Parameters.ADD("@p_EndDate", SqlDbType.DateTime).VALUE = dateTimePicker2.VALUE.DATE.AddDays(1);
  6.             cmd.Connection = conn;
  7.             da2.SelectCommand = cmd;
  8.             da2.Fill(ds1, "statusloei1");
  9.             dv1 = NEW DataView(ds1.TABLES["statusloei1"]);
  10.             dataGridView1.DataSource = ds1.TABLES["statusloei1"];
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement