📄 regedit2.aspx.cs
字号:
// cmd.Parameters["@UserID"].Value = this.UserID.Text;
// cmd.Connection.Open();
// try
// {
// cmd.ExecuteNonQuery();
// }
// catch
// {
// this.Remark.Text = "wrong";
// // Response.Write("wrong");
// }
// cmd.Connection.Close();
//}
}
protected void Reback_Click(object sender, EventArgs e)
{
}
protected void Submit_Click(object sender, EventArgs e)
{
// String SorT_Num = SorT_ID.Text.ToString();
// // String AcaNum;
//// String ClassID;
//// String temp;
// // AcaNum = SorT_Num.Substring(2, 2);
// // temp = String.Format("%s", Convert.ToInt32(AcaNum));
// Label1.Text = SorT_Num.Substring(2, 2);
// // // Label2.Text = SorT_Num.Substring(4, 1);
// @UserID char(20),
//@StudentID char(10),
//@PWD nchar(16),
//@NickName char(10),
//@Question varchar(50),
//@Answer varchar(50),
//@PicName nchar(30),
//@Remark nvarchar(200),
//@Sex char(10),
//@Tele char(20),
//@MobilePh nchar(16),
//@QQ char(10),
//@Email nchar(30),
//@Country char(10),
//@Province char(10),
//@City Char(10),
//@Address nchar(40),
//@PostNum nchar(10),
//@RegClass nchar(10)
//@biryear char(10),
// @birmounth char(10),
// @birday char(10)
//@etryear char(10)
if (Page.IsValid)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
// conn.Open();
SqlCommand cmd= new SqlCommand("AddUser",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@UserID",SqlDbType.Char,20));
cmd.Parameters.Add(new SqlParameter("@StudentID",SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@PWD",SqlDbType.NChar,16));
cmd.Parameters.Add(new SqlParameter("@NickName", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@Question", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@Answer", SqlDbType.VarChar, 50));
cmd.Parameters.Add(new SqlParameter("@PicName", SqlDbType.NChar,60));
cmd.Parameters.Add(new SqlParameter("@Remark", SqlDbType.NVarChar, 200));
cmd.Parameters.Add(new SqlParameter("@Sex", SqlDbType.Char, 20));
cmd.Parameters.Add(new SqlParameter("@Tele", SqlDbType.Char,20));
cmd.Parameters.Add(new SqlParameter("@MobilePh", SqlDbType.NChar, 16));
cmd.Parameters.Add(new SqlParameter("@QQ", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@Email", SqlDbType.NChar, 30));
cmd.Parameters.Add(new SqlParameter("@Country", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@Province", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@City", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NChar, 40));
cmd.Parameters.Add(new SqlParameter("@PostNum", SqlDbType.NChar, 10));
cmd.Parameters.Add(new SqlParameter("@RegClass", SqlDbType.VarChar, 300));
cmd.Parameters.Add(new SqlParameter("@biryear", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@birmounth", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@birday", SqlDbType.Char, 10));
cmd.Parameters.Add(new SqlParameter("@etryear", SqlDbType.Char, 10));
//
cmd.Parameters["@UserID"].Value = this.UserID.Text.ToString().Trim();
cmd.Parameters["@StudentID"].Value = this.SorT_ID.Text.ToString().Trim();
cmd.Parameters["@PWD"].Value = this.Password.Text.ToString().Trim();
cmd.Parameters["@NickName"].Value = this.NickName.Text.ToString().Trim();
cmd.Parameters["@Question"].Value = this.Question.Text.ToString().Trim();
cmd.Parameters["@Answer"].Value = this.Answer.Text.ToString().Trim();
cmd.Parameters["@PicName"].Value = "~/HeadPic/" + this.Figure.SelectedItem.Text .ToString().Trim();
cmd.Parameters["@Remark"].Value = this.Remark.Text.ToString().Trim();
if(this.Boy.Checked==true)
cmd.Parameters["@Sex"].Value = this.Boy.Text.ToString().Trim();
else
cmd.Parameters["@Sex"].Value = this.Girl.Text.ToString().Trim();
cmd.Parameters["@Tele"].Value = this.Tele.Text.ToString().Trim();
cmd.Parameters["@MobilePh"].Value = this.Mobile.Text.ToString().Trim();
cmd.Parameters["@QQ"].Value = this.QQ.Text.ToString().Trim();
cmd.Parameters["@Email"].Value = this.Email.Text.ToString().Trim();
cmd.Parameters["@Country"].Value = this.Country.SelectedItem.Text.ToString().Trim();
cmd.Parameters["@Province"].Value = this.Province.SelectedItem.Text.ToString().Trim();
// this.City.SelectedItem.Text;IdToCity(strcity)
cmd.Parameters["@City"].Value = strcity ;
////////////////////////////
cmd.Parameters["@Address"].Value = this.Address.Text.ToString().Trim();
cmd.Parameters["@PostNum"].Value = this.Post.Text.ToString().Trim();
cmd.Parameters["@RegClass"].Value = "";
cmd.Parameters["@biryear"].Value = this.Year.Text.ToString().Trim();
cmd.Parameters["@birmounth"].Value = this.Mounth.Text.ToString().Trim();
cmd.Parameters["@birday"].Value = this.Day.Text.ToString().Trim();
cmd.Parameters["@etryear"].Value = this.ETRTime.Text;
cmd.Connection.Open();
try
{
cmd.ExecuteNonQuery();
}
catch
{
this.Remark.Text = "wrong";
// Response.Write("wrong");
return;
}
cmd.Connection.Close();
// this.selspan.InnerHtml =
Session["UserID"] = this.UserID.Text;
Response.Redirect("main.aspx");
}
}
private string IdToCity(string str)
{
SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
string cmd = "select city from city where cityID='" + str + "'"; //设置SQL命令
conn.Open();
SqlCommand myCommand = new SqlCommand(cmd, conn);
SqlDataReader jie = myCommand.ExecuteReader();
return jie["city"].ToString();
}
private void xmlBind(string sortid, string sType)
{
string mystr = "";
string sql = "";
if (sType == "1")
{
sql = "select provinceID as id,province as sname from province where father = " + sortid;
}
else
{
sql = "select cityID as id,city as sname from city where father = " + sortid;
//string sValue = this.Province.SelectedValue;
////第一个下拉框有值才开始绑定第二个下拉框
//if (sValue != "")
//{
//默认显示分类号为1的所有子类
// string cmd = "select cityID,city from city where father = " + sortid;
// DataTable tab = this.Get_Dt(cmd);
// //绑牢控件
// this.City.DataSource = tab;
// this.City.DataSource = tab;
// this.City.DataValueField = "cityID";
// this.City.DataTextField = "city";
// this.City.DataBind();
////}
}
DataTable mytab = this.Get_Dt(sql);
//将取到的值形成: ID|名称,ID|名称...这样的形式
if (mytab.Rows.Count != 0)
{
for (int i = 0; i < mytab.Rows.Count; i++)
{
mystr += "," + mytab.Rows[i]["id"].ToString() + "|" + mytab.Rows[i]["sname"].ToString();
}
mystr = mystr.Substring(1);
}
//输出页面
this.Response.Write(mystr);
this.Response.End();
}
/// <summary>
/// 绑定第一个下拉框
/// </summary>
private void DownBind1()
{
//显示所有的主分类
string sql = "select CountryID,CountryName from Country ";
DataTable mytab = this.Get_Dt(sql);
//绑定第一个下拉框
this.Country.DataSource = mytab;
this.Country.DataValueField = "CountryID";
this.Country.DataTextField = "CountryName";
this.Country.DataBind();
//添加一个"请选择"行
// this.Country.Items.Insert(0, new ListItem("请选择分类", ""));
//为此下拉框添加一个默认选择项,选中第2个选项
if (this.Country.Items.Count > 1)
{
this.Country.SelectedIndex = 0;
}
//为此下拉框添加选择事件,第一个参数是自己
//第二个参数为要填充的下拉框的名称
//第三个参数为求取类型
this.Country.Attributes.Add("onchange", "XmlPost(this,'" + this.Province.ClientID + "','1') ");
}
/// <summary>
/// 绑定第二个下拉框
/// </summary>
private void DownBind2()
{
string sValue = this.Country.SelectedValue;
//为第二个下拉框添加事件
this.Province.Attributes.Add("onchange", "XmlPost(this,'" + this.City.ClientID + "','2') ");
//第一个下拉框有值才开始绑定第二个下拉框
if (sValue != "")
{
//默认显示分类号为1的所有子类
string sql = "select provinceID,province from province where father = " + sValue;
DataTable mytab = this.Get_Dt(sql);
//绑牢控件
this.Province.DataSource = mytab;
this.Province.DataValueField = "provinceID";
this.Province.DataTextField = "province";
this.Province.DataBind();
}
//添加一个空的首行
// this.Province.Items.Insert(0, new ListItem("请选择省份", ""));
//如果有选项,则选中它
if (this.Province.Items.Count > 1)
{
this.Province.SelectedIndex = 0;
}
}
/// <summary>
/// 绑定第三个下拉框
/// </summary>
private void DownBind3()
{
string sValue = this.Province.SelectedValue;
//第一个下拉框有值才开始绑定第二个下拉框
if (sValue != "")
{
//默认显示分类号为1的所有子类
string sql = "select cityID,city from city where father = " + sValue;
DataTable mytab = this.Get_Dt(sql);
//绑牢控件
this.City.DataSource = mytab;
this.City.DataSource = mytab;
this.City.DataValueField = "cityID";
this.City.DataTextField = "city";
this.City.DataBind();
}
if (this.City.Items.Count > 1)
{
this.City.SelectedIndex = 0;
}
//添加一个空的首行
// this.City.Items.Insert(0, new ListItem("请选择城市", ""));
}
protected void ProSel(object sender, EventArgs e)
{
}
protected void CitySel(object sender, EventArgs e)
{
SetCountry();
if (this.Province.SelectedItem.Text =="")
{
this.Binder();
}
}
//protected void Province_SelectedIndexChanged(object sender, EventArgs e)
//{
// SqlConnection conn2 = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
// conn2.Open();
// SqlCommand cmd2 = new SqlCommand();
// cmd2.Connection = conn2;
// cmd2.CommandText = "select distinct id,city from city where father IN (select provinceID from province where province='" + this.Province.SelectedItem.Text + "')";//"+this.Province.Text.ToString()+"
// SqlDataReader sdr2 = cmd2.ExecuteReader();
// this.City.DataSource = sdr2;
// this.City.DataTextField = "city";
// this.City.DataValueField = "id";
// this.City.DataBind();
// conn2.Close();
// SetCountry();
// // Session["TempPro"] = this.Province.SelectedItem.Text;
//}
//protected void SelYear(object sender, EventArgs e)
//{
// // day(this.Mounth.SelectedValue, Convert.ToInt16(this.Year.SelectedValue));
// // IsPostBack = true;
//}
//protected void MounthSel(object sender, EventArgs e)
//{
// // day(this.Mounth.SelectedValue, Convert.ToInt16(this.Year.SelectedValue));
//}
protected void DaySel(object sender, EventArgs e)
{
}
protected void ImgSel(object sender, EventArgs e)
{
string temp = this.Figure.SelectedItem.Text;
// 头像列表 <img id="SelPic" alt="" src="HeadPic/image28.gif" style="width: 46px; height: 43px" />
this.PicLink.Text=" 头像列表 <img id=\"SelPic\" alt=\"\" src=\"HeadPic/"+temp+"\" style=\"width: 46px; height: 43px\" />";
}
//protected void CtrySel(object sender, EventArgs e)
//{
// if (this.Country.SelectedIndex == 1)
// {
// // ArrayList ListImg = new ArrayList();
// // String temp="不用填写";
// // ListImg.Add(temp);
// //this.Province.DataSource = ListImg;
// //this.Province.DataBind();
// // this.City.DataSource = ListImg;
// //this.City.DataBind();
// this.Province.Items.Clear();
// this.City.Items.Clear();
// }
// else
// {
// this.Binder();
// }
//}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
//SqlConnection conn = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]);
//string cmd = "select * from UserInfo where UserID='" + this.UserID.Text.ToString() + "'"; //设置SQL命令
//conn.Open();
//SqlCommand myCommand = new SqlCommand(cmd, conn);
//SqlDataReader jie = myCommand.ExecuteReader();
//if (jie.Read())
//{
// Isexit.Text = "该用户名已注册！";
//}
//else
//{
// Isexit.Text = "该用户名可用";
//}
}
protected void Country_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -