Validating GridView Column using C#

Question

0.00/5 (No votes)

See more:

Hi,
I have GridView on my asp.net Page I want to validate the Gridview.
I want that in my Grid , Records with Null Value do not be displayed, like I have some Null values in second column rows. So I need to hide those Null values. In fact entire row with a single null value shouldn't be displayed and I have imported the data in grid from excel.
I have Used this code
This the code that I have use to import the excel file.

C#

protected void Button1_Click(object sender, EventArgs e)
        {
            string target = Server.MapPath("~/Upload");
            if (FileUpload1.HasFile)
            {
                FileUpload1.SaveAs(System.IO.Path.Combine(target, FileUpload1.FileName));

                string connectionString = String.Format(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", target + "\\" + FileUpload1.FileName);
                string query = String.Format("select * from [{0}$]", "Sheet1");
                OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);
                DataSet dataSet = new DataSet();

                dataAdapter.Fill(dataSet);
                GridView1.DataSource = dataSet.Tables[0];
                GridView1.DataBind();

            }
        }

C#

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        string dat = DataBinder.Eval(e.Row.DataItem, "a10").ToString();
        if (dat.Equals(" "))
        {
            // if you use ImageField to display image 
            DataRowView rowView = (DataRowView)e.Row.DataItem;
            rowView.Row["a10"].ToString();
  
            // if you use Image control to display image 
            GridView image = (GridView)e.Row.FindControl("GridView1");

            GridView1.Columns[0].Visible = true;
            image.Visible = false;
        }
    }
}

Posted 8-Mar-12 4:26am

M Ali Qadir

Updated 11-Mar-12 22:50pm

v4

Add a Solution

Comments

M Ali Qadir 8-Mar-12 11:54am

Is there no Ans Please Reply.

ratheesh.kumar88 23-Dec-13 0:01am

Hi,

Please give me the code for gridview search coding using 3-tier application.

bala.vanchi 9-Mar-12 3:55am

you can use ((System.Data.DataRowView)(e.Row.DataItem)).Row.ItemArray[10]==null then you can add coditions

ProEnggSoft 11-Mar-12 3:25am

Edit: Indentation organized. code tags for keywords added - PES

M Ali Qadir 11-Mar-12 5:07am

Hi,Bala this code means that I am checking nulls after that i want that these null value shouldn't be displayed so writing simply "GridView1.Columns[0].Visible = true;" would be enough or not?

M Ali Qadir 11-Mar-12 5:09am

And I should write the code in same event as in my code "DataRowBound"?

4 solutions

Solution 1

Before fetching the records into gridview, check for the null values through the query.

Insert only those records in the grid which does not have null values.

In this way you will not have the records with null values in gridview.

Hope you got an idea through this.

Posted 10-Mar-12 21:15pm

Aniket Yadav

Comments

M Ali Qadir 11-Mar-12 4:18am

Yes That's the great idea "Anik" but How Could I implement on which event of grid would you please give an example,thank you

Aniket Yadav 11-Mar-12 4:59am

Post the sample code of how you enter the records in Gridview.

M Ali Qadir 12-Mar-12 4:47am

Hi,Anik
In fact I have imported the records from excel file,So I am Improving question with more code that tell that excel file imported to grid.

Aniket Yadav 12-Mar-12 5:04am

1. so you have taken the data from excel into dataset... right?
2. Now you can select the record from dataset where your second column is not null.
3. And fetch the output of this into new dataset.
4. Finally fire GridView1.DataSource = newlycreateddataSet.Tables[0];

M Ali Qadir 12-Mar-12 5:26am

Yes from Excel to dataset,Sorry But I did not Understand Please elaborate more.

Aniket Yadav 12-Mar-12 6:51am

dataset.Tables[0].Select("YourSecondColName != "")

from the above query you will get the records which are not null.

Fetch this records into dataset/datatable and then bind this dataset/datatable to gridview

M Ali Qadir 12-Mar-12 7:00am

Yes Understand Now Thank You Anik I will try to Implement It as you Suggest.

Aniket Yadav 12-Mar-12 7:07am

If it has helped you then accept the answer or vote it... :)

M Ali Qadir 12-Mar-12 7:34am

I will vote but please tell me
DataSet ds=new DataSet();
ds.Tables[0].Select("a10 !="");
a10 is column If I am going right?
In second line I think I am not declaring in right way.Please reply How to declare the second line for my second column.

M Ali Qadir 12-Mar-12 7:35am

I have Voted for your Marvelous ans 5/5

Aniket Yadav 12-Mar-12 7:39am

DataSet ds=new DataSet();
ds.Tables[0].Select("a10 !=''");

check this

M Ali Qadir 12-Mar-12 7:47am

ds.Tables[0].Select("a10!=''");I have use this
but exception "Cannot interpret token '!' at position 4."

M Ali Qadir 12-Mar-12 7:58am

Sir I have debugged its not getting to this event I dont think that this event works

M Ali Qadir 12-Mar-12 8:24am

Hi,
Please tell me one thing I am just at the edge of solving it.
if (e.Row.Cells[1].Text ==string.Empty)
{
GridView1.Columns[0].Visible = false;
}
I have used this code then I debugged it then at null row it is showing me ; a space character please tell me now How could I reomve this space and make my row invisible.

Thank you

Aniket Yadav 12-Mar-12 8:27am

try .trim()

if (e.Row.Cells[1].Text.Trim() == string.Empty)

Solution 2

C#

foreach (DataRow drTemp in ds.Tables[0].Select("a10 IS NOT NULL")
{
// Fetch the records in new dataset which is not null
}

Posted 12-Mar-12 2:11am

Aniket Yadav

Comments

M Ali Qadir 12-Mar-12 9:43am

there may be problem with syntax "foreach (DataRow drTemp in ds.Tables[0].Select("a10 IS NOT NULL")"

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)

M Ali Qadir · Accepted Answer · 2012-03-12T04:31:00

Solution 3

It Works as my senior suggests thank you anik
string query = String.Format("select * from [{0}$] where a10 <> ''", "Sheet1");

Posted 12-Mar-12 4:31am

M Ali Qadir

M Ali Qadir · Accepted Answer · 2012-03-12T06:28:00

It works If dont use hard coded query
SO I have done it with this event also

C#

protected void GridView1_RowDataBound1(object sender, GridViewRowEventArgs e)
{
    if (e.Row.RowType == DataControlRowType.DataRow)
    {
        DataRowView rowView = (DataRowView)e.Row.DataItem;
        //rowView.Row["a10"].ToString();

        if (((DataRowView)e.Row.DataItem)["a10"] ==null)
        {
            GridView1.Columns[1].Visible = false;
        }
        if (e.Row.Cells[1].Text == "&nbsp;")
        {

            e.Row.Cells[1].Visible = false;
            //GridView1.SelectedRow.Visible = false;
        }

Validating GridView Column using C#

4 solutions

Solution 1

Solution 2

Solution 3

Solution 4

Add your solution here

Preview 0

Existing Members

...or Join us