在cmd.executeNonQuery
提示在此上下文不允许使用名称"xm",有效表达式包括常量,常量表达式和变量.不允许使用列名.
string sql = "insert into qqyy(xm,gh,jz,lb,chuqin,yy,shijian) values (xm='" + value1 + "',gh='" + value2 + "',jz='" + value3 + "',lb='" + value4 + "',shijian='" + value5 + "',chuqin='" + rb + "',yy='" + ddl + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
提示在此上下文不允许使用名称"xm",有效表达式包括常量,常量表达式和变量.不允许使用列名.
string sql = "insert into qqyy(xm,gh,jz,lb,chuqin,yy,shijian) values (xm='" + value1 + "',gh='" + value2 + "',jz='" + value3 + "',lb='" + value4 + "',shijian='" + value5 + "',chuqin='" + rb + "',yy='" + ddl + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
解决方案 »
- 江湖救急,设置的断点不能用,程序的入口在哪?
- ie7的ActiveX问题
- repeater的问题
- 页面类、缓存疑问
- 如果通过时间来进行数据库操作
- 一个关于上传文件 权限的问题 请大家帮帮忙啊
- 求助] 刚做了一个留言本(C#),请大家帮忙提点意见!(顶者有分!)
- .net oauth认证示例代码
- 求助 未能加载文件或程序集“vmime.NET”或它的某一个依赖项。未能验证强名称签名。此程序集可能已被篡改,或者已被延迟签名,但没有用正确的私钥进行完全签名。
- 请问html中的<tr>,<td>,<span>分别是什么意思?
- IE8中下载文件Session 遗失
- 用asp.net(C#)代码实现创建iis网站虚拟目录
我记得是这样写呢
顺序要对断点sql啊 拿数据库里跑哥哥啊!你这个插入插了好几天了呢。
你前面的insert into qqyy(xm,gh,jz,lb,chuqin,yy,shijian)就是对应values里面的值不用什么在等于了,
+是连接符
你在查查insert语法你就明白了。
string sql = "insert into qqyy(xm,gh,jz,lb,chuqin,yy,shijian) values('" + value1 + "','" + value2 + "','" + value3 + "','" + value4 + "','" + rb + "','" + ddl + "','" + value5 + "')";1、注意空格
2、注意 int 格式的值不要用''
string sql = "insert into qqyy(@xm,@gh,@jz,@lb,@chuqin,@yy,@shijian) SqlCommand cmd = new SqlCommand(sql, conn);
cmd.Parameters.AddWithValue("xm",xm)
....
...
...
cmd.ExecuteNonQuery();
conn.Close();
为什么插入到数据里面变成了.
system.web.ui.webcontrols.RadioButton?
DropDownList ddl = GridView1.Rows[i].FindControl("DropDownList1") as DropDownList;
if (ddl.SelectedValue != "")
{ string ddlstr = ddl.SelectedValue;
}
获取值啊。不要传控件 传控件的属性参数传ddlstr
{ for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
string value1 = (this.GridView1.Rows[i].FindControl("Label1") as Label).Text.Trim();
string value2 = (this.GridView1.Rows[i].FindControl("Label2") as Label).Text.Trim();
string value3 = (this.GridView1.Rows[i].FindControl("Label3") as Label).Text.Trim();
string value4 = (this.GridView1.Rows[i].FindControl("Label4") as Label).Text.Trim();
string value5 = (this.GridView1.Rows[i].FindControl("TextBox5") as TextBox).Text.Trim();
RadioButton rb = GridView1.Rows[i].FindControl("RadioButton1") as RadioButton;
if (rb.Checked)
{
string rbstr = "是";
}
else
{
string rbstr= "否";
}
DropDownList ddl = GridView1.Rows[i].FindControl("DropDownList1") as DropDownList;
if (ddl.SelectedValue != "")
{ string ddlstr = ddl.SelectedValue;
}
SqlConnection conn = zong.createcon();
conn.Open();
string sql = "insert into qqyy(xm,gh,jz,lb,chuqin,yy,shijian) values ('" + value1 + "','" + value2 + "','" + value3 + "','" + value4 + "','" + value5 + "','" + rb + "','" + ddl + "')";
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();
}
请帮我修改一下吧,代码应该是这样的,今天写的一些在公司里面。没有拷贝回来。
{ for (int i = 0; i < this.GridView1.Rows.Count; i++)
{
string value1 = (this.GridView1.Rows[i].FindControl("Label1") as Label).Text.Trim();
string value2 = (this.GridView1.Rows[i].FindControl("Label2") as Label).Text.Trim();
string value3 = (this.GridView1.Rows[i].FindControl("Label3") as Label).Text.Trim();
string value4 = (this.GridView1.Rows[i].FindControl("Label4") as Label).Text.Trim();
string value5 = (this.GridView1.Rows[i].FindControl("TextBox5") as TextBox).Text.Trim();
RadioButton rb = GridView1.Rows[i].FindControl("RadioButton1") as RadioButton;
string rbstr = string.Empty;
string ddlstr = string.Empty;
if (rb.Checked)
{
rbstr = "是";
}
else
{
rbstr = "否";
}
DropDownList ddl = GridView1.Rows[i].FindControl("DropDownList1") as DropDownList;
ddlstr = ddl.SelectedValue.ToString();
string sql = "insert into qqyy(xm,gh,jz,lb,chuqin,yy,shijian) values ('" + value1 + "','" + value2 + "','" + value3 + "','" + value4 + "','" + value5 + "','" + rbstr + "','" + ddlstr + "')";
if (ExecuteNonQuery(sql) > 0)
{
this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('成功了');</script>");
}
else
{
this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('悲剧了');</script>");
} }
}
public static int ExecuteNonQuery(string cmdtext)
{
SqlConnection cn = new SqlConnection();
cn.ConnectionString = "链接字符串";
cn.Open();
int value;
try
{
SqlCommand cmd = new SqlCommand(cmdtext, cn);
value = cmd.ExecuteNonQuery() > 0 ? 1 : 0;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (cn.State == ConnectionState.Open)
{
cn.Close();
}
}
return value;
}
if (ExecuteNonQuery(sql) > 0)
{
this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('成功了');</script>");
}
else
{
this.ClientScript.RegisterStartupScript(GetType(), "", "<script>alert('悲剧了');</script>");
}
去掉吧改成ExecuteNonQuery(sql);吧 在for循环里 哎
还需要用事务暂且完成功能吧.
SqlCommand cmd = new SqlCommand(sql, conn);
cmd.ExecuteNonQuery();
conn.Close();