代码如下:
string sqlstr1,sqlstr2;
sqlstr1="insert into test (条码,阅览室ID,时间,单位) values(@kahao,@ReadroomName,@time,@danwei)";
sqlstr2="select 单位 from 读者表 where 条码=@kahao";
SqlCommand cm1=new SqlCommand(sqlstr1,sqlcon);
SqlCommand cm2=new SqlCommand(sqlstr2,sqlcon);
cm2.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm2.Parameters["@kahao"].Value=txbid.Text;
SqlDataAdapter da1 = new SqlDataAdapter(sqlstr2,sqlcon);
da1.SelectCommand=cm2;
DataSet ds1 = new DataSet();
da1.Fill(ds1,"读者表");
cm1.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@ReadroomName",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@time",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@danwei",SqlDbType.VarChar,50));
cm1.Parameters["@kahao"].Value=txbid.Text;
cm1.Parameters["@ReadroomName"].Value=drpdn.SelectedItem.Value;
cm1.Parameters["@time"].Value=DateTime.Now.ToString();
cm1.Parameters["@danwei"].Value=ds1.Tables[0].Rows[0][0].ToString();
cm1.Connection.Open();
cm1.ExecuteNonQuery();
cm1.Connection.Close();
调试通过,但是运行的时候总说我这句有问题:da1.Fill(ds1,"读者表");
为什么呀?烦死了
string sqlstr1,sqlstr2;
sqlstr1="insert into test (条码,阅览室ID,时间,单位) values(@kahao,@ReadroomName,@time,@danwei)";
sqlstr2="select 单位 from 读者表 where 条码=@kahao";
SqlCommand cm1=new SqlCommand(sqlstr1,sqlcon);
SqlCommand cm2=new SqlCommand(sqlstr2,sqlcon);
cm2.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm2.Parameters["@kahao"].Value=txbid.Text;
SqlDataAdapter da1 = new SqlDataAdapter(sqlstr2,sqlcon);
da1.SelectCommand=cm2;
DataSet ds1 = new DataSet();
da1.Fill(ds1,"读者表");
cm1.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@ReadroomName",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@time",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@danwei",SqlDbType.VarChar,50));
cm1.Parameters["@kahao"].Value=txbid.Text;
cm1.Parameters["@ReadroomName"].Value=drpdn.SelectedItem.Value;
cm1.Parameters["@time"].Value=DateTime.Now.ToString();
cm1.Parameters["@danwei"].Value=ds1.Tables[0].Rows[0][0].ToString();
cm1.Connection.Open();
cm1.ExecuteNonQuery();
cm1.Connection.Close();
调试通过,但是运行的时候总说我这句有问题:da1.Fill(ds1,"读者表");
为什么呀?烦死了
解决方案 »
- 关于Menu!
- 我在使用一个日期控件时,出现以下错误:无法创建控件,因为Visual studio无法在控件程序集中找到该控件的类型
- Repeater的数据源是个二维数组,如何分别绑定?
- [高分求助]选定gridview某行在detailsview显示的问题, 用自己写objectdatasource
- 请问如何用浏览器的滚动条去控制iframe中的滚动条的滚动?
- SOS!如何解决:程序集清单定义与程序集引用不匹配
- MVC RequireHttps 使用https
- 关于算法
- 急!!!
- 如何直接在DataGrid中,修改数据?
- 请问asp.net中如何获取xmlHTTP提交的数据
- win2003 server 的iis怎么不能使用asp页面
行 115:
行 116: DataSet ds1 = new DataSet();
行 117: da1.Fill(ds1);
行 118: //txbid.Text=ds1.Tables[0].Rows[0][0].ToString();
行 119:
源文件: c:\inetpub\wwwroot\liutong\webform1.aspx.cs 行: 117
sqlstr1="insert into test (条码,阅览室ID,时间,单位) values(@kahao,@ReadroomName,@time,@danwei)";
SqlCommand cm1=new SqlCommand(sqlstr1,sqlcon);
cm1.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@ReadroomName",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@time",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@danwei",SqlDbType.VarChar,50));
cm1.Parameters["@kahao"].Value=txbid.Text;
cm1.Parameters["@ReadroomName"].Value=drpdn.SelectedItem.Value;
cm1.Parameters["@time"].Value=DateTime.Now.ToString();
cm1.Parameters["@danwei"].Value=ds1.Tables[0].Rows[0][0].ToString();
cm1.Connection.Open();
cm1.ExecuteNonQuery();
cm1.Connection.Close();string sqlstr2;
sqlstr2="select 单位 from 读者表 where 条码=@kahao";
SqlCommand cm2=new SqlCommand(sqlstr2,sqlcon);
cm2.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm2.Parameters["@kahao"].Value=txbid.Text;
SqlDataAdapter da1 = new SqlDataAdapter(sqlstr2,sqlcon);
da1.SelectCommand=cm2;
DataSet ds1 = new DataSet();
da1.Fill(ds1);
//覆盖回去就可以了,把你代码调整了一下,这样清晰一些,出错原因是"条码=@kahao"中间你用的等号是中文下的.
sqlstr2="select 单位 from 读者表 where 条码=@kahao";//这里出错了,sql语句出错
SqlCommand cm2=new SqlCommand(sqlstr2,sqlcon);
cm2.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm2.Parameters["@kahao"].Value=txbid.Text;
SqlDataAdapter da1 = new SqlDataAdapter(sqlstr2,sqlcon);
da1.SelectCommand=cm2;
DataSet ds1 = new DataSet();
da1.Fill(ds1);string sqlstr1;
sqlstr1="insert into test (条码,阅览室ID,时间,单位) values(@kahao,@ReadroomName,@time,@danwei)";
SqlCommand cm1=new SqlCommand(sqlstr1,sqlcon);
cm1.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@ReadroomName",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@time",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@danwei",SqlDbType.VarChar,50));
cm1.Parameters["@kahao"].Value=txbid.Text;
cm1.Parameters["@ReadroomName"].Value=drpdn.SelectedItem.Value;
cm1.Parameters["@time"].Value=DateTime.Now.ToString();
cm1.Parameters["@danwei"].Value=ds1.Tables[0].Rows[0][0].ToString();
cm1.Connection.Open();
cm1.ExecuteNonQuery();
cm1.Connection.Close();
select 单位 from 读者表 where 条码 = 0000000000
查询分析器也显示这样的错误:第 2 行: ' ' 附近有语法错误。
这到底什么原因呀,各位大哥,各路神仙,帮帮小妹啊,
select 单位 from 读者表 where 条码 = 0000000000
sqlstr1="insert into test (条码,阅览室ID,时间,单位) values(@kahao,@ReadroomName,@time,@danwei)";
cm1.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@ReadroomName",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@time",SqlDbType.NVarChar,20));
cm1.Parameters.Add(new SqlParameter("@danwei",SqlDbType.VarChar,50));
cm1.Parameters["@kahao"].Value=txbid.Text;
cm1.Parameters["@ReadroomName"].Value=drpdn.SelectedItem.Value;
cm1.Parameters["@time"].Value=DateTime.Now.ToString();
cm1.Parameters["@danwei"].Value=ds1.Tables[0].Rows[0][0].ToString();
cm1.Connection.Open();
cm1.ExecuteNonQuery();
cm1.Connection.Close();sqlstr2="select 单位 from 读者表 where 条码 = @kahao";
SqlCommand cm1=new SqlCommand(sqlstr1,sqlcon);
SqlCommand cm2=new SqlCommand(sqlstr2,sqlcon);
cm2.Parameters.Add(new SqlParameter("@kahao",SqlDbType.NVarChar,20));
cm2.Parameters["@kahao"].Value=txbid.Text;
SqlDataAdapter da1 = new SqlDataAdapter(sqlstr2,sqlcon);
da1.SelectCommand=cm2;
DataSet ds1 = new DataSet();
da1.Fill(ds1,"读者表");
谢谢楼上的大哥们,csdn真的是个好地方