|
——此文章摘自《ASPNET +SQL Server网络应用系统开发案例精解》定价￥特价￥ 详细>>http://tracklinktechcn/?m_id=dangdang&a_id=A&l=&l_type= width= height= border= nosave> //创建数据库连接 STconn = new SqlConnection(STconnection); } else { ResponseRedirect(/Indexaspx); } } private void STDe_add_Click(object sender SystemEventArgs e) { //创建插入产品信息的sql语句 string STstrsql = insert into STProd(STProdName) values(@STProdName); //根据sql语句创建SqlCommand对象 SqlCommand STcmd = new SqlCommand(STstrsqlSTconn); STcmdParametersAdd(new SqlParameter(@STProdNameSqlDbTypeVarChar)); STcmdParameters[@STProdName]Value = STProdNameText ; STcmdConnectionOpen(); try { //执行sql语句 STcmdExecuteNonQuery(); //Label提示添加成功 STProd_warnText = 添加成功！; //提示信息的字体颜色 STProd_warnStyle[color] = red; ResponseRedirect(STManagerProductaspx); } catch(SqlException) { //Label提示添加失败 STProd_warnText = 添加失败！; STProd_warnStyle[color] = red; ResponseRedirect(STManagerAddProductaspx); } } right>[http://developcsaicn/dotnet_ASP/htm>] [http://developcsaicn/dotnet_ASP/htm>] [http://developcsaicn/dotnet_ASP/htm>] [] |
