ASP.NET

2-Jul-09 17:57

first i make a gridview it is visible when i made some changes in it,it hides. it visible property is true.plz help

padmanabhan N2-Jul-09 18:21

2-Jul-09 18:21

you have to write your bind coding inside postback or after the (some changes)event. So the reason for grid view not visible is the gridview bind method is not called....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

haleemasher2-Jul-09 18:28

2-Jul-09 18:28

ya i call bind method.

padmanabhan N2-Jul-09 18:39

2-Jul-09 18:39

can you please send the code....

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

himanshu25612-Jul-09 18:41

himanshu2561

2-Jul-09 18:41

Yea,I also think this might be binding issue.Post your code so that problem can be actually find.

himanshu

This is the code

haleemasher2-Jul-09 18:53

2-Jul-09 18:53

public partial class Default2 : System.Web.UI.Page
{
    SqlConnection cnx = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Coupon Management.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
    SqlDataAdapter da1 = new SqlDataAdapter();
    DataSet ds = new DataSet();
    SqlCommand cmd = new SqlCommand();
    DataTable dataTable;

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            FillVendorGrid();

        }
    }

    private void FillVendorGrid()
    {

        dataTable = new DataTable();

        cmd.Connection = cnx;

        cmd.CommandText = "SELECT CouponType.CouponName, Coupon_Info.Coupon_TypeID FROM CouponType INNER JOIN Coupon_Info ON CouponType.CouponTypeID = Coupon_Info.Coupon_TypeID";

        da1 = new SqlDataAdapter(cmd);

        da1.Fill(dataTable);
        GridView1.DataSource = dataTable;
        GridView1.DataSourceID = String.Empty;

    }
    protected void ResultGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {

        GridView1.PageIndex = e.NewPageIndex;

        FillVendorGrid();

    }
    protected void deleting(object sender, GridViewDeleteEventArgs e)
    {

        cmd.Connection = cnx;

        cmd.CommandText = "DELETE FROM Coupon_Info WHERE RecievingDate='" + GridView1.DataKeys[e.RowIndex][0] + "'";

        cnx.Open();

        cmd.ExecuteNonQuery();

        cnx.Close();

        FillVendorGrid();
}

    }

and this is asp code

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AutoGenerateColumns="False" AutoGenerateDeleteButton="True" 
            AutoGenerateSelectButton="True" CellPadding="4" DataSourceID="SqlDataSource1" 
            ForeColor="#333333" GridLines="None" onrowdeleting="deleting" 
            
            style="z-index: 4; top: 425px; left: 280px; position: absolute; height: 312px; width: 691px">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#E3EAEB" />
            <Columns>
                <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
                <asp:BoundField DataField="Coupon" HeaderText="Coupon" 
                    SortExpression="Coupon" />
                <asp:BoundField DataField="Serial Start" HeaderText="Serial Start" 
                    SortExpression="Serial Start" />
                <asp:BoundField DataField="Serial End" HeaderText="Serial End" 
                    SortExpression="Serial End" />
                <asp:BoundField DataField="Recieved By" HeaderText="Recieved By" 
                    SortExpression="Recieved By" />
            </Columns>
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#7C6F57" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>

padmanabhan N2-Jul-09 18:59

2-Jul-09 18:59

haleemasher wrote:
GridView1.DataSource = dataTable; GridView1.DataSourceID = String.Empty;

i dono where the error is... but try to include

private void FillVendorGrid()
{
dataTable = new DataTable();
cmd.Connection = cnx;
cmd.CommandText = "SELECT CouponType.CouponName, Coupon_Info.Coupon_TypeID FROM CouponType INNER JOIN Coupon_Info ON CouponType.CouponTypeID = Coupon_Info.Coupon_TypeID";
da1 = new SqlDataAdapter(cmd);
da1.Fill(dataTable);
GridView1.DataSource = dataTable;
GridView1.DataBind();
}

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

haleemasher2-Jul-09 19:06

2-Jul-09 19:06

thnx 4 help but it doesn't work

himanshu25612-Jul-09 19:12

himanshu2561

2-Jul-09 19:12

Hi,
As you mention in original post when i made some changes in it.What changes you have made??If it is some kind of database operation make sure datable is filling or not..

himanshu

haleemasher2-Jul-09 19:17

2-Jul-09 19:17

changes like change color of gridview not in data source or database

padmanabhan N2-Jul-09 19:21

2-Jul-09 19:21

haleemasher wrote:
changes like change color of gridview

where is the code for that.... in which you you are writing the code for color change...

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

K03062-Jul-09 19:25

K0306

2-Jul-09 19:25

In your .aspx code - you give the "DataSourceID="SqlDataSource1"" - r u bind with this sqldatasource in aspx page, where is that code ?Post your full code with Sqldatasource.

haleemasher2-Jul-09 19:33

2-Jul-09 19:33

SqlConnection cnx = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|Coupon Management.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True");
        SqlDataAdapter da1 = new SqlDataAdapter();
        DataSet ds = new DataSet();
        SqlCommand cmd = new SqlCommand();
        DataTable dataTable;


        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {

                FillVendorGrid();

            }
        }



      private void FillVendorGrid()
      {

          dataTable = new DataTable();

          cmd.Connection = cnx;

          cmd.CommandText = "SELECT CouponType.CouponName, Coupon_Info.Coupon_TypeID FROM CouponType INNER JOIN Coupon_Info ON CouponType.CouponTypeID = Coupon_Info.Coupon_TypeID";

          da1  = new SqlDataAdapter(cmd);

          da1.Fill(dataTable);
          GridView1.DataSource = dataTable;
          GridView1.DataSourceID = String.Empty;

      }
      protected void ResultGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
      {

        GridView1.PageIndex = e.NewPageIndex;

          FillVendorGrid();

      } protected void deleting(object sender, GridViewDeleteEventArgs e)
        {

            cmd.Connection = cnx;

            cmd.CommandText = "DELETE FROM Coupon_Info WHERE RecievingDate='" + GridView1.DataKeys[e.RowIndex][0] + "'";

            cnx.Open();

            cmd.ExecuteNonQuery();

            cnx.Close();

            FillVendorGrid();

        }

and asp code is

asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString2 %>" 
            
            SelectCommand="SELECT CouponType.CouponName, Coupon_Info.Coupon_TypeID FROM CouponType INNER JOIN Coupon_Info ON CouponType.CouponTypeID = Coupon_Info.Coupon_TypeID"></asp:SqlDataSource>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
            AutoGenerateColumns="False" AutoGenerateDeleteButton="True" 
            AutoGenerateSelectButton="True" CellPadding="4" DataSourceID="SqlDataSource1" 
            ForeColor="#333333" GridLines="None" onrowdeleting="deleting" 
            
            style="z-index: 4; top: 425px; left: 280px; position: absolute; height: 312px; width: 691px">
            <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <RowStyle BackColor="#E3EAEB" />
            <Columns>
                <asp:BoundField DataField="Date" HeaderText="Date" SortExpression="Date" />
                <asp:BoundField DataField="Coupon" HeaderText="Coupon" 
                    SortExpression="Coupon" />
                <asp:BoundField DataField="Serial Start" HeaderText="Serial Start" 
                    SortExpression="Serial Start" />
                <asp:BoundField DataField="Serial End" HeaderText="Serial End" 
                    SortExpression="Serial End" />
                <asp:BoundField DataField="Recieved By" HeaderText="Recieved By" 
                    SortExpression="Recieved By" />
            </Columns>
            <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
            <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
            <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
            <EditRowStyle BackColor="#7C6F57" />
            <AlternatingRowStyle BackColor="White" />
        </asp:GridView>

K03062-Jul-09 19:41

K0306

2-Jul-09 19:41

i think code is perfect, but change the datasource id, i.e

asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString2 %>"

Here your are giving id="SqlDataSource2"

but in grid your are using "DataSourceID="SqlDataSource1" "

padmanabhan N2-Jul-09 19:49

2-Jul-09 19:49

haleemasher wrote:
asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:Coupon ManagementConnectionString2 %>"

haleemasher wrote:
AutoGenerateSelectButton="True" CellPadding="4" DataSourceID="SqlDataSource1"

use the correct datasource...

Padmanabhan
My Articles:
Articles[^]
My latest Article:
Word Automation[^]

haleemasher2-Jul-09 20:06