一个cs代码文件中有三个DataReader,其中前两个是以前做的用来查询数据用的,第三个用前两个DataReader查询到的结果添入数据库中,可是现在怎么也添不进去之后我用DataSet也不能插入数据SqlDataAdapter thisAdapter = new SqlDataAdapter(SQLstring, cn);
DataSet thisDataSet = new DataSet();
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(thisAdapter);
thisAdapter.Fill(thisDataSet, "LogInfo");
thisAdapter.Update(thisDataSet, "LogInfo");
DataSet thisDataSet = new DataSet();
SqlCommandBuilder commandBuilder = new SqlCommandBuilder(thisAdapter);
thisAdapter.Fill(thisDataSet, "LogInfo");
thisAdapter.Update(thisDataSet, "LogInfo");
thisAdapter.Fill(thisDataSet, "LogInfo");
thisAdapter.Update(thisDataSet, "LogInfo");
---------------------------------------
我都写好了啊,insert是这样写的:
string SQLstring = "Insert into [LogInfo](LogUser,LogDepart,ParentID,LogTime,LogIP)values('" + Session["UserName"].ToString() + "','" + departName + "','" + ParentID + "','" + DateTime.Now + "','" + Request.ServerVariables["REMOTE_ADDR"] + "')";
---------------------------------------
我前两个DataReader都关了啊,数据表也将自动增长列设置为主键,可是还是添不进数据,而且没有任何错误提示
string SQLstring = "Insert into [LogInfo](LogUser,LogDepart,ParentID,LogTime,LogIP)values('" + Session["UserName"].ToString() + "','" + departName + "','" + ParentID + "',cast('" + DateTime.Now + "' as datetime),'" + Request.ServerVariables["REMOTE_ADDR"] + "')";
这样试试
----------------------------------------------
还是不行,我个人认为还是那两个reader的原因,因为在两个reader之前插入数据的话就能插,而在之后就不能了