C# (CSharp) DataVisualization.CodeBehind.Database DatabaseClass.getConnection 예제들

예제 #1

 public static DataTable getTableName()
 {
     DatabaseClass.createconnection();
     tablelist = DatabaseClass.getConnection().GetSchema("Tables");
     DatabaseClass.closeConnection();
     return(tablelist);
 }

예제 #2

파일: TableSchemaGenerator.cs 프로젝트: prakashdgl/DataFilteringAndVisualization

 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);
 }