public int CreateTable( ) { string tab = t.CreateTableScript(); SqlCommand cmd = new SqlCommand(tab, DB.DBCon); return(cmd.ExecuteNonQuery()); }
public void CreateTable( ) { string sqlQ = t.CreateTableScript(); SqlCommand cmd = Db.DBCon.CreateCommand(); cmd.CommandText = sqlQ; Console.WriteLine("Sql=" + sqlQ); Console.WriteLine("Table Creation is ", cmd.ExecuteNonQuery()); }
public ExpensesDB( ) { tableDetails = new TableClass(typeof(BankDetails)); DetailTableName = tableDetails.ClassName; InsertDetailsSqlQuery = tableDetails.CreateInsertScript(); if (!IsTableExist(DetailTableName)) { CreateTable(tableDetails.CreateTableScript()); } }
public int CreateTable( ) { SqlCommand cmd = new SqlCommand(table.CreateTableScript(), Db.DBCon); return(cmd.ExecuteNonQuery()); }