public static bool CreateTable(bool bAutoInc, string sSqlConn, string sTableName, string[] sFieldName, string[] sDataType, int[] iMaxLen, string[] sAllowNull) { bool bRet = true; try { string strSql = "Select * From sysobjects Where Type = 'U' and Name = '" + sTableName + "'"; if (IsTblExist(sSqlConn, strSql) == false) { string sqlCreateTbl = "Create Table " + sTableName + "("; if (bAutoInc == true) { sqlCreateTbl += "ID INT PRIMARY KEY IDENTITY(1,1),"; } for (int k = 0; k < sFieldName.Length; k++) { sqlCreateTbl += sFieldName[k] + " "; //字段名 sqlCreateTbl += sDataType[k]; //数据类型 if (iMaxLen[k] > 0) { sqlCreateTbl += "(" + iMaxLen[k].ToString() + ")"; } sqlCreateTbl += " "; if (k == 0 && bAutoInc == false) { sqlCreateTbl += "Primary Key"; //规定第一个为主键 } else { sqlCreateTbl += sAllowNull[k]; //是否允许为空 } if (k == sFieldName.Length - 1) { sqlCreateTbl += ")"; } else { sqlCreateTbl += ", "; } } TSqlDbClass.ExecuteNonQuerySql(sSqlConn, sqlCreateTbl); } } catch { bRet = false; } return(bRet); }
public static bool CreateTableByDateTime(string sSqlConn, string sTableName, string[] sFieldName, string[] sDataType, int[] iMaxLen, string[] sAllowNull) { bool bRet = true; try { string strSql = "Select * From sysobjects Where Type = 'U' and Name = '" + sTableName + "'"; if (IsTblExist(sSqlConn, strSql) == false) { string sqlCreateTbl = "Create Table " + sTableName + "(ID_DateTime Varchar(32) Primary Key,"; for (int k = 0; k < sFieldName.Length; k++) { sqlCreateTbl += sFieldName[k] + " "; //字段名 sqlCreateTbl += sDataType[k]; //数据类型 if (iMaxLen[k] > 0) { sqlCreateTbl += "(" + iMaxLen[k].ToString() + ")"; } sqlCreateTbl += " "; sqlCreateTbl += sAllowNull[k]; //是否允许为空 if (k == sFieldName.Length - 1) { sqlCreateTbl += ")"; } else { sqlCreateTbl += ", "; } } TSqlDbClass.ExecuteNonQuerySql(sSqlConn, sqlCreateTbl); } //else //Drop Table TblName } catch { bRet = false; } return(bRet); }