public static DataTable getTableName() { DatabaseClass.createconnection(); tablelist = DatabaseClass.getConnection().GetSchema("Tables"); DatabaseClass.closeConnection(); return(tablelist); }
public static DataTable GetSchemaNameOfTable(String tableName) { DatabaseClass.createconnection(); sqlquery = "SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" + tableName + "';"; adp = new SqlDataAdapter(sqlquery, DatabaseClass.getConnection()); ds = new DataSet(); adp.Fill(ds, "datatableall"); datatable = ds.Tables["datatableall"]; DatabaseClass.closeConnection(); return(datatable); }