ASP.NET

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();

        }

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>

haleemasher wrote:

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

haleemasher wrote:

AutoGenerateSelectButton="True" CellPadding="4" DataSourceID="SqlDataSource1"

N Ahmed wrote:

I am new in the forum