Comments by Member 12857356 (Top 45 by date)

<asp:GridView ID="rptrbus" runat="server" GridLines="None" DataKeyNames="RouteID"
AutoGenerateColumns="false" onrowdatabound="rptrbus_RowDataBound">
<columns>
<asp:templatefield>
<itemtemplate>

<asp:Panel ID="pnlGrd" runat="server" Style="display: none">
<asp:DataList ID="dlSeat" runat="server" RepeatColumns="4">
<itemtemplate>
<asp:Button ID="btnSeat" CssClass="btnseat" runat="server" Text='<%#Bind("Seatno") %>' />





<asp:Label ID="lblBusname" runat="server" Text='<%#Bind("TravelsName") %>'>



<asp:Label ID="lblBusfare" runat="server" Text='<%#Bind("StartTime") %>'>

<asp:Label ID="lblEndtime" runat="server" Text='<%#Bind("EndTime") %>'>




<asp:Label ID="lblTravtime" runat="server" Text='<%#Bind("TravelTime") %>'>


Rs:<asp:Label ID="lbFare" runat="server" Text='<%#Bind("fare") %>'>


<asp:Label ID="lblseat" runat="server" Text='<%#Bind("NoOfseats")%>'>


<asp:Button ID="btnSeat" style="
background-color: brown;
color: antiquewhite;
height: 24px;
border-radius: 12px;
" runat="server" CssClass="seatbtn" Text="ViewSeats" />
<%--<asp:Label ID="lbl" runat="server" style="
background-color: brown;
color: antiquewhite;
height: 24px;
border-radius: 12px;
" CssClass="seatbtn" Text="ass"
>--%>

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Configuration;
using System.Data;
using System.Web.Services;
using System.Text;
using System.Data.SqlClient;

public partial class ViewBusDetails : System.Web.UI.Page
{
string from;
string to;
string date;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
from = Request.QueryString["from"].ToString();
to = Request.QueryString["to"].ToString();
date = Convert.ToString(Request.QueryString["date"]);
string cs = ConfigurationManager.ConnectionStrings["str"].ConnectionString;
using (SqlConnection con = new SqlConnection(cs))
{
con.Open();
SqlCommand cmd = new SqlCommand("spSearchBus", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@from", from);
cmd.Parameters.AddWithValue("@to", to);
cmd.Parameters.AddWithValue("@date", date);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
//grdViewbus.DataSource = dt;
//grdViewbus.DataBind();
rptrbus.DataSource = dt;
rptrbus.DataBind();
}
}
}

private static DataTable GetData(string query)
{
string strConnString = ConfigurationManager.ConnectionStrings["str"].ConnectionString;
using (SqlConnection con = new SqlConnection(strConnString))
{
SqlCommand cmd = new SqlCommand(query, con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
string id=HttpContext.Current.Session["id"].ToString();
cmd.Parameters.AddWithValue("@id",id );
DataTable dt = new DataTable();
da.Fill(dt);
return dt;
}
}

protected void rptrbus_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
string id = rptrbus.DataKeys[e.Row.RowIndex].Value.ToString();
Session["id"]=id.ToString();
DataList dlseat = e.Row.FindControl("dlSeat") as DataList;
dlseat.DataSource=GetData(string.Format("sp_Trial"));
dlseat.DataBind();
}
}
}