Ali Rooti

Ali Rooti

  • NA
  • 12
  • 9.2k

i want when click on the cell (datagrid) Then Radiobutton.checked=true

Aug 4 2010 12:42 AM

 
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(
"?? ????? ?? ?????? ??? ?????");
}
else
MessageBox.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;
}

}

 
}
i want when click on the cell (datagrid) then if Permission in datagrid was "0" then radiobutton1.checked=true else if Permission in datagrid was "1" then radiobutton1.checked=true else ..... please direction me in this problem for more information pose my program code and picture in this page

Attachment: User.zip