TextBox 和 input 应该分别如何写入数据库?
以下是我在 .net 中往数据库中存数据的方法,一个注册模块
private void Button1_Click(object sender, System.EventArgs e)
{
tablename="qy_info"; //我的表名
string strconn = ConfigurationSettings.AppSettings["SqlConnectionString"];
SqlConnection myconn=new SqlConnection(strconn);
myconn.Open();
SqlCommand mycmd= new SqlCommand ( "select * from rc_info where 用户名='"+this.TextBox1.Text+"'" ,myconn) ;
SqlDataAdapter myAdapter=new SqlDataAdapter("select * from rc_info " ,myconn);
SqlDataReader myreader ;
myreader = mycmd.ExecuteReader() ;
if( myreader.Read ( ))
{
this.Label7.Text="用户名已存在,请另行输入";
}
else
{
//必须先关闭reader...................
myreader.Close();
SqlCommand iCmd = new SqlCommand("INSERT INTO "+tablename.ToString()+" (用户名,密码,密码提示,密码回答,注册日期) VALUES (@reg_username,@reg_pwd,@reg_pwdcue,@reg_pwdanswer,@reg_date)", myconn);
myAdapter.InsertCommand=iCmd;
iCmd.Parameters.Add(new SqlParameter("@reg_username",SqlDbType.NVarChar, 50));
iCmd.Parameters.Add(new SqlParameter("@reg_pwd",SqlDbType.NVarChar, 50));
iCmd.Parameters.Add(new SqlParameter("@reg_pwdcue",SqlDbType.NVarChar, 50));
iCmd.Parameters.Add(new SqlParameter("@reg_pwdanswer",SqlDbType.NVarChar, 50));
iCmd.Parameters.Add(new SqlParameter("@reg_date",SqlDbType.SmallDateTime, 50));
iCmd.Parameters["@reg_username"].Value =this.TextBox1.Text;
iCmd.Parameters["@reg_pwd"].Value =this.TextBox2.Text;
iCmd.Parameters["@reg_pwdcue"].Value =this.TextBox4.Text;
iCmd.Parameters["@reg_pwdanswer"].Value =this.TextBox5.Text;
iCmd.Parameters["@reg_date"].Value =DateTime.Now.ToShortDateString();
iCmd.ExecuteNonQuery();
this.Label7.Text="恭喜!你已成功注册!";
Session["person_username"]=this.TextBox1.Text;
myconn.Close();
}
我全是用的 TextBox, 那如果有 input 那以上的语名应该如何写啊,我试着写了几种,可是都出错,请大家帮我一下。