Through a web page to add student information, has added a "learning" (we), add the information that appear problem, no problem before,



At the front desk code:
Part (omitted)

































The background code:


The namespace SMSystem
{
Public partial class StudentAdd: System. Web. UI. Page
{
String connStr=ConfigurationManager. ConnectionStrings [r]. "SysConnstr" ConnectionString;
Protected void Page_Load (object sender, EventArgs e)
{
BtnOk. Attributes. Add (" OnClick ", "return checkStuInfo ();" );
if (! IsPostBack)
{
BindClass ();
If (Request (" id ")!=null)
{
LableInfo. Text="student information change";
BtnOk. Text="change";
TxtstuPwd. Enabled=false;
BindStuInfo (Request) [r]. "id" ToString ());
}
}
}

Private void BindClass ()
{
String SQL="select * from tb_ClassInfo";
The DataSet ds=SqlHelper. ExecuteDataset (connStr, CommandType. Text, SQL);
DdlClass. DataValueField="Id";
DdlClass. DataTextField="ClassName";
DdlClass. The DataSource=ds;
DdlClass. DataBind ();
}

Private void BindStuInfo (string id)
{
String SQL="select * from tb_StuInfo where Id=" + Id;
SqlDataReader SDR=SqlHelper. ExecuteReader (connStr, CommandType. Text, SQL);
If (SDR) Read ())
{
TxtstuId. Text=the SDR [r]. "StuNum" ToString (). The Trim ();
TxtstuName. Text=the SDR [r]. "StuName" ToString (). The Trim ();
Txtwe. Text=the SDR [r]. "we" the ToString (). The Trim ();
If (SDR) [r]. "Sex" the ToString ()=="False")
{
RadMan. Checked=false;
RadWoman. Checked=true;
}
DdlClass. SelectedValue=https://bbs.csdn.net/topics/sdr [r]. "every" ToString ();
TxtBirth. Value=https://bbs.csdn.net/topics/Convert.ToDateTime (SDR) [" Birthday "]. ToString (" yyyy - MM - dd ");
TxtJionTime. Value=https://bbs.csdn.net/topics/Convert.ToDateTime (SDR (" StartTime ")). ToString (" yyyy - MM - dd ");
}
The SDR. The Close ();
}

Protected void btnOk_Click (object sender, EventArgs e)
{
//add
If (btnOk. Text=="addition")
{
//query whether student id repeat
if (! CheckStuId (" add "))
{
Page. ClientScript. RegisterClientScriptBlock (enclosing GetType (), "addcheckerror", "alert (' the student number already exists! ') ", true);
return;
}


String SQL="insert into tb_StuInfo values (@ StuNum @ StuPwd, @ StuName, @ we, @ Birthday, @ Sex, @ every, @ StartTime)";
SqlParameter [] the parameters=
{
New SqlParameter (" @ StuNum, "txtstuId. Text. The Trim ()),
New SqlParameter (" @ StuPwd, "txtstuPwd. Text. The Trim ()),
New SqlParameter (" @ StuName ", txtstuName. Text. The Trim ()),
New SqlParameter (" @ we, "txtwe. Text. The Trim ()),
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull

& nbsp; & nbsp; & nbsp; & nbsp;