using System;using System.Data;using System.Collections.Generic;using System.ComponentModel;using System.Data.SqlClient;using System.Drawing;using System.Text;using System.Windows.Forms;using System.IO;using System.Data.OleDb; namespace WindowsApplication1{public partial class User : Form{ // Constant strings private const string _CommandText ="SELECT UserName,Password,Name,Manager " +"FROM dbo.Users " +"ORDER BY UserName ,Password ";// private const string _CommandText1 =//"SELECT Manager FROM dbo.Users WHERE (Manager = 1) ";private const string _ConnectionString ="Data Source=sedgholi;Initial Catalog=pubs;Integrated Security=True";// Declare global objects...SqlConnection objConnection;SqlDataAdapter objDataAdapter;DataSet objDataSet;DataView objDataView;CurrencyManager objCurrencyManager;public User(){objConnection = new SqlConnection(_ConnectionString);objDataAdapter = new SqlDataAdapter(_CommandText, objConnection);InitializeComponent();} private void FillDataSetAndView(){// Initialize a new instance of the DataSet object...objDataSet = new DataSet();// Fill the DataSet object with data...objDataAdapter.Fill(objDataSet,"Users");// Set the DataView object to the DataSet object...objDataView = new DataView(objDataSet.Tables["Users"]);// Set our CurrencyManager object// to the DataView object...objCurrencyManager = (CurrencyManager)(this.BindingContext[objDataView]);}private void BindFields(){// Clear any previous bindings...textBox1.DataBindings.Clear();textBox2.DataBindings.Clear();textBox3.DataBindings.Clear();// Add new bindings to the DataView object...textBox1.DataBindings.Add("Text",objDataView, "UserName");textBox2.DataBindings.Add("Text",objDataView, "Password");textBox3.DataBindings.Add("Text",objDataView, "Name");}private void ShowPosition(){addd.DataSource = objDataView;addd.Columns[0].HeaderText = "UserName";addd.Columns[1].HeaderText="PassWord";addd.Columns[2].HeaderText = "First And Last Name User";addd.Columns[3].HeaderText = "Permission";} private void User_Load_1(object sender, EventArgs e){addd.ColumnHeadersDefaultCellStyle.BackColor = Color.Pink;FillDataSetAndView();BindFields();ShowPosition();addd.AllowUserToResizeRows = false;addd.AllowUserToResizeColumns = false;}private void addd_CellClick(object sender, DataGridViewCellEventArgs e){if (addd.CurrentRow.Cells[3].Value.ToString() == "0")radioButton1.Checked = true;else if (addd.CurrentRow.Cells[3].Value.ToString() == "1")radioButton2.Checked = true;}private void Add_Click_1(object sender, EventArgs e){SqlCommand objCommand = new SqlCommand();objCommand.Connection = objConnection;objCommand.CommandType = CommandType.Text;if (textBox1.Text == "" || textBox2.Text == "" || textBox3.Text == "" || (radioButton1.Checked && radioButton2.Checked))MessageBox.Show("????? ????? ????? ??? ?? ???? ??????", "???? ????", MessageBoxButtons.OKCancel,MessageBoxIcon.Warning);else{objCommand.CommandText = "INSERT INTO [pubs].[dbo].[Users](UserName,Password,Name,Manager)" +"VALUES (@UserName ,@Password,@Name,@Manager)";objCommand.Parameters.AddWithValue("@UserName", textBox1.Text);objCommand.Parameters.AddWithValue("@Password", textBox2.Text);objCommand.Parameters.AddWithValue("@Name", textBox3.Text);}if (radioButton1.Checked)objCommand.Parameters.AddWithValue("@Manager", 0);else if (radioButton2.Checked){objCommand.Parameters.AddWithValue("@Manager", 1);}else{MessageBox.Show("??? ?????? ?? ?????? ??????", "?????? ??? ?????", MessageBoxButtons.OK);}try{objConnection.Open();objCommand.ExecuteNonQuery();}catch (SqlException SqlExceptionErr){MessageBox.Show("??? ?????? ?????? ?? ????","???? ????", MessageBoxButtons.OKCancel,MessageBoxIcon.Warning );}objConnection.Close();FillDataSetAndView();BindFields();addd.DataSource = objDataView;addd.AllowUserToResizeRows = false;addd.AllowUserToResizeColumns = false;}private void Remove_Click_1(object sender, EventArgs e){if (MessageBox.Show("??? ?? ??? ????? ????? ????? ?????", "??? ?????",MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1)== DialogResult.Yes){SqlCommand objCommand = new SqlCommand();objConnection.Open();objCommand.Connection = objConnection;objCommand.CommandType = CommandType.Text;objCommand.CommandText = "DELETE FROM Users WHERE UserName = @UserName";// Parameter for the B_Isbm field...objCommand.Parameters.AddWithValue("@UserName",this.BindingContext[objDataView, "UserName"].Current);objCommand.ExecuteNonQuery();objConnection.Close();FillDataSetAndView();BindFields();addd.DataSource = objDataView;addd.AllowUserToResizeRows = false;addd.AllowUserToResizeColumns = false;MessageBox.Show("?? ????? ?? ?????? ??? ?????");}elseMessageBox.Show("??? ????? ??????");}private void button1_Click(object sender, EventArgs e){textBox1.DataBindings.Clear();textBox2.DataBindings.Clear();textBox3.DataBindings.Clear();radioButton1.DataBindings.Clear();radioButton2.DataBindings.Clear();textBox1.Text = "";textBox2.Text = "";textBox3.Text = "";radioButton1.Checked = false;radioButton2.Checked = false;}} }
Attachment: User.zip