Click here to Skip to main content
16,007,779 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
ASP.NET
<asp:TemplateField HeaderText="Travels Name">
            <ItemTemplate>
               <asp:LinkButton ID="lb1" runat="server" Height="30px" Width="120px"
                    Text='<%# Eval("TRVLSNAME") %>' OnClick ="lb1_Click"></asp:LinkButton>
                 </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Bus Type">
            <ItemTemplate>
                <asp:LinkButton ID="LinkButton4" runat="server" Height="30px" Width="120px" PostBackUrl="~/Seat_Selection.aspx" Text='<%# Eval("Bus_Type") %>'></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Departure Time">
            <ItemTemplate>
                <asp:LinkButton ID="LinkButton5" runat="server" Height="30px" Width="120px"  PostBackUrl="~/Seat_Selection.aspx" Text='<%# Eval("Bus_Timing") %>'></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField HeaderText="Fare">
            <ItemTemplate>
                <asp:LinkButton ID="LinkButton6" runat="server" Height="30px" Width="120px" PostBackUrl="~/Seat_Selection.aspx" Text='<%# Eval("Bus_Fair") %>'></asp:LinkButton>
            </ItemTemplate>
        </asp:TemplateField>
Posted
Updated 24-Apr-12 21:04pm
v3

C#
 SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
    protected void Page_Load(object sender, EventArgs e)
    {
        SqlDataAdapter da = new SqlDataAdapter("select * from BusesInfo", con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        GridView1.DataSource = dt;
        DataBind();

    }
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        string examinationid = GridView1.SelectedValue.ToString();
        SqlDataAdapter da = new SqlDataAdapter("select busName, No,fromtime,totime from Buses where BusNo=" + BusNo, con);
        DataTable dt = new DataTable();
        da.Fill(dt);
        GridView2.DataSource = dt;
        DataBind();
        GridView1.Visible = false;
    }
    protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridView2.Visible = true;
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        GridView1.Visible = true;
    }
}

code for Aspx Page:
ASP.NET
<asp:gridview id="GridView1" runat="server" autogenerateselectbutton="True" xmlns:asp="#unknown">
        DataKeyNames="BusNo" 
        onselectedindexchanged="GridView1_SelectedIndexChanged">
    </asp:gridview>
    <br />
    <asp:gridview id="GridView2" runat="server" xmlns:asp="#unknown">
        onselectedindexchanged="GridView2_SelectedIndexChanged">
    </asp:gridview>
 
Share this answer
 
v2
C#
public void lb1_Click(object sender, EventArgs e)
{
 GridViewRow clickedRow = ((LinkButton)sender).NamingContainer as GridViewRow;
        Label lbl1 = (Label)clickedRow.FindControl("lbl1");
  string TavelsName = clickedRow.Cells[0].Text;
sql connection()=new SqlConnection();
con.open();
sqlcommand cmd=new sqlcommand("Select BusName,BusType from Buses Where TravelsName='"+TravelsName+"'",con);
sqlDataAdapter da=new sqlDataAdapter(cmd);
Dataset ds=new dataSet();
Da.Fill(ds);
GridView2.DataSource=ds;
GridView2.DataBind();
cmd.executeNonQuery();
con.close();
}
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900