private void button1_Click(object sender, EventArgs e) { string sql = "select user_name, user_code from tbl_user where user_email = " + "'" + EmailBox.Text + "'" + " and " + "user_pw = " + "'" + PasswordBox.Text + "'"; DataTable dt = db.GetDBTable(sql); if (dt.Rows.Count == 0) { MessageBox.Show("회원정보가 없습니다."); EmailBox.Text = ""; PasswordBox.Text = ""; EmailBox.Focus(); return; } foreach (DataRow dr in dt.Rows) { username = dr["USER_NAME"].ToString(); user_code = Int32.Parse(dr["USER_CODE"].ToString()); MessageBox.Show(username + "님 환영합니다."); } this.Visible = false; Form3 f3 = new Form3(); f3.passvalue = username; f3.User_code = user_code; f3.ShowDialog(); //textBox1.Text = sql; db.CloseDB(); }
private void Form4_Load(object sender, EventArgs e) { orderPrice += totalPrice; OrderPriceLabel.Text = "결제금액 : " + orderPrice.ToString() + "원"; foreach (Product product in productList) { //이 안에 인서트 문이 들어가야 된다. sql = "INSERT INTO TBL_ORDER(PRODUCT_NAME, PRODUCT_PRICE, USER_CODE)" + "VALUES(" + "'" + product.Product_name + "'" + ", '" + product.Product_price + "'" + ", '" + product.User_code + "')"; dt = db.GetDBTable(sql); } db.CloseDB(); // TODO: 이 코드는 데이터를 'shoppingDBDataSet1.TBL_ORDER' 테이블에 로드합니다. 필요 시 이 코드를 이동하거나 제거할 수 있습니다. this.shoppingDBDataSet1.TBL_ORDER.Columns.Add("checkbox"); this.tBL_ORDERTableAdapter.Fill(this.shoppingDBDataSet1.TBL_ORDER); }
private void SignInBtn_Click(object sender, EventArgs e) { email = E_mailBox.Text; name = NameBox.Text; phone = PhoneBox.Text; password = PasswordBox.Text; address = AddressBox.Text; if (email == "" || name == "" || phone == "" || password == "" || address == "") { MessageBox.Show("모든 항목을 작성해주셔야 합니다."); return; } string sql = "INSERT INTO TBL_USER(USER_EMAIL, USER_NAME, USER_PHONE, USER_PW, USER_ADDRESS)" + "VALUES(" + "'" + email + "'" + ", " + "'" + name + "'" + ", " + "'" + phone + "'" + ", " + "'" + password + "'" + ", " + "'" + address + "'" + ")"; try { dt = db.GetDBTable(sql); } catch (System.Data.SqlClient.SqlException) { MessageBox.Show("SQL 오류"); return; } MessageBox.Show("회원가입에 성공했습니다."); this.Visible = false; Form1 f1 = new Form1(); f1.ShowDialog(); db.CloseDB(); }