|
——此文章摘自《ASPNET +SQL Server网络应用系统开发案例精解》定价￥特价￥ 详细>> //填充连锁店列表框 STconnOpen (); //创建查询连锁店信息的sql语句 string STmysql = select * from STDep; SqlCommand STcmd =new SqlCommand(STmysqlSTconn); SqlDataReader STdr = STcmdExecuteReader (); //向连锁店下拉列表框添加默认值 STDepNameItemsAdd(new ListItem() ); while(STdrRead ()) { //向连锁店下拉列表框添加连锁店名字和ID STDepNameItemsAdd(new ListItem(STdr[STDepName]ToString()STdr[STDepID] ToString ()) ); } //关闭连接 STconnClose (); } else { ResponseRedirect(/Indexaspx); } } //单击确定按钮所触发的事件 private void ST_ok_Click(object sender SystemEventArgs e) { if(STNickNameText == ) { ST_WarnText = 用户ID不能为空！; ST_WarnStyle[color]=red; } else if(STUserNameText == ) { ST_WarnText = 用户名字不能为空！; ST_WarnStyle[color]=red; } else { //创建SqlCommand对象采用存储过程 SqlCommand STcmd =new SqlCommand(insert_STUser_STconn); //获取SqlCommand对象所调用的存储过程名 STcmdCommandType=CommandTypeStoredProcedure; STcmdParametersAdd(new SqlParameter(@STDepIDSqlDbTypeInt)); STcmdParametersAdd(new SqlParameter(@STNickNameSqlDbTypeVarChar)); STcmdParametersAdd(new SqlParameter(@STUserNameSqlDbTypeVarChar)); STcmdParametersAdd(new SqlParameter(@STUserPwdSqlDbTypeVarChar)); [] [] [] [] |
