Display different FormView based on GridView selected row using C# in ASP.Net

abmk

SOLVED CLOSED ACTIVE ANSWERED
User: abmk
Posted: on Nov 18, 2016 02:02 AM
Forum: Data Controls
Answer: 1
Views: 5121
Sample Code: Download

Earlier I have successfully captured selected gridview row keyfield value to use in another page. Now in another page i have created 3 Buttons to filter out the details and to display the details in 3 different Formviews. User need to select a Button to get the respective details in respective Formview right below each button.

As said, details are successfully being retrieved, but not displaying respective details in Formview after selecting Button. I need help in

1. Displaying details in respective Formview after selecting respective Button 2. All 3 Formview need to be positioned side by side ie.,no overlap

Thanking you in advance and appreciating your helping as always

public partial class Details : System.Web.UI.Page

{
    static string gvDetailsMaterial = string.Empty;
    SqlConnection con = new SqlConnection(("Data Source=ABMKPRASAD-PC;Initial Catalog=FileModule;Persist Security Info=True;User ID=sa; password=krishna"));
  

    protected void Page_Load(object sender, EventArgs e)
     {
        gvDetailsMaterial = Session["SelectedgridRow"].ToString();

        String strgvDetailsQuery = "select * from Allstatus2Export where MATERIAL = @gvDetailsMaterial";
        SqlCommand cmd = new SqlCommand();

        //cmd.Parameters.AddWithValue("@ddlToGrid", ddlItemType.SelectedItem.Value);
        cmd.Parameters.AddWithValue("@gvDetailsMaterial", gvDetailsMaterial);
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = strgvDetailsQuery;
        cmd.Connection = con;
        try
        {
            con.Open();
            SqlDataReader sdr = cmd.ExecuteReader();
           FVbasicdetails.DataSource = sdr;
           FVbasicdetails.DataBind();
            
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            if (con.State == System.Data.ConnectionState.Open)
                con.Close();
            //con.Close();
            con.Dispose();
        }

    }
    
    protected void BasicDetails(object sender, EventArgs e)
    {
       // DataTable dt = (DataTable)ViewState["dt"];
        FVbasicdetails.DataSource = (SqlDataReader)ViewState["sdr"];
        //FVbasicdetails.DataSource = cmd.ExecuteReader();
        FVbasicdetails.DataBind();
   
    }
    protected void StocknPipeDetails(object sender, EventArgs e)
    {
        FVstocknpipedetails.DataSource = (SqlDataReader)ViewState["sdr"];
        FVstocknpipedetails.DataBind();
    }
    protected void ConsumptionDetails(object sender, EventArgs e)
    {
        FVconsumptiondetails.DataSource = (SqlDataReader)ViewState["sdr"];
        FVconsumptiondetails.DataBind();
    }
}

<%@ Page Title="" Language="C#" MasterPageFile="~/SMDMasterPage.master" AutoEventWireup="true" CodeFile="Details.aspx.cs" Inherits="Details" %>
<%@ MasterType VirtualPath="~/SMDMasterPage.master" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="TopContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="MenuContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="LeftContent" Runat="Server">
</asp:Content>
<asp:Content ID="Content5" ContentPlaceHolderID="MainContent" Runat="Server">
   <asp:Button ID="btnBasic" runat="server" Text="Click for Basic Details" OnClick="BasicDetails"
    CommandArgument="1" />
<asp:Button ID="btnStocknPipe" runat="server" Text="Click for Stock n Pipeline Details" OnClick="StocknPipeDetails"
    CommandArgument="2" Visible="true" />
    <asp:Button ID="btnConsumption" runat="server" Text="Click for Consumption Details" OnClick="ConsumptionDetails"
    CommandArgument="3" Visible="true" />
    
  <asp:Panel ID="Panel1" runat="server" ForeColor="Crimson">
    <asp:FormView ID="FVbasicdetails" runat="server" DefaultMode="ReadOnly">
   
    <ItemTemplate>
        <table border="0" cellpadding="0" cellspacing="0">
            <tr>
                <td>
                    Material Cd:
                </td>
                <td>
                    <%# Eval("MATERIAL") %>
                </td>
            </tr>
            <tr>
                <td>
                    OldCatalogueno:
                </td>
                <td>
                    <%# Eval("CATNO") %>
                </td>
            </tr>
            <tr>
                <td>
                    MaterialDesc :
                </td>
                <td>
                    <%# Eval("Material Description")%>
                </td>
            </tr>
             <tr>
                <td>
                    UnitCode :
                </td>
                <td>
                    <%# Eval("Un")%>
                </td>
            </tr>
        </table>
    </ItemTemplate>
</asp:FormView>
      <asp:FormView ID="FVstocknpipedetails" runat="server" DefaultMode="ReadOnly">
          <ItemTemplate>
              <table border="0" cellpadding="0" cellspacing="0">
                  <tr>
                      <td>
                          Stock:
                      </td>
                      <td>
                          <%# Eval("Stock") %>
                      </td>
                  </tr>
                  <tr>
                      <td>
                          Pending PR Qty:
                      </td>
                      <td>
                          <%# Eval("pendPRQty") %>
                      </td>
                  </tr>
                  <tr>
                      <td>
                          Pending PO Qty :
                      </td>
                      <td>
                          <%# Eval("pendingPOQty")%>
                      </td>
                  </tr>
                  <tr>
                      <td>
                          UnitCode :
                      </td>
                      <td>
                          <%# Eval("Un")%>
                      </td>
                  </tr>
              </table>
          </ItemTemplate>
      </asp:FormView>
      
       <asp:FormView ID="FVconsumptiondetails" runat="server" DefaultMode="ReadOnly">
          <ItemTemplate>
              <table border="0" cellpadding="0" cellspacing="0">
                  <tr>
                      <td>
                          Consumption1213:
                      </td>
                      <td>
                          <%# Eval("T1213") %>
                      </td>
                  </tr>
                  <tr>
                      <td>
                          DeptIssues:
                      </td>
                      <td>
                          <%# Eval("DeptIss1516") %>
                      </td>
                  </tr>
                  <tr>
                      <td>
                          Consumption1314:
                      </td>
                      <td>
                          <%# Eval("T1314") %>
                      </td>
                  </tr>
                 </table>
          </ItemTemplate>
      </asp:FormView>
 </asp:Panel>
    
</asp:Content>
<asp:Content ID="Content6" ContentPlaceHolderID="FooterContent" Runat="Server">
</asp:Content>

Download FREE API for Word, Excel and PDF in ASP.Net

Indresh

0 3

Reply
ANSWER
User: Indresh
Replied: on Nov 18, 2016 04:39 AM
Report

Hi abmk,

I have created sample code which fullfill your requirement.

HTML

<form id="form1" runat="server">
<div>
    <asp:GridView ID="GridView1" HeaderStyle-BackColor="#3AC0F2" HeaderStyle-ForeColor="White"
        runat="server" AutoGenerateColumns="false" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
        <Columns>
            <asp:TemplateField HeaderText="CustomerId">
                <ItemTemplate>
                    <asp:Label ID="lblId" Text='<%#Eval("CustomerId")%>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Name">
                <ItemTemplate>
                    <asp:Label ID="lblName" Text='<%#Eval("ContactName")%>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Country">
                <ItemTemplate>
                    <asp:Label ID="lblCountry" Text='<%#Eval("Country") %>' runat="server" />
                </ItemTemplate>
            </asp:TemplateField>
            <asp:ButtonField Text="Select" CommandName="Select" />
        </Columns>
    </asp:GridView>
</div>
</form>

private string constr = ConfigurationManager.ConnectionStrings["Constr"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.GetData();
    }
}

private void GetData()
{
    using (SqlConnection con = new SqlConnection(constr))
    {

        using (SqlCommand cmd = new SqlCommand("SELECT TOP 10 * FROM Customers", con))
        {
            DataTable dt = new DataTable();
            using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
            {
                sda.Fill(dt);
                GridView1.DataSource = dt;
                GridView1.DataBind();
            }
        }
    }
}

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
    foreach (GridViewRow row in GridView1.Rows)
    {
        if (row.RowIndex == GridView1.SelectedIndex)
        {
            row.BackColor = ColorTranslator.FromHtml("#A1DCF2");
            Session["customerId"] = (row.FindControl("lblId") as Label).Text;
        }
        else
        {
            row.BackColor = ColorTranslator.FromHtml("#FFFFFF");
        }
    }

    Response.Redirect("default1.aspx");
}

Default1.aspx

<form id="form1" runat="server">
<div>
    <table border="0" cellpadding="0" cellspacing="0">
        <tr>
            <td>
                <asp:Button ID="btnBasic" runat="server" Text="Click for Basic Details" OnClick="BasicDetails"
                    CommandArgument="1" />
            </td>
            <td>
                <asp:Button ID="btnStocknPipe" runat="server" Text="Click for Stock n Pipeline Details"
                    OnClick="StocknPipeDetails" CommandArgument="2" Visible="true" />
            </td>
            <td>
                <asp:Button ID="btnConsumption" runat="server" Text="Click for Consumption Details"
                    OnClick="ConsumptionDetails" CommandArgument="3" Visible="true" />
            </td>
        </tr>
        <tr>
            <td>
                <asp:Panel ID="Panel3" runat="server" ForeColor="Crimson">
                    <asp:FormView ID="FVbasicdetails" runat="server" DefaultMode="ReadOnly">
                        <ItemTemplate>
                            <table border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td>
                                        CustomerId:
                                    </td>
                                    <td>
                                        <%# Eval("CustomerId") %>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        ComapnyName
                                    </td>
                                    <td>
                                        <%# Eval("CompanyName")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        ContactName :
                                    </td>
                                    <td>
                                        <%# Eval("ContactName")%>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </asp:FormView>
                </asp:Panel>
            </td>
            <td>
                <asp:Panel ID="Panel2" runat="server" ForeColor="Crimson">
                    <asp:FormView ID="FVstocknpipedetails" runat="server" DefaultMode="ReadOnly">
                        <ItemTemplate>
                            <table border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td>
                                        Address:
                                    </td>
                                    <td>
                                        <%# Eval("Address") %>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        City:
                                    </td>
                                    <td>
                                        <%# Eval("City") %>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        Country:
                                    </td>
                                    <td>
                                        <%# Eval("Country")%>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </asp:FormView>
                </asp:Panel>
            </td>
            <td>
                <asp:Panel ID="Panel1" runat="server" ForeColor="Crimson">
                    <asp:FormView ID="FVconsumptiondetails" runat="server" DefaultMode="ReadOnly">
                        <ItemTemplate>
                            <table border="0" cellpadding="0" cellspacing="0">
                                <tr>
                                    <td>
                                        Phone:
                                    </td>
                                    <td>
                                        <%# Eval("Phone")%>
                                    </td>
                                </tr>
                                <tr>
                                    <td>
                                        FaxNo:
                                    </td>
                                    <td>
                                        <%# Eval("Fax") %>
                                    </td>
                                </tr>
                            </table>
                        </ItemTemplate>
                    </asp:FormView>
                </asp:Panel>
            </td>
        </tr>
    </table>
</div>
</form>

private string constr = ConfigurationManager.ConnectionStrings["Constr"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        this.GetDataItem();
    }
}

private void GetDataItem()
{
    using (SqlConnection con = new SqlConnection(constr))
    {

        using (SqlCommand cmd = new SqlCommand("SELECT  * FROM Customers WHERE CustomerId=@CustomerId", con))
        {
            cmd.CommandType = CommandType.Text;
            cmd.Parameters.AddWithValue("@CustomerId", Session["customerId"]);
            SqlDataAdapter sda = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            sda.Fill(dt);
            ViewState["dt"] = dt;
        }
    }
}

protected void BasicDetails(object sender, EventArgs e)
{
    // DataTable dt = (DataTable)ViewState["dt"];
    FVbasicdetails.DataSource =
    FVbasicdetails.DataSource = (DataTable)ViewState["dt"]; //(SqlDataReader)ViewState["sdr"];
    //FVbasicdetails.DataSource = cmd.ExecuteReader();
    FVbasicdetails.DataBind();
}

protected void StocknPipeDetails(object sender, EventArgs e)
{
    FVstocknpipedetails.DataSource = (DataTable)ViewState["dt"];//(SqlDataReader)ViewState["sdr"];
    FVstocknpipedetails.DataBind();
}

protected void ConsumptionDetails(object sender, EventArgs e)
{
    FVconsumptiondetails.DataSource = (DataTable)ViewState["dt"];//(SqlDataReader)ViewState["sdr"];
    FVconsumptiondetails.DataBind();
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Display different FormView based on GridView selected row using C# in ASP.Net

Company

Explore

Follow us

Contact Us