第 1 行: '-' 附近有语法错误-----怎么解决?
一运行到这总弹出错误[第 1 行: '-' 附近有语法错误],clientDataSet是DataGrid的数据源,listname是数据库中的表名,大家帮我看看是那里错了!
public void SendList(DataSet clientDataSet,string listname)
{
OleDbConnection listConn=new OleDbConnection("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=list;Data Source=(local);Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SHAKA;Use Encryption for Data=False;Tag with column collation when possible=False");
listConn.Open();
OleDbCommand createlist=new OleDbCommand("CREATE TABLE "+listname+" (ID INT NOT NULL UNIQUE,NAME CHAR(20) NOT NULL,SIZE CHAR(20) NOT NULL,UNIT CHAR(5) NOT NULL,NUMBER INT NOT NULL,REQUEST CHAR(20) NOT NULL,DESCRIPTION CHAR(20) )",listConn);
createlist.ExecuteNonQuery();
OleDbDataAdapter listDA=new OleDbDataAdapter("SELECT ID,NAME,SIZE,UNIT,NUMBER,REQUEST,DESCRIPTION FROM "+listname,listConn);
//INSERT
listDA.InsertCommand=new OleDbCommand("INSERT INTO "+listname+"(ID,NAME,SIZE,UNIT,NUMBER,REQUEST,DESCRIPTION) VALUES(@id,@name,@size,@unit,@number,@request,@description",listConn);
OleDbParameter para=listDA.InsertCommand.Parameters.Add("@id",OleDbType.Integer);
para.SourceColumn="ID";
para=listDA.InsertCommand.Parameters.Add("@name",OleDbType.Char);
para.SourceColumn="NAME";
para=listDA.InsertCommand.Parameters.Add("@size",OleDbType.Char);
para.SourceColumn="SIZE";
para=listDA.InsertCommand.Parameters.Add("@unit",OleDbType.Char);
para.SourceColumn="UNIT";
para=listDA.InsertCommand.Parameters.Add("@number",OleDbType.Integer);
para.SourceColumn="NUMBER";
para=listDA.InsertCommand.Parameters.Add("@request",OleDbType.Char);
para.SourceColumn="REQUEST";
para=listDA.InsertCommand.Parameters.Add("@description",OleDbType.Char);
para.SourceColumn="DESCRIPTION";
DataSet listDS=new DataSet();
listDA.Fill(listDS,listname);
listDS=clientDataSet.Copy();
//Update DataBase
listDA.Update(listDS,listname);
}