// create a function to insert a new client public bool insertClient(String fname, String lname, String phone, String country) { MySqlCommand command = new MySqlCommand(); String insertQuery = "INSERT INTO `clients`(`first_name`, `last_name`, `phone`, `country`) VALUES (@fnm,@lnm,@phn,@cnt)"; command.CommandText = insertQuery; command.Connection = conn.getConnection(); // @fnm,@lnm,@phn,@cnt command.Parameters.Add("@fnm", MySqlDbType.VarChar).Value = fname; command.Parameters.Add("@lnm", MySqlDbType.VarChar).Value = lname; command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone; command.Parameters.Add("@cnt", MySqlDbType.VarChar).Value = country; conn.openConnection(); if (command.ExecuteNonQuery() == 1) { conn.closeConnection(); return(true); } else { conn.closeConnection(); return(false); } }
//create a function to instert a new client public bool insertClient(String fname, String lname, String phone, String country) { MySqlCommand command = new MySqlCommand(); String insertQuery = "INSERT INTO `client`(`first_name`, `last_name`, `phone`, `country`) VALUES (@fnm,@lnm,@phn,@cnt)"; command.CommandText = insertQuery; command.Connection = conn.getConnection(); //@fnm,@lnm,@phn,@cnt command.Parameters.Add("@fnm", MySqlDbType.VarChar).Value = fname; command.Parameters.Add("@lnm", MySqlDbType.VarChar).Value = lname; command.Parameters.Add("@phn", MySqlDbType.VarChar).Value = phone; command.Parameters.Add("@cnt", MySqlDbType.VarChar).Value = country; conn.openConnection(); //Phương thức ExecuteNonQuery nó chỉ trả về kết quả là số dòng dữ liệu bị ảnh hưởng //Thường dùng khi insert,removed,edit,... if (command.ExecuteNonQuery() == 1) { conn.closeConnection(); return(true); } else { conn.closeConnection(); return(false); } }
// create a function to get a list of room's type public DataTable roomTypeList() { //Tạo đối tượng SqlCommand trong C# để truy vấn và cập nhật tới CSDL SQL Server MySqlCommand command = new MySqlCommand("SELECT * FROM `rooms_category`", conn.getConnection()); //DataAdapter chính là cầu nối giữa Dataset và Datasource MySqlDataAdapter adapter = new MySqlDataAdapter(); DataTable table = new DataTable(); //SelectCommand: Cho phép lấy thông tin từ nguồn dữ liệu về adapter.SelectCommand = command; adapter.Fill(table); return(table); }
private void buttonLogin_Click(object sender, EventArgs e) { CONNECT conn = new CONNECT(); DataTable table = new DataTable(); MySqlDataAdapter adapter = new MySqlDataAdapter(); MySqlCommand command = new MySqlCommand(); String query = "SELECT * FROM `users` WHERE `username`=@usn AND `password`=@pass"; command.CommandText = query; command.Connection = conn.getConnection(); command.Parameters.Add("@usn", MySqlDbType.VarChar).Value = textBoxUsername.Text; command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = textBoxPassword.Text; adapter.SelectCommand = command; adapter.Fill(table); //if the username and the password exists if (table.Rows.Count > 0) { //show the main form this.Hide(); Main_Form mform = new Main_Form(); mform.Show(); } else { if (textBoxUsername.Text.Trim().Equals("")) { MessageBox.Show("Enter Your Username to Login", "Empty Username", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (textBoxPassword.Text.Trim().Equals("")) { MessageBox.Show("Enter Your Password to Login", "Empty PassWord", MessageBoxButtons.OK, MessageBoxIcon.Error); } else { MessageBox.Show("This Username Or Password doesn't Exists", "Wrong Data", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }