先从表单项里获取房间号码roomnumb,入住日期entrydays,居住天数staydays.通过roomnumb来确认room表里是否有这个号码,要是有的话就把房间号码roomnumb,入住日期entrydays,居住天数staydays插入yuding表里
代码:
string roomnumb1 = this.roomnumb.Text.ToString();
string entrydays1 = this.entrydays.Text.ToString();
string staydays1 = this.staydays.Text.ToString(); string strconnection = ConfigurationManager.ConnectionStrings["123"].ConnectionString;
SqlConnection conn = new SqlConnection(strconnection);
conn.Open();
string sql = "select * from room where roomnumb='"+roomnumb1+"";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close(); conn.Close(); string strconnection1 = ConfigurationManager.ConnectionStrings["123"].ConnectionString;
SqlConnection conn1 = new SqlConnection(strconnection1);
conn1.Open();
string sql1 = "insert yuding set roomnumb='"+roomnumb1+"' and entrydays='"+entrydays1+"' and staydays='"+staydays1+"' where roomnumb='" + roomnumb1 + "'";
SqlCommand cmd1 = new SqlCommand(sql1,conn1);
cmd1.ExecuteNonQuery();
}
else
{
Response.Write("对不起,您输入的房间号码不正确!");
}
提示错误是 : cmd1.ExecuteNonQuery()有错 有什么其他的方法吗?
代码:
string roomnumb1 = this.roomnumb.Text.ToString();
string entrydays1 = this.entrydays.Text.ToString();
string staydays1 = this.staydays.Text.ToString(); string strconnection = ConfigurationManager.ConnectionStrings["123"].ConnectionString;
SqlConnection conn = new SqlConnection(strconnection);
conn.Open();
string sql = "select * from room where roomnumb='"+roomnumb1+"";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
dr.Close(); conn.Close(); string strconnection1 = ConfigurationManager.ConnectionStrings["123"].ConnectionString;
SqlConnection conn1 = new SqlConnection(strconnection1);
conn1.Open();
string sql1 = "insert yuding set roomnumb='"+roomnumb1+"' and entrydays='"+entrydays1+"' and staydays='"+staydays1+"' where roomnumb='" + roomnumb1 + "'";
SqlCommand cmd1 = new SqlCommand(sql1,conn1);
cmd1.ExecuteNonQuery();
}
else
{
Response.Write("对不起,您输入的房间号码不正确!");
}
提示错误是 : cmd1.ExecuteNonQuery()有错 有什么其他的方法吗?
解决方案 »
- 怎样在一个查询生成的临时表中添加一个主键呢
- 接口System.Web.IHttpHandler必须要在asp.net4.0环境下实现吗
- updatepannel中,如何让点击按钮执行一定操作,弹出一个确定提示框?
- 给点关于对一个企业部门组织做法的意见参考
- 用EnterPrise Library3.0,为什么老提示“必须声明变量 '@passwd ”?
- 我的网站放在租用的空间上,访问速度很慢
- 表单验证控件传到服务器上不好用,请指教
- 求新闻文章系统的源代码,asp.net(C#) sql server,带源代码
- 水晶报表的问题,请教大家!
- DundasWebChart控件使用问题 ---- 在线等带
- TextBox设置Enabled属性为False后,值丢失???
- 还是基础问题,问题来源:上个帖子中扩展出来的一些新问题
{
string sql1 = "insert yuding set roomnumb='"+roomnumb1+"' and entrydays='"+entrydays1+"' and staydays='"+staydays1+"' where roomnumb='" + roomnumb1 + "'";
SqlCommand cmd1 = new SqlCommand(sql1,conn);
cmd1.ExecuteNonQuery();
}
else
{
Response.Write("对不起,您输入的房间号码不正确!");
}
dr.Close(); conn.Close();
这应该是 string sql1 = "uptradeyuding set roomnumb='"+roomnumb1+"' and entrydays='"+entrydays1+"' and staydays='"+staydays1+"' where roomnumb='" + roomnumb1 + "'"; 更新的插入 是 insert into 表(字段1,字段2,字段3) values (xx,xx,xx) (注意拼接)
错了不只一个地方insert into yuding(字段1,字段2) values(写入数据库的值1,写入数据库的值2); 插入数据库用insert into
修改数据库用update dbtable set .. and ..
string sql1 = "insert yuding set roomnumb='"+roomnumb1+"' and entrydays='"+entrydays1+"' and staydays='"+staydays1+"' where roomnumb='" + roomnumb1 + "'";
???
如果你要插入的话
insert into 表名(列1,列2,列3,列4)values(值1,值2,值3,值4)如果是更新的话update 表名 set 列值1=改变后的值,列值2=改变后值 where 条件
报错: cmd1.ExecuteNonQuery(); -- 已有打开的与此命令相关联的 DataReader,必须首先将它关闭。
string sql1 = "update yuding set roomnumb='"+roomnumb1+"' and entrydays='"+entrydays1+"' and staydays='"+staydays1+"' where roomnumb='" + roomnumb1 + "'"; 这是更新语句 不是插入
string sql1 = "insert yuding(roomnumb,entrydays,staydays)values('roomnumb1','entrydays1','staydays1') ";
SqlCommand cmd1 = new SqlCommand(sql1, conn1);
cmd1.ExecuteNonQuery();改过后插入的值成了 roomnumb1 entrydays1 staydays1,而不是从表单获得的值 什么原因阿?