protected void BtnAdd_Click(object sender,EventArgs e)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString] ConnectionString);SqlCommand insertCmd = new SqlCOmmand("insert into Student (stuID,stuPwd,stuName,stuDepart,stuGrade,stuClass) values (@stuID,@stuPwd,@stuName,@stuDepart,@stuGrade,@stuClass)",conn);
insertCmd.Parameters.Add("@stuID",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuPwd",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuName",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuDepart",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuGrade",SqlDbType.Int,8);
insertCmd.Parameters.Add("@stuClass",SqlDbType.Int,8);
insertCmd.Parameters["@stuID"].Value = txtID.Text;
insertCmd.Parameters["@stuPwd"].Value = txtID.Text;
insertCmd.Parameters["@stuName"].Value = txtName.Text;
insertCmd.Parameters["@stuDepart"].Value = int.Parse(ddlDepart.SelectedValue);
insertCmd.Parameters["@stuGrade"].Value = int.Parse(ddlGrade.SelectedValue);
insertCmd.Parameters["@stuClass"].Value = int.Parse(ddlClass.SelectedValue);
try
{
conn.Open();
int.flag = insertCmd.ExecuteNonQuery
if(flag >0)
lblMessage.Text = "添加成功!";
else
lblMessage.Text = "添加失败!";
}catch(System.Exception ee)
{
Responde.Write ("<script language=javascript>alert ('" + ee.Message.ToString() + "')</script>");
}
finally
{
conn.Close();
}
为什么老是说 输入字符串的格式不正确呢?请各位指教!
{
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString] ConnectionString);SqlCommand insertCmd = new SqlCOmmand("insert into Student (stuID,stuPwd,stuName,stuDepart,stuGrade,stuClass) values (@stuID,@stuPwd,@stuName,@stuDepart,@stuGrade,@stuClass)",conn);
insertCmd.Parameters.Add("@stuID",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuPwd",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuName",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuDepart",SqlDbType.VarChar,50);
insertCmd.Parameters.Add("@stuGrade",SqlDbType.Int,8);
insertCmd.Parameters.Add("@stuClass",SqlDbType.Int,8);
insertCmd.Parameters["@stuID"].Value = txtID.Text;
insertCmd.Parameters["@stuPwd"].Value = txtID.Text;
insertCmd.Parameters["@stuName"].Value = txtName.Text;
insertCmd.Parameters["@stuDepart"].Value = int.Parse(ddlDepart.SelectedValue);
insertCmd.Parameters["@stuGrade"].Value = int.Parse(ddlGrade.SelectedValue);
insertCmd.Parameters["@stuClass"].Value = int.Parse(ddlClass.SelectedValue);
try
{
conn.Open();
int.flag = insertCmd.ExecuteNonQuery
if(flag >0)
lblMessage.Text = "添加成功!";
else
lblMessage.Text = "添加失败!";
}catch(System.Exception ee)
{
Responde.Write ("<script language=javascript>alert ('" + ee.Message.ToString() + "')</script>");
}
finally
{
conn.Close();
}
为什么老是说 输入字符串的格式不正确呢?请各位指教!
解决方案 »
- CreateUserWizard控件调取 Textbox 值的问题
- [散分] 终于搞定了! 动态加载切换Ajax模式!! , 动态添加ScriptManager,UpdatePanel
- 关于多个网站并存的问题,请高手指教!在线等候。
- Datagrid, 动态生成栏,如何实现点击栏表头实现排序
- ASP.net 收到的邮件是乱码?该怎么解决????100分求高手帮忙!!
- VS2003解决方案目录结构引用问题,急求!
- js 无法读取asp的session值 急!!! 求教高手
- 代码生成静态html文件时出现乱码??急?????
- 升星,发些代码,如果你有用!
- 链接的问题!请进!3q!!!
- c# 前台取后台值 急急急
- vs2005还是vs2008
insertCmd.Parameters["@stuGrade"].Value = int.Parse(ddlGrade.SelectedValue);
insertCmd.Parameters["@stuClass"].Value = int.Parse(ddlClass.SelectedValue);
=>
insertCmd.Parameters["@stuDepart"].Value = int.Parse(ddlDepart.SelectedValue.ToString());
insertCmd.Parameters["@stuGrade"].Value = int.Parse(ddlGrade.SelectedValue.ToString());
insertCmd.Parameters["@stuClass"].Value = int.Parse(ddlClass.SelectedValue.ToString());
insertCmd.Parameters["@stuDepart"].Value = ddlDepart.SelectedValue.ToString();
设置断点,单步跟踪
另外检查每个SelectedValue的值是不是空或是数字,如果是字符是无法转为整型的
stuDepart 的值是字符型的,那要怎么改啊?
insertCmd.Parameters.AddWithvalue("@stuPwd",txtID.Text);
这样写多简单啊ddlDepart等的绑定要写在
if(!Page.IsPostbBack)
{
ddlDepart绑定
}里面
insertCmd.Parameters.AddWithvalue("@stuGrade",ddlGrade.SelectedValue);
insertCmd.Parameters["@stuGrade"].Value = int.Parse(ddlGrade.SelectedValue.ToString());
insertCmd.Parameters["@stuClass"].Value = int.Parse(ddlClass.SelectedValue.ToString());
["ConnectionString]中少了个引号