private bool IsTableExists(string tableName, bool isCreateNew)
{
bool returnval;
//string conString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
var con = new SqlConnection(conString);
string cmdString = SQLResources.Query_Tables + " where name = '" + tableName + "'";
var cmd = new SqlCommand(cmdString, con);
con.Open();
using (con)
{
object data = cmd.ExecuteScalar();
if (data != null)
{
returnval = true;
}
else
{
if (isCreateNew)
{
var stc = new SqlTableCreator(con);
stc.Create(tableName, 10);
}
returnval = false;
}
}
return(returnval);
}
public bool CreateNewTable(string tableName)
{
// string conString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
var con = new SqlConnection(conString);
con.Open();
var stc = new SqlTableCreator(con);
object obj = stc.Create(tableName, 0);
if (obj != null)
{
return(true);
}
return(false);
}
