帮忙看看数据库无法更新的问题。我试了好久都没成功。 你将drl.Close();写到while(drl.Read()){}外面试试 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 还有myConnection.Close();myConnection.Dispose();都写到外面 哇赛!这么多的代码阿看的我都晕了!就是 yqdeng(享受生活每一天) 说的那样 while(dr1.Read()){ int sscount = Int32.Parse(dr1["sfromcount"].ToString());int ssscount=sscount;dr1.Close();int countnumber1=ssscount+1;string sSqlCommand1="update mobilenumber set stime='"+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'"; SqlCommand myCommand1=new SqlCommand(sSqlCommand1,myConnection);myCommand1.ExecuteNonQuery();myConnection.Close();myConnection.Dispose(); }dr1.Read() 时,你执行dr1.Close();myConnection.Close();myConnection.Dispose();?????? 1,string execString = "select sfromcount from mobilenumber where number='"+numbers+"'"; //number字段是数字还是字符,如果是数字就不要加单引号。2,string sSqlCommand1="update mobilenumber set stime='"+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'"; //stime是什么类型,参看number说明。3,string sSqlCommand1="update mobilenumber set stime='"+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'"; //加到myConnection.Open();之前。4,try //看看什么错。{ myCommand1.ExecuteNonQuery();}catch{Exception ex}{ MessageBox.Show(ex.Message)} 把你的while循环改成如下:int sscount =-1;if(dr1.Read()){ sscount=Int32.Parse(dr1["sfromcount"].ToString());}dr1.Close();if(sscount>0){ int ssscount=sscount; int countnumber1=ssscount+1; string sSqlCommand1="update mobilenumber set stime='" +timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'"; SqlCommand myCommand1=new SqlCommand(sSqlCommand1,myConnection); myCommand1.ExecuteNonQuery();}myConnection.Close();myConnection.Dispose(); oralce怎么输出table 请问怎么关闭FORM1? 求一个组合算法。 一个AD操作的path问题,高手帮忙! 网页嵌入excel无法显示 將datetimepicker中的數據導入oracle數據庫中date類型字段 C#中如何把一個傳真圖片存進SQL SERVER,又怎么把它顯示在IE里呢? 一个小问题 数据库小问题,高手指点下 关于数据库的建立 Help!!!!!! 请问几个asp.net问题
myConnection.Close();
myConnection.Dispose();
都写到外面
这么多的代码阿
看的我都晕了!
就是 yqdeng(享受生活每一天) 说的那样
{
int sscount = Int32.Parse(dr1["sfromcount"].ToString());
int ssscount=sscount;
dr1.Close();
int countnumber1=ssscount+1;
string sSqlCommand1="update mobilenumber set stime='"+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'";
SqlCommand myCommand1=new SqlCommand(sSqlCommand1,myConnection);
myCommand1.ExecuteNonQuery();
myConnection.Close();
myConnection.Dispose(); }dr1.Read() 时,你执行dr1.Close();
myConnection.Close();
myConnection.Dispose();????
??
2,string sSqlCommand1="update mobilenumber set stime='"+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'"; //stime是什么类型,参看number说明。
3,string sSqlCommand1="update mobilenumber set stime='"+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'"; //加到myConnection.Open();之前。
4,try //看看什么错。
{
myCommand1.ExecuteNonQuery();
}
catch{Exception ex}
{
MessageBox.Show(ex.Message)
}
int sscount =-1;
if(dr1.Read())
{
sscount=Int32.Parse(dr1["sfromcount"].ToString());
}
dr1.Close();if(sscount>0)
{
int ssscount=sscount;
int countnumber1=ssscount+1;
string sSqlCommand1="update mobilenumber set stime='"
+timeTempString+"',sfromcount="+countnumber1+" where number='"+number1+"'";
SqlCommand myCommand1=new SqlCommand(sSqlCommand1,myConnection);
myCommand1.ExecuteNonQuery();
}
myConnection.Close();
myConnection.Dispose();