Guest User

Untitled

a guest
Jul 17th, 2018
65
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. using (SqlConnection connection = new SqlConnection(Connection_sheets))
  2. {
  3. connection.Open();
  4.  
  5. SqlCommand cmd = new SqlCommand("select distinct [Sheet Code] from cell where [Table Code] = 'Table Number' order by [Sheet Code] asc", connection);
  6. SqlDataReader readert = cmd.ExecuteReader();
  7. }
  8.  
  9. DataRow newRow2 = _longDataTable.NewRow();
  10. newRow2.ItemArray = drlibrary.ItemArray;
  11.  
  12. newRow2["VariableTableCode"] = tableName;
  13. newRow2["VariableRowCode"] = ssRowNoBars;
  14. newRow2["VariableColumnCode"] = ssColumnNoBars;
  15.  
  16. _longDataTable.Rows.Add(newRow2);
Add Comment
Please, Sign In to add comment