如何将数据绑定到gridview1内的gridview2 [英] How to Bind Data to gridview2 which is inside gridview1
本文介绍了如何将数据绑定到gridview1内的gridview2的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有2个gridview im绑定数据到gridview1点击搜索按钮，从数据库中找到记录并显示到gridview1.I在gridview 1中有一个链接按钮我想显示与链接按钮的行相关的数据在对话框中。我的问题是对话框正在打开，但数据没有显示在其中。我正在给出以下代码。
.Aspx页面代码
i have 2 gridview i m binding data to gridview1 by clicking search button which find the record from database and display it into gridview1.I have a link button in gridview 1 i want to show the data related to the row in which link button is in dialog.My problem is dialog is opeaning but the data is not displaying into it.I am giving the code below.
.Aspx page code
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" runat="Server">
<link href="Style/Default.css" rel="stylesheet" />
<link href="Style/jquery-ui-1.9.2.custom.min.css" rel="stylesheet" />
<script src="Scripts/jquery-1.8.3.js"></script>
<link href="Style/Default.css" rel="stylesheet" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.9.0/jquery.min.js"> </script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/jquery-ui.js" type="text/javascript"></script>
<link href="Style/jquery-ui.css" rel="stylesheet" />
<link rel="stylesheet" type="text/css" href="css/smoothness/jquery-ui.css" />
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js"></script>
<script src="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/jquery-ui.js" type="text/javascript"></script>
<link href="http://ajax.aspnetcdn.com/ajax/jquery.ui/1.8.9/themes/start/jquery-ui.css"
rel="stylesheet" type="text/css" />
<script src="Scripts/jquery-ui-1.9.2.custom.min.js"></script>
<script src="Scripts/amazingslider.js"></script>
<script src="Scripts/initslider-1.js"></script>
<style>
.btn_styling {
text-align: center;
width: 32px;
margin: 2px;
cursor: pointer;
border: 1px solid gray;
border-radius: 3px;
/* add a background image to the div
to make the div look like a button */
/* background-image: url('...') */
}
.ui-dialog-titlebar-close {
display: none;
}
</style>
<script type="text/javascript">
var dialogOptions = {
autoOpen: false,
appendTo: "#dialogContainer",
modal: true,
height: "auto",
width: "auto",
title: "Dialog Title",
closeOnEscape: true,
show: { effect: "fold", duration: 4000 },
};
$(".ui-widget-overlay").live("click", function () {
$("div:ui-dialog:visible").dialog("close");
});
$(document).on("click", ".dialog-marker", function () {
var d = $(this).next("div").first().dialog(dialogOptions);
d.dialog("open");
});
</script>
<script type="text/javascript" lang="javascript">
$(function () {
$('#<%= Source.ClientID %>,#<%= Destination.ClientID %>').autocomplete({
source: function (request, response) {
$.ajax({
url: "StopsService.asmx/GetStopList",
data: "{'StopName':'" + request.term + "'}",
type: "POST",
dataType: "json",
contentType: "application/json;charset=utf-8",
success: function (data) {
response(data.d);
},
error: function (data) {
alert('There is aproblem');
}
});
}
});
});
</script>
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<div class="back_img">
<div class="Container">
<div style="margin: 20px 36px 0px 0px; width: auto;">
<div id="amazingslider-1" style="display: block; removed: relative; margin: 16px auto 48px;">
<ul class="amazingslider-slides" style="display: none;">
<li>
<img src="images/1.jpg" alt="Green_Dtc_Bus" /></li>
<li>
<img src="images/4.jpg" alt="Delhi_Metro" /></li>
<li>
<img src="images/5.jpg" alt="Delhi_Metro_Inside" /></li>
<li>
<img src="images/6.jpg" alt="Delhi_Gurgaon_Highway" /></li>
<li>
<img src="images/7.jpg" alt="Delhi_Road" /></li>
<li>
<img src="images/8.jpg" alt="Cabs" /></li>
<li>
<img src="images/Akshardham-temple.jpg" alt="Akshardham" /></li>
<li>
<img src="images/delhi1.jpg" alt="Red Fort" /></li>
<li>
<img src="images/LotusTemple.jpg" alt="LotusTemple" /></li>
<li>
<img src="images/Safdarjung_Tomb,_Delhi.jpg" alt="Safdarjung_Tomb" /></li>
</ul>
<ul class="amazingslider-thumbnails" style="display: none;">
<li>
<img src="images/1-tn.jpg" /></li>
<li>
<img src="images/4-tn.jpg" /></li>
<li>
<img src="images/5-tn.jpg" /></li>
<li>
<img src="images/6-tn.jpg" /></li>
<li>
<img src="images/7-tn.jpg" /></li>
<li>
<img src="images/8-tn.jpg" /></li>
<li>
<img src="images/Akshardham-temple-tn.jpg" /></li>
<li>
<img src="images/delhi1-tn.jpg" /></li>
<li>
<img src="images/LotusTemple-tn.jpg" /></li>
<li>
<img src="images/Safdarjung_Tomb,_Delhi-tn.jpg" /></li>
</ul>
</div>
</div>
<div class="Rt_Src_Container">
<div class="src_container">
<h3 class="h3">Just Enter Your Location</h3>
<asp:Label Text="From" runat="server" ForeColor="WhiteSmoke" /><br />
<asp:TextBox runat="server" CssClass="textbox_src" ID="Source" /><br />
<asp:Label Text="To" runat="server" ForeColor="WhiteSmoke" /><br />
<asp:TextBox runat="server" CssClass="textbox_dest" ID="Destination" /><br />
<asp:Button Text="Search" runat="server" CssClass="search_btn" ID="search" OnClick="search_Click" /><br />
<asp:Label ID="Lblmsg" runat="server" Text="" CssClass="Lblmsg">
</div>
<div class="Routes">
<asp:GridView ID="GridView1" runat="server" DataKeyNames="BusNo" OnRowDataBound="GridView1_RowDataBound" AutoGenerateColumns="False" CellPadding="7" Width="545px">
<columns>
<asp:BoundField DataField="BusNo" HeaderText="Bus No" SortExpression="BusNo">
<HeaderStyle BackColor="#006B89" HorizontalAlign="Center" BorderColor="Black" ForeColor="WhiteSmoke" Font-Size="18px" Font-Bold="false"></HeaderStyle>
<itemstyle backcolor="#E0E0E0" />
<asp:BoundField DataField="RouteName" HeaderText="Route Name" SortExpression="RouteName" HeaderStyle-BackColor="#006B89">
<HeaderStyle BackColor="#006B89" HorizontalAlign="Center" BorderColor="Black" ForeColor="WhiteSmoke" Font-Size="18px" Font-Bold="false"></HeaderStyle>
<itemstyle backcolor="#E0E0E0" />
<asp:TemplateField HeaderText="Info">
<itemtemplate>
<div id="divButton" runat="server" class="btn_styling dialog-marker" title="This could also have been a <button> element or maybe an <img> element...anything really">X</itemtemplate></columns></div>
<div id="popup">
<asp:GridView ID="GridView2" runat="server"
AutoGenerateColumns="False">
<columns>
<asp:BoundField DataField="StopName" HeaderText="StopName" SortExpression="StopName" />
</columns>
</div>
<div id="dialogContainer">
</div>
</div>
</div>
</div>
<%--<div class="gridview_stop">
<%--<asp:GridView ID="Stops" runat="server" AutoGenerateColumns="False" CellPadding="6" Width="190px">
<columns>
<asp:BoundField HeaderText="Bus Stop" DataField="StopName" HeaderStyle-BackColor="#006B89">
<HeaderStyle BackColor="#006B89" Font-Size="18px" Font-Bold="false"></HeaderStyle>
<itemstyle backcolor="#E0E0E0" horizontalalign="Center" />
</columns>
</div>--%>
.CS Page code:
.CS Page code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Data.Sql;
using System.Configuration;
using System.Drawing;
public partial class _Default : System.Web.UI.Page
{
BusinessLayer ob = new BusinessLayer();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DBCS"].ToString());
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
}
}
protected void search_Click(object sender, EventArgs e)
{
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
con.Open();
SqlCommand cmd = new SqlCommand("spGetRoutes", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusStop1", Source.Text);
cmd.Parameters.AddWithValue("@BusStop2", Destination.Text);
adapter.SelectCommand = cmd;
adapter.Fill(ds);
adapter.Dispose();
cmd.Dispose();
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
//Stops.DataSource = null;
//Stops.DataBind();
Lblmsg.Text = "";
}
else
Lblmsg.Text = "No Direct Bus Between These Stop";
Lblmsg.ForeColor = Color.WhiteSmoke;
GridView1.Dispose();
GridView1.DataBind();
//Stops.Dispose();
//Stops.DataBind();
}
public void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
SqlDataAdapter da = new SqlDataAdapter();
GridView gv2 = (GridView)e.Row.FindControl("GridView2");
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand("spGetStops", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
string No = GridView1.DataKeys[e.Row.RowIndex].Value.ToString();
int BusNo = Convert.ToInt32(No);
cmd.Parameters.AddWithValue("@BusNo", BusNo);
da.SelectCommand = cmd;
con.Open();
da.Fill(ds);
da.Dispose();
cmd.Dispose();
con.Close();
gv2.DataSource = ds;
gv2.DataBind();
}
}
}推荐答案
(\".ui-widget-overlay\").live(\"click\", function () {
(".ui-widget-overlay").live("click", function () {
(\"div:ui-dialog:visible\").dialog(\"close\");
});
("div:ui-dialog:visible").dialog("close"); });
(document).on(\"click\", \".dialog-marker\", function () {
var d =
(document).on("click", ".dialog-marker", function () { var d =
这篇关于如何将数据绑定到gridview1内的gridview2的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
