Advertisement
Guest User

Untitled

a guest
Jun 5th, 2015
226
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.39 KB | None | 0 0
  1. public class Connect {
  2. SqlConnection con;
  3. public Connect() {
  4. con = new SqlConnection(Connection String);
  5. if(con.state == ConnectionState.Closed) con.open();
  6. }
  7.  
  8.  
  9. public DataTable doQuery(String query) {
  10. DataTable dt;
  11. SqlDataAdapter da = dt.execute(query, con);
  12. try {
  13. da.fill(dt);
  14. }catch(Execption E)
  15. {
  16. mbox E.getMessage();
  17. dt = null;
  18. }
  19. return dt;
  20.  
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement