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