以下是我的代码,在form的button-click事件里添加就可以运行,可是到下面的执行创建表命令处就停下来,提示语法有错,但我实在找不出什么错误,因为同样这条语句在Access中运行的很好.请大家帮我看看哪有问题,谢谢!bool tableexist=false;
string myConnection ="Provider=sqloledb;data source=HK-RUANLEI;initial catalog=qqqq;integrated security=SSPI;persist security info=False;workstation id=HK-RUANLEI;packet size=4096";
OleDbConnection conn=new OleDbConnection(myConnection);
conn.Open();
DataTable schemaTable=conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,new object[] {null, null, null,"TABLE"});string createtable="CREATE TABLE APasCALBooks(mm CHAR(5)NOT NULL UNIQUE ,UserName CHAR(20), BookName CHAR(20),Xmin DOUBLE, Ymin DOUBLE, Xmax DOUBLE, Ymax DOUBLE)";string inserttable="INSERT INTO APasCALBooks(mm,UserName,BookName,Xmin,Ymin,Xmax,Ymax) Values('100', 'xiaozhu','book1',2134,31736,659,7639)";OleDbCommand myCommand=conn.CreateCommand();
OleDbCommand insertCommand=conn.CreateCommand();
myCommand.CommandText=createtable;
insertCommand.CommandText=inserttable;
try
{
if(schemaTable.Rows.Count==0)
{
myCommand.ExecuteNonQuery();
insertCommand.ExecuteNonQuery();
}
else
{
for(int i=0;i<schemaTable.Rows.Count;i++)
{
string name=schemaTable.Rows[i].ItemArray.GetValue(2).ToString();
if(name=="APasCALBooks")
tableexist=true;
}
if(tableexist==false)
{
myCommand.ExecuteNonQuery(); //调试异常对话框显示第一行附近","语法有错
insertCommand.ExecuteNonQuery();
}
else
{
insertCommand.ExecuteNonQuery();
}
}
}
catch(OleDbException ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
conn.Close();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货