为什么用ADOX创建ACCESS数据库及表正常,但有时不能为表添加主键? 如题,在开发的机器上没任何问题,但打包安装到客户的机器上,就出现问题了,但并不是所有的机器都会出问题?请高人指教!! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 下面是我的代码,createtl是创建表,createkey是创建主键,不知那出错了?using ADOX;public bool createtl(string tlname,string fromtlname,string prkey) { try { using (OleDbConnection conn1 = new OleDbConnection(conn.connstr.connstring)) { string strsql = "select * into " + tlname + " from " + fromtlname; conn1.Open(); OleDbCommand mycomm = new OleDbCommand(strsql, conn1); mycomm.ExecuteNonQuery(); //string strssql2 = "Alter table " + tlname + " add primary key [xjh]"; //OleDbCommand mycomm2 = new OleDbCommand(strsql, conn1); //mycomm2.ExecuteNonQuery(); createkey(tlname,prkey); //if (!havexxdmincxtj(tlname)) //{ // insetxxdm(tlname); //} } } catch (Exception e) { //MessageBox.Show(e.Message.ToString()); return false; } return true; }private void createkey(string tlname,string prkey) { ADOX.Catalog catalog = new Catalog(); ADODB.Connection cn = new ADODB.Connection(); cn.Open(jlsxjgl09.conn.connstr.connstring, null, null, -1); catalog.ActiveConnection = cn; ADOX.Table mytl; mytl = catalog.Tables[tlname]; mytl.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, prkey, "", ""); System.Runtime.InteropServices.Marshal.ReleaseComObject(mytl); System.Runtime.InteropServices.Marshal.ReleaseComObject(catalog); mytl = null; catalog = null; } C# imageList控件导入图片失真问题 WCF并发的问题 求可与.net进行数据绑定的flex生成中国地图文件,能够区别各省的 编程在线 求大神帮助! 求助大虾 Pointer.Box使用问题 请对datagrid和tree熟悉的前辈指教(如何将datagrid,tree整和到一起) Web页面中文显示不对 为什么用DataAdapter的Update方法更新数据库总是不行? 4个表做联合查询 C# 打印单据的问题
public bool createtl(string tlname,string fromtlname,string prkey)
{
try
{
using (OleDbConnection conn1 = new OleDbConnection(conn.connstr.connstring))
{
string strsql = "select * into " + tlname + " from " + fromtlname;
conn1.Open();
OleDbCommand mycomm = new OleDbCommand(strsql, conn1);
mycomm.ExecuteNonQuery();
//string strssql2 = "Alter table " + tlname + " add primary key [xjh]";
//OleDbCommand mycomm2 = new OleDbCommand(strsql, conn1);
//mycomm2.ExecuteNonQuery();
createkey(tlname,prkey);
//if (!havexxdmincxtj(tlname))
//{
// insetxxdm(tlname);
//} }
}
catch (Exception e)
{
//MessageBox.Show(e.Message.ToString());
return false; } return true;
}
private void createkey(string tlname,string prkey)
{
ADOX.Catalog catalog = new Catalog();
ADODB.Connection cn = new ADODB.Connection();
cn.Open(jlsxjgl09.conn.connstr.connstring, null, null, -1);
catalog.ActiveConnection = cn;
ADOX.Table mytl;
mytl = catalog.Tables[tlname];
mytl.Keys.Append("PrimaryKey", ADOX.KeyTypeEnum.adKeyPrimary, prkey, "", ""); System.Runtime.InteropServices.Marshal.ReleaseComObject(mytl);
System.Runtime.InteropServices.Marshal.ReleaseComObject(catalog);
mytl = null;
catalog = null; }