disabling checkbox column in gridview when there is no records

Question

0.00/5 (No votes)

See more:

here i'm trying to display a gridview with header & footer row when there is no records in the gridview,but i'm taking checkboxes for deleting records so when there is no records that checkbox is shown.thanks in advances.

Posted 1-May-12 20:36pm

sadiq badami

Add a Solution

Comments

CRDave1988 2-May-12 2:40am

Not very clear plese improve ur question and put ur .ascx or aspx code for display grid.

sadiq badami 2-May-12 5:45am

this the code
String sqlSelectQuery = "SELECT PK_ID, EMP_NAME, EMP_AGE, EMP_SALARY FROM EMPLOYEE";
OleDbCommand oCommand = new OleDbCommand(oConnection, sqlSelectQuery);
OleDbDataAdapter oAdapter = new OleDbDataAdapter(oCommand);

//Create the DataSet object and fill it
DataSet oDataSet = new DataSet();
oAdapter.Fill(oDataSet);

//Check if the DataSet object is empty or not,
//if empty then add a blank row.
if(oDataSet.Tables[0].Rows.Count == 0)
{
oDataSet.Tables[0].Rows.Add(oDataSet.Tables[0].NewRow());
}

//Populate the GridView
gvMyGridView.DataSource = oDataSet;
gvMyGridView.DataBind();

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)

Sandeep Mewara · Accepted Answer · 2012-05-02T03:58:00

In RowDataBound event:
1. Look for row type as Header
2. Once found, use FindControl and get the checkbox.
3. Cast the found checkbox into local checkbox variable.
4. Do whatever you like with this checbox now. Disable it.

Done.

Sample:

C#

void GridView1_RowDataBound(Object sender, GridViewRowEventArgs e)
{
    if(e.Row.RowType == DataControlRowType.Header)
    {
        // This is header row
        // You need to put null checks as per need
        CheckBox cb = (CheckBox)e.Row.FindControl("myCheckBox");
        cb.Enabled = false;
    }
}