public bool setKeyIsIdentity(string listname) { string sql = ""; sql = "ALTER TABLE " + listname + " ADD ID int IDENTITY(1, 1)"; try { DBHelperSQL.ExecuteNonQuery(sql); return(true); } catch { return(false); } }
public bool createTalbe(string tablename) { //添加表语句 string add_table = "create table [" + tablename + "] (ID varchar(50) not null primary key, modifycontent varchar(400), username varchar(50), LSH varchar(50), modifytime datetime)"; try { DBHelperSQL.ExecuteNonQuery(add_table); return(true); } catch { return(false); } }
public bool addkeyVacharMaxInList(string listname, string keyname) { string sql = ""; sql = "ALTER table [" + listname + "] ADD " + keyname + " varchar(MAX) null"; try { DBHelperSQL.ExecuteNonQuery(sql); return(true); } catch { return(false); } }
public bool addDateTimekeyInList(string listname, string keyname) { string sql = ""; sql = "ALTER table [" + listname + "] ADD " + keyname + " DATETIME null"; try { DBHelperSQL.ExecuteNonQuery(sql); return(true); } catch { return(false); } }
public bool createTalbe(string tablename, string addKeyString) { //添加表语句 string add_table = "create table [" + tablename + "] (" + addKeyString + ")"; try { DBHelperSQL.ExecuteNonQuery(add_table); return(true); } catch (Exception er) { ini.INIIO.saveLogInf("数据库语句异常:" + er.Message); return(false); } }