// khai bao
public SqlConnection cn;
public SqlDataAdapter da;
public BindingManagerBase dsach;
public CurrencyManager Current;
public DataSet ds;
public Boolean them = false;
public SqlCommandBuilder cmd;
public FrmDMMonHoc()
{
InitializeComponent();
}
//ket noi
public void KetNoi()
{
try
{
cn = new SqlConnection("Server=(local);Database=QLHS;Uid=sa;Pwd=sa";
cn.Open();
da = new SqlDataAdapter("select * from DMMON", cn);
}
catch(Exception ex)
{
MessageBox.Show("Loi", ex.Message);
}
}
//hien thi
private void HienThi()
{
try
{
ds = new DataSet();
da.Fill(ds,"DMMON";
cmd= new SqlCommandBuilder(da);
dsach = this.BindingContext[ds,"DMMON"];
dgDMMon.DataSource = ds.Tables["DMMON"];
}
catch(Exception ex)
{
MessageBox.Show("Loi", ex.Message);
}
}
private void XuatMonHoc()
{

if (dsach.Position > -1)
{
txtMaMon.Text = dsach.Current(ds, "DMMON.MaMon";
txtTenMon.Text = dsach.Current(ds, "DMMON.TenMon";
txtSoTiet.Text = dsach.Current(ds, "DMMON.SoTiet";
}
}

private void FrmDMMonHoc_Load(object sender, EventArgs e)
{
KetNoi();
HienThi();
XuatMonHoc();
}