How do I enable textbox in datagridview after clicking checkbox of that row ?

Question

0.00/5 (No votes)

See more:

clicking on checkbox it has to enable the same row ,next column of textbox of datagridview .but here its enabling the next row textbox.how do i restrict it to enable only the same row textbox.using c# code

What I have tried:

public partial class Form1 : Form
   {
       public Form1()
       {
           InitializeComponent();
           dataGridView1.Columns["AMOUNT"].Visible = false;

           //  LoadSerial();

       }
       /*   private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
          {
              LoadSerial();
          }*/

       // int COUNTER = 0;
       private void button1_Click(object sender, EventArgs e)
       {


           //ADDDATA(textBox2.Text, textBox1.Text);
           //string EMINITIESNAME = textBox2.Text;
           //string DESCRIPTION = textBox1.Text;
           int row = 0;
           dataGridView1.Rows.Add();
           row = dataGridView1.Rows.Count - 2;
           dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
           dataGridView1["DESCRIPTION", row].Value = textBox1.Text;
           LoadSerial();

       }
       private void LoadSerial()
       {
           int i = 1;
           foreach (DataGridViewRow row in dataGridView1.Rows)
           {
               row.Cells["ID"].Value = i; i++;
           }

       }


       public void ADDDATA(string AMENITIESNAME, string DESCRIPTION)
       {
           int row = 0;
           dataGridView1.Rows.Add();
           row = dataGridView1.Rows.Count - 2;
           dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
           dataGridView1["DESCRIPTION", row].Value = textBox1.Text;


       }




       private void Form1_Load(object sender, EventArgs e)
       {

       }

       private void textBox1_TextChanged(object sender, EventArgs e)
       {

       }



       private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
       {


           foreach (DataGridViewRow dataGridRow in dataGridView1.Rows)
           {
               if (dataGridRow.Cells["SELECT"].Value != null && (bool)dataGridRow.Cells["SELECT"].Value)
               {

                   dataGridView1.Columns["AMOUNT"].Visible = true;


               }

               else if (dataGridRow.Cells["SELECT"].Value == null)
               {
                   // Unchecked
               }

           }
       }

Posted 16-May-17 22:05pm

saimanisha

Updated 17-May-17 0:28am

Add a Solution

Comments

Afzaal Ahmad Zeeshan 17-May-17 5:18am

So, where is the event handler for that checkbox?

saimanisha 17-May-17 5:30am

THE chekcbox is a columntype in datagridview .
using grid event CellContentClick i checked whether checkbox is checked or not.but i want to make next column textbox to visile state only if checkbox is checked ..but as per the above code when i click second checkbox its displaying next row textbox column.but here i want to make visible only the current row.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Zunayed Shahriar · Accepted Answer · 2017-05-17T00:28:00

Solution 1

First from the DataGridView property, change "AllowUserToAddRows" from "True" to "False"

Changed Snippets:

Change "row = dataGridView1.Rows.Count -2;" to "row = dataGridView1.Rows.Count -1;" in your methods.

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex > -1)
            {
                var curCell = dataGridView1.CurrentCell;
                if (curCell.Value == null || (bool)curCell.Value == false)
                {
                    curCell.Value = true;
                }
                else
                {
                    curCell.Value = false;
                }

                if ((bool)curCell.Value)
                {

                    dataGridView1.Columns["AMOUNT"].Visible = true;
                }
                else
                {
                    dataGridView1.Columns["AMOUNT"].Visible = false;
                }
            }
        }

If this works, please mark this as a solution.

Posted 17-May-17 0:28am

Zunayed Shahriar

Comments

saimanisha 17-May-17 6:58am

the textbox of amount column must not be visible till i click on checkbox .your answer is working partially like its correct but according to my requirement when i click the checkbox of column 4 row1 ,textbox of column 5 and row1 must be visible.

saimanisha 17-May-17 7:06am

iam getting a problem that is second time when am adding data to datagridview without clicking on check box its showing column amount textbox in datagridview.how to overcome this problem

Zunayed Shahriar 18-May-17 2:36am

New Changes

New Method:
private void ResetSelection()
{
foreach (DataGridViewRow row in dataGridView1.Rows)
{
row.Cells["SELECT"].Value = false;
}
}

Changed Methods:

private void button1_Click(object sender, EventArgs e)
{

//ADDDATA(textBox2.Text, textBox1.Text);
//string EMINITIESNAME = textBox2.Text;
//string DESCRIPTION = textBox1.Text;
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count -1;
dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
dataGridView1["DESCRIPTION", row].Value = textBox1.Text;
dataGridView1.Columns["AMOUNT"].Visible = false;
LoadSerial();
ResetSelection();
}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
System.Threading.Thread.Sleep(200);
if (e.RowIndex > -1 && dataGridView1.CurrentCell == dataGridView1.Rows[e.RowIndex].Cells["SELECT"])
{
ResetSelection();
if (dataGridView1.Columns["AMOUNT"].Visible == false)
{
dataGridView1.CurrentCell.Value = true;
dataGridView1.Columns["AMOUNT"].Visible = true;
}
else
{
dataGridView1.Columns["AMOUNT"].Visible = false;
dataGridView1.CurrentCell.Value = false;
}
}
}

Try this. If there is any problem, then let me know.

saimanisha 18-May-17 3:19am

its working same as yesterday code..when i click checkbox of current row it must enable textbox of another column of the same row..but here its working like its enabling disabling the entire column of textbox which is nothing but amount column..

Zunayed Shahriar 18-May-17 3:27am

You just cannot hide a cell. What you can do is this.

Full new source:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace STS_RAM
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();

// LoadSerial();

}
/* private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
LoadSerial();
}*/

// int COUNTER = 0;
private void button1_Click(object sender, EventArgs e)
{

//ADDDATA(textBox2.Text, textBox1.Text);
//string EMINITIESNAME = textBox2.Text;
//string DESCRIPTION = textBox1.Text;
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count -1;
dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
dataGridView1["DESCRIPTION", row].Value = textBox1.Text;
dataGridView1["AMOUNT", row].ReadOnly = true;
dataGridView1["AMOUNT", row].Style.BackColor = Color.Black;
LoadSerial();
}
private void LoadSerial()
{
int i = 1;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
row.Cells["ID"].Value = i; i++;
}

}

public void ADDDATA(string AMENITIESNAME, string DESCRIPTION)
{
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count -1;
dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
dataGridView1["DESCRIPTION", row].Value = textBox1.Text;
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void textBox1_TextChanged(object sender, EventArgs e)
{

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
System.Threading.Thread.Sleep(200);
var amountCell = dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"];
if (e.RowIndex > -1 && dataGridView1.CurrentCell == dataGridView1.Rows[e.RowIndex].Cells["SELECT"])
{
if (amountCell.ReadOnly == true)
{
dataGridView1.CurrentCell.Value = true;
amountCell.ReadOnly = false;
amountCell.Style.BackColor = Color.White;
}
else
{
dataGridView1.CurrentCell.Value = false;
amountCell.ReadOnly = true;
amountCell.Style.BackColor = Color.Black;
}
}
}
}
}

saimanisha 18-May-17 4:00am

IT WORKED THANK YOU..BUT HOW DO I STOP EDITING EVEN AFTER MAKING IT FALSE..ITS GETTING EDITED

saimanisha 18-May-17 4:35am

THE problem is when iam clicking on checkbox its not giving chance to edit..but when am unchecking it its allowing to enter amount..where should we change the code.

Zunayed Shahriar 18-May-17 5:07am

Do not click too fast.
Change "System.Threading.Thread.Sleep(200);" to "System.Threading.Thread.Sleep(300);" to get better.

saimanisha 18-May-17 5:54am

no yaar.its not working.when iam clicking on checkbox it has to allow to text in textbox else it must not..but its doing in reverse order..when am unchecking its allowing to edit..

Zunayed Shahriar 18-May-17 6:38am

New full class:

public partial class Form1 : Form
{
DataGridViewCell lastCell = null;
public Form1()
{
InitializeComponent();

// LoadSerial();

}
/* private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
LoadSerial();
}*/

// int COUNTER = 0;
private void button1_Click(object sender, EventArgs e)
{

//ADDDATA(textBox2.Text, textBox1.Text);
//string EMINITIESNAME = textBox2.Text;
//string DESCRIPTION = textBox1.Text;
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count -1;
dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
dataGridView1["DESCRIPTION", row].Value = textBox1.Text;
dataGridView1["SELECT", row].Value = false;
dataGridView1["AMOUNT", row].ReadOnly = true;
dataGridView1["AMOUNT", row].Style.BackColor = Color.Black;
LoadSerial();
}
private void LoadSerial()
{
int i = 1;
foreach (DataGridViewRow row in dataGridView1.Rows)
{
row.Cells["ID"].Value = i; i++;
}

}

public void ADDDATA(string AMENITIESNAME, string DESCRIPTION)
{
int row = 0;
dataGridView1.Rows.Add();
row = dataGridView1.Rows.Count -1;
dataGridView1["AMENITIESNAME", row].Value = textBox2.Text;
dataGridView1["DESCRIPTION", row].Value = textBox1.Text;
}

private void Form1_Load(object sender, EventArgs e)
{

}

private void textBox1_TextChanged(object sender, EventArgs e)
{

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (lastCell != null)
{
var lastAmtCell = dataGridView1.Rows[lastCell.RowIndex].Cells["AMOUNT"];
if (lastAmtCell.ReadOnly == true)
{
lastCell.Value = false;
}
else
{
lastCell.Value = true;
}
}
var amountCell = dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"];
if (e.RowIndex > -1 && dataGridView1.CurrentCell == dataGridView1.Rows[e.RowIndex].Cells["SELECT"])
{
if (amountCell.ReadOnly == true)
{
dataGridView1.CurrentCell.Value = true;
amountCell.ReadOnly = false;
amountCell.Style.BackColor = Color.White;
}
else
{
dataGridView1.CurrentCell.Value = false;
amountCell.ReadOnly = true;
amountCell.Style.BackColor = Color.Black;
}
lastCell = dataGridView1.CurrentCell;
}
}
}

saimanisha 19-May-17 0:45am

thank you very much ,its working.

saimanisha 23-May-17 2:18am

i have a doubt how do i send this gridview data to sql..here below code but before entering amount in amount cell and after clicking on checkbox it is connecting to sql..here i want the user to enter amount and then it has to check amount cell is empty or not..if not empty it has to insert into sql.

var amountCell = dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"];
if (e.RowIndex > -1 && dataGridView1.CurrentCell == dataGridView1.Rows[e.RowIndex].Cells["CHECKBOX"])
{

if (amountCell.ReadOnly == true)

{
amountCell.ReadOnly = false;
amountCell.Style.BackColor = Color.White;
dataGridView1.Columns["AMOUNT"].Visible = true;
// TimeSpan ts = TimeSpan.FromMilliseconds(150000000);
// bool flag = false;
}

foreach (DataGridViewRow row in dataGridView1.Rows)
{
{
if (Convert.ToString(row.Cells["AMOUNT"].Value) == string.Empty)

{
MessageBox.Show("PLEASE ENTER THE AMOUNT"); return;

}
else
{

// CODE FOR SQL CONNECTION AND STROING THE DATA IN DB
SqlConnection con = new SqlConnection(@"Data Source=DESKTOP-QDGHD7L;Initial Catalog=BANQUET HALL ;PASSWORD=Secret;Integrated Security=True;");
con.Open();
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
string StrQuery = @"INSERT INTO AMENITIES VALUES (@ID,@AMENITIESNAME,@DESCRIPTION,@CHECKBOX,@AMOUNT)";
                                SqlCommand CMD = new SqlCommand(StrQuery, con);
                                CMD.Parameters.AddWithValue("@ID", dataGridView1.Rows[i].Cells[0].Value);
                                CMD.Parameters.AddWithValue("@AMENITIESNAME", dataGridView1.Rows[i].Cells[1].Value);
                                CMD.Parameters.AddWithValue("@DESCRIPTION", dataGridView1.Rows[i].Cells[2].Value);
                                CMD.Parameters.AddWithValue("@CHECKBOX", dataGridView1.Rows[i].Cells[3].Value);
                                CMD.Parameters.AddWithValue("@AMOUNT", dataGridView1.Rows[i].Cells[4].Value);

                                CMD.ExecuteNonQuery();
}
}
else
{
dataGridView1.Rows[e.RowIndex].Cells["AMOUNT"].ReadOnly = true;
amountCell.Style.BackColor = Color.Gray;
dataGridView1.Columns["AMOUNT"].Visible = true;

}
lastCell = dataGridView1.CurrentCell;
}
}
}
}