Beispiel #1
0
 public static DataTable getTableName()
 {
     DatabaseClass.createconnection();
     tablelist = DatabaseClass.getConnection().GetSchema("Tables");
     DatabaseClass.closeConnection();
     return(tablelist);
 }
Beispiel #2
0
        //It executes non queries like: INSERT AND UPDATE statements
        public static void ExecuteNonQuery(String query)
        {
            DatabaseClass.createconnection();
            SqlDataAdapter adp         = new SqlDataAdapter(query, DatabaseClass.connection);
            SqlCommand     dataCommand = DatabaseClass.connection.CreateCommand();

            dataCommand.CommandText = query;
            dataCommand.ExecuteNonQuery();
            DatabaseClass.closeConnection();
        }
Beispiel #3
0
        //It returns all the data inside the given table
        public static DataSet getTableDatafromTable(String tableName)
        {
            DatabaseClass.createconnection();
            String sqlquerydata = "SELECT * FROM [" + tableName + " ];";

            datatableadapter = new SqlDataAdapter(sqlquerydata, DatabaseClass.connection);
            DatabaseClass.closeConnection();
            dsData = new DataSet();
            datatableadapter.Fill(dsData, "datatableall");
            return(dsData);
        }
 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);
 }
Beispiel #5
0
        //Inserts a row and returns the output value (i.e. primary key of the newly inserted row)
        public static int ExecuteNonQueryAndGetInt(String query)
        {
            DatabaseClass.createconnection();
            SqlDataAdapter adp         = new SqlDataAdapter(query, DatabaseClass.connection);
            SqlCommand     dataCommand = DatabaseClass.connection.CreateCommand();

            dataCommand.CommandText = query;
            int id = (int)(dataCommand.ExecuteScalar());

            DatabaseClass.closeConnection();
            return(id);
        }
Beispiel #6
0
        //It executes SELECT statements and returns the result in the form of DataTable
        public static DataTable ExecuteQuery(String s)
        {
            //Execute a query and return result in the form of DataTable
            DatabaseClass.createconnection();
            SqlDataAdapter adp = new SqlDataAdapter(s, DatabaseClass.connection);
            DataSet        ds  = new DataSet();

            adp.Fill(ds, "resultTable");
            resultTable = ds.Tables["resultTable"];
            DatabaseClass.closeConnection();
            return(resultTable);
        }