hai my friends
i have a from in c# frmusers,datagridview dgusers connected to oracle manully loading to dgusers
private
void frmusers_Load(object sender, EventArgs e)
{
mysrch();
}
public void mysrch()
{
DataSet dsusers = new DataSet();
myqry1 =
"SELECT USER_ID,USER_NAME,USER_ADDR,USER_STATUS FROM USERS WHERE " + lblsrch.Text + " LIKE'%" + textBox1.Text + "%'ORDER BY USER_ID";
OracleCommand mycom = new OracleCommand(myqry1, cn);
try
{
cn.Open();
OracleDataAdapter mysed = new OracleDataAdapter(mycom);
mysed.Fill(dsusers);
cn.Close();
dgusers.DataSource = dsusers.Tables[0];
dgusers.Columns[0].Width = 75;
dgusers.Columns[1].Width = 300;
dgusers.Columns[2].Width = 300;
dgusers.Columns[3].Width = 25;
dgusers.Columns[0].SortMode =
DataGridViewColumnSortMode.NotSortable;
dgusers.Columns[1].SortMode =
DataGridViewColumnSortMode.NotSortable;
dgusers.Columns[2].SortMode =
DataGridViewColumnSortMode.NotSortable;
dgusers.Columns[3].SortMode = DataGridViewColumnSortMode.NotSortable;
dgusers.RowsDefaultCellStyle.SelectionBackColor = System.Drawing.
Color.DarkBlue;
}
catch (Exception Ex)
{
MessageBox.Show("ERROR MESSAGE USERS 001");
}
finally
{
cn.Close();
}
loading data to my from successfully( I CAN SEE THAT DATA WHEN FORM LOADING)
what i need my fourth field of my table(users) contains USER STATUS (Y/N)
IN MY GRIDVIEW DGUSERS I NEED FOURTH COLUMN AS A CHECK BOX IF Y IT SHOULD SHOW CHECKED,
AND IF N IT SHOULD SHOW UNCHECKED(NOW IT IS SHOWING Y/N IN CELL OF FOURTH COLUMN)
USERS_STATUS VARCHAR2(1);
HOW I CAN REWRITE MY ABOVE CODE FOR THAT
REGARDS
SADIQUE