/// <summary>
/// 判断表存在不
/// </summary>
/// <param name="TableName"></param>
/// <returns></returns>
public static bool ExistTable(string TableName, string DataBase)
{
DbBase db = new DbBase();
string sql = "select COUNT( *) from sysobjects where id = OBJECT_ID('[" + TableName + "]')";
return((int)db.ChangeDB(DataBase).ExecuteScalar(sql) > 0);
}
public static void CreateTable(DataSet ds, string TableName, string DataBase)
{
StringBuilder sb = new StringBuilder();
sb.Append("CREATE TABLE [" + TableName + "](");
foreach (System.Data.DataRow item in ds.Tables[0].Rows)
{
sb.Append(string.Format("[{0}] [{1}] {2} {3},", item["ColName"], item["ColTypeName"], GetLen(item["ColTypeName"].ToString(), int.Parse(item["length"].ToString())), int.Parse(item["AllowNull"].ToString()) == 1 ? "NULL" : "NOT NULL"));
}
sb.Remove(sb.Length - 1, 1);
sb.Append(")");
DbBase db = new DbBase();
db.ChangeDB(DataBase).ExecuteNonQuery(sb.ToString());
}
