protected void Button1_Click(object sender, EventArgs e)
{
CommonClass Comm = new CommonClass();
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
// string sqlStr = "insert into MemberUpCornInfo(作物类型,区域,时期,发布时间,作物苗情,苗情分析,生产管理建议,专家名)values(" + zwlx.Text + "," + fbqy.Text + "," + fysq.Text + "," + fbsj.Text + "," + zwmq.Text + "," + mqfx.Text + "," + scgljy.Text + "," + expertName.Text + ")";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into ExpertUpAdvice(作物类型,区域,时期,发布时间,作物苗情,苗情分析,生产管理建议,专家名)values(" + zwlx.Text + "," + fbqy.Text + "," + fysq.Text + "," + fbsj.Text + "," + zwmq.Text + "," + mqfx.Text + "," + scgljy.Text + "," + expertName.Text + ")";
try
{
conn.Open();
cmd.ExecuteNonQuery();
if (cmd.ExecuteNonQuery() != 0)
{
Response.Write(Comm.MessageBox("恭喜你!添加成功"));
}
else
{
//Response.Write(Comm.MessageBox("恭喜你"));
}
cmd = null;
conn.Close();
conn = null; }
catch (Exception ex)
{
//Response.Write(Comm.MessageBox(ex.ToString()));
Console.WriteLine(ex.Message);
Response.Write(Comm.MessageBox("抱歉!未能添加成功,请稍后重试"));
cmd = null;
conn.Close();
conn = null; } }
上传按钮中触发事件抛出异常“,”附近有错误,用查询生成器检查说是列表值字段问题,望大家给我指点一下。
{
CommonClass Comm = new CommonClass();
string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
// string sqlStr = "insert into MemberUpCornInfo(作物类型,区域,时期,发布时间,作物苗情,苗情分析,生产管理建议,专家名)values(" + zwlx.Text + "," + fbqy.Text + "," + fysq.Text + "," + fbsj.Text + "," + zwmq.Text + "," + mqfx.Text + "," + scgljy.Text + "," + expertName.Text + ")";
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "insert into ExpertUpAdvice(作物类型,区域,时期,发布时间,作物苗情,苗情分析,生产管理建议,专家名)values(" + zwlx.Text + "," + fbqy.Text + "," + fysq.Text + "," + fbsj.Text + "," + zwmq.Text + "," + mqfx.Text + "," + scgljy.Text + "," + expertName.Text + ")";
try
{
conn.Open();
cmd.ExecuteNonQuery();
if (cmd.ExecuteNonQuery() != 0)
{
Response.Write(Comm.MessageBox("恭喜你!添加成功"));
}
else
{
//Response.Write(Comm.MessageBox("恭喜你"));
}
cmd = null;
conn.Close();
conn = null; }
catch (Exception ex)
{
//Response.Write(Comm.MessageBox(ex.ToString()));
Console.WriteLine(ex.Message);
Response.Write(Comm.MessageBox("抱歉!未能添加成功,请稍后重试"));
cmd = null;
conn.Close();
conn = null; } }
上传按钮中触发事件抛出异常“,”附近有错误,用查询生成器检查说是列表值字段问题,望大家给我指点一下。
解决方案 »
- 请说说nintegrate nbearlite nbear是啥玩意?
- 把下列SQL转换成Lamda表达式
- 网站每隔20多天,在早上会出现Server Application Unavailable
- asp.net中access做的网站,拿到服务器上后就没有修改的权限了
- 关于邮件回复的问题
- 询问表关联!
- vs2005在添加文件的时候,有个问题,html页转aspx页面的时候vs203会自动添加cs文件而2005怎么不能自动添加上呢
- ajax 怎樣綁定數據?
- 为什么删除不了啊!
- 求制作chm文件的利器!
- dataset数据绑定问题
- ASP.NET 2.0中Repeater 中的DropDwonList的问题
打断点跟踪一下生成的最终SQL语句
cmd.CommandText = "insert into [ExpertUpAdvice]([作物类型],[区域],[时期],[发布时间],[作物苗情],[苗情分析],[生产管理建议],[专家名])values('" + zwlx.Text + "','" + fbqy.Text + "','" + fysq.Text + "','" + fbsj.Text + "','" + zwmq.Text + "','" + mqfx.Text + "','" + scgljy.Text + "','" + expertName.Text + "')";
...
cmd.CommandText="insert into table (field,...) values (@value,...)";
cmd.Parameters.AddWithValue("@value",textBox1.Text);
...
string sql="insert into a(a) values('"+ba+"')";
string strInsert = "Insert Into yjlb (y_name,y_nr) Values (@T1,@T2)";
OleDbCommand cmdInsert = new OleDbCommand( strInsert, MyConnection2 );
cmdInsert.Parameters.Add(new OleDbParameter("@T1", 1150));
cmdInsert.Parameters["@T1"].Value =TextBox1.Text ;
cmdInsert.Parameters.Add(new OleDbParameter("@T2", 1150));
cmdInsert.Parameters["@T2"].Value =TextBox2.Text ;
MyConnection2.Open();
cmdInsert.ExecuteNonQuery();
MyConnection2.Close();以上代码,比你的可读性好多了。
查询分析器里面执行下
还有就是那些数据库的字段用英文比较好点。