Example #1
0
 public DataTable SelectQuery(string sqlstring)
 {
     try
     {
         DataTable _dt = new DataTable();
         sqlhelper.OpenConn();
         sqlhelper._adapter.SelectCommand.CommandText = sqlstring;
         sqlhelper._adapter.Fill(_dt);
         sqlhelper.CloseConn();
         return(_dt);
     }
     catch (Exception ex)
     {
         sqlhelper.CloseConn();
         return(null);
     }
 }