ASP.NET

1-Jun-09 4:18

Below is my databse table..

I can populate this data into the UI Page..
My task is to automatically delete the columns which has '0'(zero) value...and i have to delete the first row of my table...
Hear i am not going to use any itemtemplate column..
I have to write some code in codebehind..

JurisdictionID JurisdictionDescription Year1 Year2 Year3 Year4 Year5 Year6 Year7 
                                        2005 2006   2009      0   0    0      0      
AL                       Alabama         0     0    6         0   0    0      0      
AK                       Alaska          2     0    0         0   0    0      0

Could Anyone suggest me ..How to proceed further in detail with some code... Confused | :confused:

modified on Monday, June 1, 2009 4:24 PM

Ibrahim Bello1-Jun-09 9:24

1-Jun-09 9:24

foreach (GridViewRow Row in grd.Rows)
{
for (int i = 0; i<7; i++)
{
if (Row[i].ToString().Equals("0"))
{
grd.Columns.Remove(Row[i]);
}
}
}

I have not tested this code. Let me know if it works or not so as to fix the errors. Regards

mahichandu1-Jun-09 9:40

1-Jun-09 9:40

hey..i am getting some errors..when am using that code..
in which method we have to write tht code..
i wrote in...

public void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

i am getting errors like this..

1) 'System.Data.DataRow.DataRow(System.Data.DataRowBuilder)' is inaccessible due to its protection level
2) Cannot apply indexing with [] to an expression of 'System.Web.UI.WebControls.GridViewRow'

actually am poor in c# technologies..could you sen dme solution fot this.. Confused | :confused:

Ibrahim Bello1-Jun-09 22:04

1-Jun-09 22:04

Sorry, I was closing from work when I posted. This should work:

foreach (GridViewRow Row in GridView1.Rows)
{
for(int i=0; i < 7; i++)
{
if (Row.Cells[i].Text == "0")
{
GridView1.Columns.Remove(GridView1.Columns[i]);
}
}
}

I called up this function from a button which I created. You can place it within the GridView1_RowDeleting if you wish without problems.

As per deleting first row, I suggest deleting it from database first (using sql query) and re-binding your gridview.

mahichandu2-Jun-09 6:36

2-Jun-09 6:36

hey..thnx for ur reply..

i am writting the code in the row delete event only...
i am not getting any errors..when i execute this code...somehow am unable to delete the columns....

is there any pother way to do..?

Ibrahim Bello2-Jun-09 7:03

2-Jun-09 7:03

If what you want to do is to delete a column from the underlying database table I'm not sure I can help you on that.

If what you want h/ever is to simply hide the column from the GridView this should work otherwise you can replace GridView1.Columns.Remove(GridView1.Columns[i]); with GridView1.Column[i].Visible = false;

I've tested the previous code and it worked.

Why not post more code for us to see where you're getting it wrong?

mahichandu2-Jun-09 7:19

2-Jun-09 7:19

by using above syntax also..i can't see anychange in the table..i can see all the columns..the 0(zero) value cell columns are not hiding.. Frown | :(

actullt my task is to delete those columns..am unable to do that..
atleast i want to try with hiding those columns.. Cry | :((

below i copied my code of populating data into gridview and the rowdelete event..

protected void Page_Load(object sender, EventArgs e)
    {
        PopulateGrid();
       
    }

    public void PopulateGrid()
    {
        SqlConnection sqlConn = null;
        SqlDataAdapter da = null;

        try
        {
            string connString = null;
            SqlCommand cmd1;
            connString = System.Web.Configuration.WebConfigurationManager.AppSettings["SqlServerConnectionString"];
            //connString = "Data Source = SQD-CON4\QSRV1; Initial Catalog = NDI; Integrated Security = SSPI;";
            sqlConn = new SqlConnection(connString);
            sqlConn.Open();
            cmd1 = new SqlCommand("[MED].[usp_SelectAllSDNCounts]", sqlConn);
            cmd1.CommandType = CommandType.StoredProcedure;
            da = new SqlDataAdapter(cmd1);
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds.Tables[0].DefaultView;
            GridView1.DataBind();
        }
        finally
        {
            sqlConn.Close();
            da.Dispose();
            da = null;
        }

    }

public void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
       
        
           foreach (GridViewRow Row in GridView1.Rows)
            {
                for(int i=0; i<11; i++)
                {
                    if (Row.Cells[i].Text == "0")
                    {
                     GridView1.Columns[i].Visible=false;
                    }
                }

            }
    }

Ibrahim Bello2-Jun-09 7:31

2-Jun-09 7:31

Change:

protected void Page_Load(object sender, EventArgs e)
{ PopulateGrid();
}

to:

protected void Page_Load(object sender, EventArgs e)
{
if(!Page.IsPostBack)
{
PopulateGrid();
}
}

Does this help? Smile | :)

mahichandu2-Jun-09 7:48

2-Jun-09 7:48

no..hmmm

it remains the same..i can see the table with all column ..

if u want to know my design page ..see below..

%@ Page Language="C#" AutoEventWireup="true" CodeFile="MedPending.aspx.cs" Inherits="Maintenance_MedPending" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server" >
    <div>
         </div>
        <asp:Panel ID="Panel1" runat="server" style="position:absolute; left: 184px; top: 82px;" Width="740px" CssClass="borderPanel" Height="177px">
        <table style="width:600px;" class="borderPanel">
        <tr>
        <td>
            <asp:GridView ID="GridView1" runat="server"  HeaderStyle-HorizontalAlign="Center" Width="592px" style="position:absolute; left: 68px; top: 26px;" CssClass="GridRowGrayBorder" >
                <RowStyle CssClass="GridRow" />
                <HeaderStyle CssClass="HeaderRow" HorizontalAlign="Center" />
                <EditRowStyle CssClass="GridRow" />
                
            </asp:GridView>
            </td> 
            </tr>
            </table>
        </asp:Panel>
    </form>
</body>
</html>

Ibrahim Bello2-Jun-09 8:09

2-Jun-09 8:09

1. Try putting a breakpoint in the code provided and see if the Row's Cell Text ever evaluates to "0". Does it ever enter the function i gave you?

2. Have you hooked the Row_Deleting method to the control calling it? If not add:

OnRowDeleting = "GridView1_RowDeleting" to this:

<gridview id="GridView1" runat="server" headerstyle-horizontalalign="Center" width="592px" style="position:absolute; left: 68px; top: 26px;" <b="">OnRowDeleting = "GridView1_RowDeleting" CssClass="GridRowGrayBorder">

Or alternatively in Page_Load add:

GridView1.RowDeleting+=new GridViewDeleteEventHandler(GridView1_RowDeleting);

Hope this helps

Ibrahim Bello3-Jun-09 22:08