private void PersonalCenter_Load(object sender, EventArgs e) { string sql = "select * from Client where ClientId='" + Program.username + "'"; DBTools bb = new DBTools(); SqlDataReader reder = bb.reader(sql); while (reder.Read()) { label2.Text = reder["ClientId"].ToString(); textBox1.Text = reder["name"].ToString(); textBox2.Text = reder["age"].ToString(); textBox3.Text = reder["ClientPwd"].ToString(); } }
public bool ksdjhfg()//检验是否已注册 { string asdd = "select count(*) from Client where ClientId='" + comboBox1.Text + "'"; DBTools bb = new DBTools(); int clienID = bb.Login(asdd); if (clienID == 1) { return(true); } else { return(false); } }
private void 影片列表_Load(object sender, EventArgs e) { string sql = @"SELECT [TicketId] ,[MovieName] ,[HouseID] ,[StartTime] ,[EndTime] ,[TicketPrice] ,[number] FROM [movieDB].[dbo].[Movie]"; DBTools dfg = new DBTools(); Moielist = dfg.QuerByAdapter(sql, "MovieList"); dataGridView1.DataSource = Moielist.Tables["MovieList"]; }
private void button1_Click(object sender, EventArgs e) { string sql = string.Format(@"update Client set ClientPwd='{0}',name='{1}',age={2} where ClientId='{3}'", textBox3.Text, textBox1.Text, textBox2.Text, Program.username); DBTools bb = new DBTools(); int i = bb.DonIntsdf(sql); if (i > 0) { MessageBox.Show("保存成功"); } else { MessageBox.Show("保存失败"); } }
private void tuidinToolStripMenuItem_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show("请选择一列数据"); return; } int a = dataGridView1.SelectedRows[0].Index; int OrderId = (int)dataGridView1.Rows[a].Cells["OrderId"].Value; string sql = string.Format(@"update OrderInfo set State='{0}' where OrderId='{1}'", "已退订", OrderId); DBTools bb = new DBTools(); int i = bb.DonIntsdf(sql); if (i > 0) { MessageBox.Show("退订成功"); loadDate(); } else { MessageBox.Show("退订失败"); } }
private void button1_Click(object sender, EventArgs e)//注册 { bool kdfg = ksdjhfg(); if (kdfg == false) { string ID = comboBox1.Text; string PWD = textBox1.Text; string quePWD = textBox2.Text; if (ID != "" && PWD != "" && quePWD != "" && textBox3.Text != "") { if (ID.Length == 11) { bool asd = IsHandset(ID); if (asd) { if (PWD.Length >= 6 && PWD.Length <= 12) { if (PWD == quePWD) { if (textBox3.Text == he.ToString()) { string asdd = @"INSERT INTO [movieDB].[dbo].[Client] ([ClientId] ,[ClientPwd]) VALUES ('" + ID + "','" + PWD + "')"; DBTools bb = new DBTools(); int clienID = bb.DonIntsdf(asdd); if (clienID == 1) { MessageBox.Show("注册成功,立即返回登录界面", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk); this.Close(); } else { MessageBox.Show("注册失败"); } } else { MessageBox.Show("验证码不正确"); } } else { MessageBox.Show("密码不一致"); } } else { MessageBox.Show("密码长度限制在6-12位"); } } else { MessageBox.Show("手机号格式不正确"); } } else { MessageBox.Show("手机号长度不正确"); } } else { MessageBox.Show("请完善信息!"); } } else { MessageBox.Show("此用户已注册"); } }