public bool addChoThueXe(String cmnd, String bienso, String loaixe, String hieuxe, MemoryStream pic, DateTime ngayhd, DateTime ngaygiaoxe, DateTime ngayhethanthue, double trigiahd) { SqlCommand command = new SqlCommand("Exec pro_ThemXeVaoDanhSachChoThue @bienso , @loaixe , @hieuxe, @hinhanh, @oid, @ngayhd, @ngayhieuluc, @ngayhethan, @trigiahd", mydb.getConnection); command.Parameters.Add("@bienso", SqlDbType.VarChar).Value = bienso; command.Parameters.Add("@loaixe", SqlDbType.VarChar).Value = loaixe; command.Parameters.Add("@hieuxe", SqlDbType.VarChar).Value = hieuxe; command.Parameters.Add("@hinhanh", SqlDbType.Image).Value = pic.ToArray(); command.Parameters.Add("@oid", SqlDbType.VarChar).Value = cmnd; command.Parameters.Add("@ngayhd", SqlDbType.Date).Value = ngayhd; command.Parameters.Add("@ngayhieuluc", SqlDbType.Date).Value = ngaygiaoxe; command.Parameters.Add("@ngayhethan", SqlDbType.Date).Value = ngayhethanthue; command.Parameters.Add("@trigiahd", SqlDbType.Money).Value = trigiahd; mydb.openConnection(); if (command.ExecuteNonQuery() == 1) { mydb.closeConnection(); return(true); } else { mydb.closeConnection(); return(false); } }
public void ExecuteNonQuery(string query) { dbconn = new My_DB(); using (SqlConnection conn = dbconn.getConnection) { dbconn.openConnection(); SqlCommand command = new SqlCommand(query, conn); command.ExecuteNonQuery(); dbconn.closeConnection(); } }
public void ExecuteNonQueryIncludeImage(string query, MemoryStream pic) { dbconn = new My_DB(); using (SqlConnection conn = dbconn.getConnection) { dbconn.openConnection(); SqlCommand command = new SqlCommand(query + " @img", conn); command.Parameters.Add("@img", SqlDbType.Image).Value = pic.ToArray(); command.ExecuteNonQuery(); dbconn.closeConnection(); } }
public DataTable ExecuteQuery(string query) { dbconn = new My_DB(); DataTable dataTable = new DataTable(); using (SqlConnection conn = dbconn.getConnection) { dbconn.openConnection(); SqlCommand command = new SqlCommand(query, conn); SqlDataAdapter adapter = new SqlDataAdapter(command); adapter.Fill(dataTable); dbconn.closeConnection(); } return(dataTable); }
public bool insertKhachHang(String cmnd, String fname, String lname) { SqlCommand command = new SqlCommand("exec pro_ThemKhachHang @cmnd, @fname, @lname", mydb.getConnection); command.Parameters.Add("@cmnd", SqlDbType.VarChar).Value = cmnd; command.Parameters.Add("@fname", SqlDbType.NVarChar).Value = fname; command.Parameters.Add("@lname", SqlDbType.NVarChar).Value = lname; mydb.openConnection(); if (command.ExecuteNonQuery() == 1) { mydb.closeConnection(); return(true); } else { mydb.closeConnection(); return(false); } }