C#

<br />
 public class ClsLogin<br />
	{<br />
	   public string userName;<br />
	   public string passWord;<br />
	   public static SqlDataAdapter SQLDataAdapter;<br />
	   public static DataSet ODataSet;<br />
	   public SqlCommand sqlcom;<br />
	   public SqlCommandBuilder sqlBuilder;<br />
           }<br />

<br />
 public class ClsUser<br />
	{<br />
		public ClsUser()<br />
		{}<br />
		public DataSet FillUser()<br />
		{<br />
			ClsLogin oClogin  = new ClsLogin();<br />
			ClsLogin.SQLDataAdapter = new SqlDataAdapter("SELECT * FROM tbl_Employee",ClsConnection.SQLConnection);<br />
			ClsLogin.ODataSet = new DataSet();<br />
			try<br />
			{<br />
				ClsLogin.SQLDataAdapter.Fill(ClsLogin.ODataSet,"User");<br />
				<br />
				oClogin.SQLCOMBUILDER =new SqlCommandBuilder(ClsLogin.SQLDataAdapter);<br />
				ClsLogin.SQLDataAdapter.Update(ClsLogin.ODataSet.Tables[0]);<br />
				return ClsLogin.ODataSet ;<br />
<br />
			}<br />
			catch(Exception ex)<br />
			{<br />
				throw ex;<br />
				return ClsLogin.ODataSet;<br />
			}<br />
		}<br />
	}<br />

<br />
               private void btnLoad_Click(object sender, System.EventArgs e)<br />
		{<br />
			this.CheckLoad();<br />
		}<br />
		private CurrencyManager oCm;<br />
                private DataSet oDs;<br />
		private void CheckLoad()<br />
		{<br />
			<br />
			ClsUser oUser =new ClsUser();<br />
			try<br />
			{<br />
				oDs = oUser.FillUser();<br />
				this.dataGrid1.DataSource = oDs.Tables["User"];<br />
				this.oCm = (CurrencyManager)BindingContext[oDs.Tables[0]];<br />
			}<br />
			catch(Exception ex)<br />
			{<br />
				MessageBox.Show("Lỗi sảy ra: " +ex.Message +":"+ex.Source);<br />
			}<br />
		}<br />

<br />
private void btnDelete_Click(object sender, System.EventArgs e)<br />
	{<br />
                	   ClsLogin.ODataSet.Tables[0].Rows.RemoveAt(this.oCm.Position);<br />
								ClsLogin oLogin =new ClsLogin();<br />
<br />
oLogin.sqlBuilder= new SqlCommandBuilder(ClsLogin.SQLDataAdapter);<br />
						  ClsLogin.SQLDataAdapter.Update(ClsLogin.ODataSet.Tables[0]);<br />
			<br />
}<br />