ASP.NET数据库添加记录练习

update.aspx

<% @ Page language = " C# "  Codebehind = " update.aspx.cs "  AutoEventWireup = " false "  Inherits = " DotNetTest.database.update "   %>
<! DOCTYPE HTML PUBLIC  " -//W3C//DTD HTML 4.0 Transitional//EN "   >
< HTML >
     < HEAD >
         < title > update </ title >
         < meta name = " GENERATOR "  Content = " Microsoft Visual Studio 7.0 " >
         < meta name = " CODE_LANGUAGE "  Content = " C# " >
         < meta name = " vs_defaultClientScript "  content = " JavaScript " >
         < meta name = " vs_targetSchema "  content = " http://schemas.microsoft.com/intellisense/ie5 " >
     </ HEAD >
     < body >
         < form id = " update "  method = " post "  runat = " server " >
             < P >< FONT face = " 宋体 "  color = " #ff6600 " >------------ 帐号注册 ------------</ FONT ></ P >
             < P >< FONT style = " FONT-STYLE: italic "  face = " 宋体 "  color = " #ff6600 " > 必填: </ FONT ></ P >
             < P >< FONT face = " 宋体 " > 帐号:
                     < asp:TextBox id = " TB_Account "  runat = " server " ></ asp:TextBox >
                     < asp:Label id = " Lbl_Msg "  style = " Z-INDEX: 101; LEFT: 305px; POSITION: absolute; TOP: 94px "  runat = " server "  Width = " 177px "  Height = " 59px "  BackColor = " White "  ForeColor = " Red " ></ asp:Label ></ P >
             </ FONT >
             < P >< FONT face = " 宋体 " > 密码:
                     < asp:TextBox id = " TB_Password1 "  runat = " server " ></ asp:TextBox ></ FONT ></ P >
             < P >< FONT face = " 宋体 " > 确认密码:
                     < asp:TextBox id = " TB_Password2 "  runat = " server " ></ asp:TextBox ></ FONT ></ P >
             < P >< FONT face = " 宋体 " >---------
                     < asp:Button id = " B_OKGOPinjie "  runat = " server "  Text = " OK,GO拼接字符串 "  Width = " 160px " ></ asp:Button >
                     < asp:LinkButton id = " LB_SeeResult "  style = " Z-INDEX: 102; LEFT: 312px; POSITION: absolute; TOP: 203px "  runat = " server "  Width = " 116px "  Height = " 23px "  Visible = " False " > 查看数据库内容 </ asp:LinkButton ></ FONT ></ P >
             < P >< FONT face = " 宋体 " >---------
                     < asp:Button id = " B_OKGOParm "  runat = " server "  Text = " OK,GO使用参数 "  Width = " 161px " ></ asp:Button ></ FONT ></ P >
             < P >< FONT face = " 宋体 " >---------
                     < asp:Button id = " B_OKGOStore "  runat = " server "  Text = " OK,GO使用存储过程 "  Width = " 161px " ></ asp:Button ></ P >
             </ FONT >
             < P >< FONT style = " FONT-STYLE: italic "  face = " 宋体 "  color = " #ff6600 " > 选填: </ P >
             </ FONT >
             < P >< FONT face = " 宋体 " > 昵称:
                     < asp:TextBox id = " TB_VirtualName "  runat = " server " ></ asp:TextBox ></ FONT ></ P >
             < P >< FONT face = " 宋体 " > 性别:
                     < asp:RadioButtonList id = " RBL_Sex "  runat = " server "  RepeatDirection = " Horizontal "  RepeatLayout = " Flow " >
                         < asp:ListItem Value = " M "  Selected = " True " > 男 </ asp:ListItem >
                         < asp:ListItem Value = " F " > 女 </ asp:ListItem >
                     </ asp:RadioButtonList ></ FONT >< FONT face = " 宋体 " ></ P >
             </ FONT >
         </ form >
     </ body >
</ HTML >

update.aspx.cs

using  System;
using  System.Collections;
using  System.ComponentModel;
using  System.Data;
using  System.Drawing;
using  System.Web;
using  System.Web.SessionState;
using  System.Web.UI;
using  System.Web.UI.WebControls;
using  System.Web.UI.HtmlControls;

using  System.Data.SqlClient;
using  System.Configuration;

namespace  DotNetTest.database
... {
    /**//// <summary>
    /// update 的摘要说明。
    /// </summary>
    public class update : System.Web.UI.Page
    ...{
        protected System.Web.UI.WebControls.TextBox TB_Account;
        protected System.Web.UI.WebControls.TextBox TB_Password1;
        protected System.Web.UI.WebControls.TextBox TB_Password2;
        protected System.Web.UI.WebControls.TextBox TB_VirtualName;
        protected System.Web.UI.WebControls.Button B_OKGOPinjie;
        protected System.Web.UI.WebControls.Button B_OKGOParm;
        protected System.Web.UI.WebControls.Button B_OKGOStore;
        protected System.Web.UI.WebControls.Label Lbl_Msg;
        protected System.Web.UI.WebControls.LinkButton LB_SeeResult;
        protected System.Web.UI.WebControls.RadioButtonList RBL_Sex;

        private bool CheckInfo()
        ...{
            if(this.TB_Account.Text.Trim()=="")
            ...{
                Alert("学号不完整");
                return false;
            }
            else if(this.TB_Password1.Text.Trim()==""||this.TB_Password2.Text.Trim()=="")
            ...{
                Alert("密码不完整");
                return false;
            }
            else if(this.TB_Password1.Text.Trim()!=this.TB_Password2.Text.Trim())
            ...{
                Alert("密码确认失败!");
                return false;
            }
            return true;
        }
        private void Alert(string str)
        ...{
            Lbl_Msg.Text=str;
            Lbl_Msg.BackColor=System.Drawing.Color.DimGray;
            LB_SeeResult.Visible=true;
        }
    
        private bool IsOKAccount()
        ...{
            string usrAccount=this.TB_Account.Text.Trim();
            try
            ...{
                //config the database
                string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];
                SqlConnection sqlConn=new SqlConnection();
                sqlConn.ConnectionString=strConn;
                //the SQL string
                string sqlCount="SELECT COUNT(*) FROM FSL_USER WHERE USER_ID=@userID";
                //create the command
                SqlCommand cmd=new SqlCommand(sqlCount,sqlConn);
                //add parameters
                cmd.Parameters.Add(new SqlParameter("@userID",usrAccount));
                //open the database
                sqlConn.Open();
                //save  the affected result
                string aff=cmd.ExecuteScalar().ToString();
                //close the database
                sqlConn.Close();
                if(Int32.Parse(aff)!=0)
                ...{
                    Alert("帐号已经存在");
                    return false;
                }
                return true;

            }
            catch(Exception ex)
            ...{
                Alert(ex.Message);
                return false;
            }
        }

        private void Page_Load(object sender, System.EventArgs e)
        ...{
            // 在此处放置用户代码以初始化页面
        }

        Web Form Designer generated code#region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        ...{
            //
            // CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
            //
            InitializeComponent();
            base.OnInit(e);
        }
        
        /**//// <summary>
        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
        /// 此方法的内容。
        /// </summary>
        private void InitializeComponent()
        ...{    
            this.B_OKGOPinjie.Click += new System.EventHandler(this.B_OKGOPinjie_Click);
            this.LB_SeeResult.Click += new System.EventHandler(this.LB_SeeResult_Click);
            this.B_OKGOParm.Click += new System.EventHandler(this.B_OKGOParm_Click);
            this.B_OKGOStore.Click += new System.EventHandler(this.B_OKGOStore_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void B_OKGOPinjie_Click(object sender, System.EventArgs e)
        ...{
            if(!IsOKAccount())
            ...{
                return;
            }
            if(this.CheckInfo())
            ...{
                //get the acquired value
                string usrAccount=this.TB_Account.Text.Trim();
                string usrPassword=this.TB_Password1.Text.Trim();
                string usrVirtualName=this.TB_VirtualName.Text.Trim();
                string usrSex=this.RBL_Sex.SelectedItem.Value.Trim();

                //operate the database
                try
                ...{
                    //config the database
                    string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];
                    SqlConnection sqlConn=new SqlConnection();
                    sqlConn.ConnectionString=strConn;
                    //the SQL string
                    string sqlInsert="INSERT INTO FSL_USER(USER_ID,USER_NAME,USER_SEX,USER_PASSWORD)"+
                        " VALUES('"+usrAccount+"','"+usrVirtualName+"','"+usrSex+"','"+usrPassword+"')";
                    //create the command
                    SqlCommand cmd=new SqlCommand(sqlInsert,sqlConn);
                    //open the database
                    sqlConn.Open();
                    //save  the affected result
                    int aff=cmd.ExecuteNonQuery();
                    //close the reader and the database
                    sqlConn.Close();
                    Alert("使用拼接字符串:数据添加成功"+aff+"条!");
                }
                catch(Exception ex)
                ...{
                    Alert(ex.Message);
                }
            }
        }

        private void B_OKGOParm_Click(object sender, System.EventArgs e)
        ...{
            if(this.CheckInfo())
            ...{
                if(!IsOKAccount())
                ...{
                    return;
                }
                //get the acquired value
                string usrAccount=this.TB_Account.Text.Trim();
                string usrPassword=this.TB_Password1.Text.Trim();
                string usrVirtualName=this.TB_VirtualName.Text.Trim();
                string usrSex=this.RBL_Sex.SelectedItem.Value.Trim();
                
                //operate the database
                try
                ...{
                    //config the database
                    string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];
                    SqlConnection sqlConn=new SqlConnection();
                    sqlConn.ConnectionString=strConn;
                    //the SQL string
                    string sqlInsert="INSERT INTO FSL_USER(USER_ID,USER_NAME,USER_SEX,USER_PASSWORD)"+
                        " VALUES(@userID,@userName,@userSex,@userPassword)";
                    //create the command
                    SqlCommand cmd=new SqlCommand(sqlInsert,sqlConn);
                    //add parameters
                    cmd.Parameters.Add(new SqlParameter("@userID",usrAccount));
                    cmd.Parameters.Add(new SqlParameter("@userName",usrVirtualName));
                    cmd.Parameters.Add(new SqlParameter("@userSex",usrSex));
                    cmd.Parameters.Add(new SqlParameter("@userPassword",usrPassword));
                    //open the database
                    sqlConn.Open();
                    //save  the affected result
                    int aff=cmd.ExecuteNonQuery();
                    //close the reader and the database
                    sqlConn.Close();
                    Alert("使用参数:数据添加成功"+aff+"条!");
                }
                catch(Exception ex)
                ...{
                    Alert(ex.Message);
                }
            }
        
        }

        private void B_OKGOStore_Click(object sender, System.EventArgs e)
        ...{
            if(!IsOKAccount())
            ...{
                return;
            }
            if(this.CheckInfo())
            ...{
                //get the acquired value
                string usrAccount=this.TB_Account.Text.Trim();
                string usrPassword=this.TB_Password1.Text.Trim();
                string usrVirtualName=this.TB_VirtualName.Text.Trim();
                string usrSex=this.RBL_Sex.SelectedItem.Value.Trim();
                //operate the database
                try
                ...{
                    //config the database
                    string strConn=ConfigurationSettings.AppSettings["MSSQLConnStr_FSLink"];
                    SqlConnection sqlConn=new SqlConnection();
                    sqlConn.ConnectionString=strConn;
                    //create the command
                    SqlCommand cmd=new SqlCommand("InsertUser",sqlConn);
                    cmd.CommandType=CommandType.StoredProcedure;
                    //add parameters
                    cmd.Parameters.Add(new SqlParameter("@userID",usrAccount));
                    cmd.Parameters.Add(new SqlParameter("@userName",usrVirtualName));
                    cmd.Parameters.Add(new SqlParameter("@userSex",usrSex));
                    cmd.Parameters.Add(new SqlParameter("@userPassword",usrPassword));
                    //open the database
                    sqlConn.Open();
                    //save  the affected result
                    int aff=cmd.ExecuteNonQuery();
                    //close the reader and the database
                    sqlConn.Close();
                    Alert("使用存储过程:数据添加成功"+aff+"条!");
                }
                catch(Exception ex)
                ...{
                    Alert(ex.Message);
                }
            }
        }


        private void LB_SeeResult_Click(object sender, System.EventArgs e)
        ...{
            Server.Transfer("select_adapter.aspx");
        }
    }
}