Xin giúp dùm em với.
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsFormsApplication1
{
accessible fractional chic Frmthemsach : Form
{
accessible Frmthemsach()
{
InitializeComponent();
}
clandestine abandoned Frmthemsach_Load(object sender, EventArgs e)
{
load_Tl();
loaddata();
}
accessible abandoned load_Tl()
{
SqlConnection link = ketnoidulieu.ketnoi();
SqlCommand cmd = new SqlCommand("select MaTL,TenTL from TheLoai", link);
SqlDataAdapter abstracts = new SqlDataAdapter();
data.SelectCommand = cmd;
DataTable TbMatl = new DataTable();
data.Fill(TbMatl);
cb_maloai.DataSource = TbMatl;
cb_maloai.DisplayMember = "TenTL";
cb_maloai.ValueMember = "MaTL";
//comboBoxMaTL.DataBindings.Add("selectedvalue",Capn hatsach.DataSource,"MaTL");
link.Close();
}
clandestine abandoned btnThem_Click(object sender, EventArgs e)
{
SqlConnection da = ketnoidulieu.ketnoi();
cord sql = "insert into Sach(MaS,TenS,MaTL,MaTG,MaNXB,NgayXB,SoLuong,SoLuo ngTon,DonGia)values (@MaS,@TenS,@MaTL,@MaTG,@MaNXB,@NgayXB,@SoLuong,@S oLuongton,@DonGia)";
SqlCommand sqlcom = new SqlCommand(sql, da);
sqlcom.Parameters.AddWithValue("@MaS", txtMaS.Text);
sqlcom.Parameters.AddWithValue("@TenS", txtTenS.Text);
sqlcom.Parameters.AddWithValue("@MaTL", cb_maloai.SelectedValue.ToString());
sqlcom.Parameters.AddWithValue("@MaTG", txtMaTG.Text);
sqlcom.Parameters.AddWithValue("@MaNXB", txtMaNXB.Text);
sqlcom.Parameters.AddWithValue("@NgayXB", datpics_NgayXB.Value.ToString());
try
{
sqlcom.Parameters.AddWithValue("@SoLuong", int.Parse(txtsoluong.Text));
}
catch
{
MessageBox.Show(" Số lượng phải nhập kí tự số: ");
}
try
{
sqlcom.Parameters.AddWithValue("@SoLuongTon", int.Parse(txtsoluongton.Text));
}
catch
{
MessageBox.Show(" Số lượng còn phải là kí tự số: ");
}
sqlcom.Parameters.AddWithValue("@DonGia", txtdongia.Text);
sqlcom.ExecuteNonQuery();
cord comand = "select* from Sach";
sqlcom.CommandText = comand;
SqlDataAdapter abstracts = new SqlDataAdapter();
data.SelectCommand = sqlcom;
DataSet ds1 = new DataSet();
data.Fill(ds1);
da.Close();
dtgv_capnhatsach.DataSource = ds1.Tables[0];
}
clandestine abandoned btnXoa_Click(object sender, EventArgs e)
{
Xoa_Sach();
loaddata();
}
accessible abandoned loaddata()
{
SqlConnection link = ketnoidulieu.ketnoi();
cord lenhsql = "select * from Sach";
SqlCommand cmd = new SqlCommand(lenhsql, link);
SqlDataAdapter abstracts = new SqlDataAdapter();
data.SelectCommand = cmd;
DataSet ds = new DataSet();
data.Fill(ds);
link.Close();
dtgv_capnhatsach.DataSource = ds.Tables[0];
}
accessible abandoned Xoa_Sach()
{
SqlConnection link = ketnoidulieu.ketnoi();
cord sql = "delete from Sach area MaS='" + txtMaS.Text + "'";
SqlCommand sqlcom = new SqlCommand(sql, link);
sqlcom.ExecuteNonQuery();
link.Close();
}
clandestine abandoned btt_sua_Click(object sender, EventArgs e)
{
SqlConnection da = ketnoidulieu.ketnoi();
cord sql = "update sach set MaS=@Mas , TenS=@TenS , MaTL=@MaTL ,MaTG=@MaTG,MaNXB=@MaNXB,NgayXB=@NgayXb,SoLuong=@S oLuong,SoLuongTon=@SoLuongTon,DonGia=@DonGia, DonViTinh=@DonViTinh area MaS='" + txtMaS.Text + "'";
SqlCommand sqlcom = new SqlCommand();
sqlcom.Connection = da;
sqlcom.CommandText = sql;
sqlcom.Parameters.AddWithValue("@MaS", txtMaS.Text);
sqlcom.Parameters.AddWithValue("@TenS", txtTenS.Text);
sqlcom.Parameters.AddWithValue("@MaTL", cb_maloai.SelectedIndex.ToString());
sqlcom.Parameters.AddWithValue("@MaTG", txtMaTG.Text);
sqlcom.Parameters.AddWithValue("@MaNXB", txtMaNXB.Text);
sqlcom.Parameters.AddWithValue("@NgayXB", datpics_NgayXB.Text);
sqlcom.Parameters.AddWithValue("@SoLuong", txtsoluong.Text);
sqlcom.Parameters.AddWithValue("@SoLuongTon", txtsoluongton.Text);
sqlcom.Parameters.AddWithValue("@DonGia", txtdongia.Text);
//sqlcom.Parameters.AddWithValue("@DonViTinh", do);
sqlcom.ExecuteNonQuery();
loaddata();
}
}
}