gridview没有显示 [英] gridview is not displaying
问题描述
按钮单击第二个选项卡不起作用。当我在第二个选项卡中单击确定按钮时,它会重定向到另一个页面(该页面应显示gridview)
现在问题是页面重定向正在发生,但它没有显示gridview。
我的数据库查询是正确的。(我通过调试中的查询检查了它)
这里是代码:
button click in second tab is not working.when i click OK button in second tab ,it redirects to another page(that page should display gridview)
Now the problem is page redirection is happening but it's not displaying gridview.
My database query is correct.(i was checked it by taking the query in debugging)
here is the code:
<pre lang="c#"><pre lang="c#"><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="User.aspx.cs" Inherits="Online_Billing_System.User" %>
<%@ Register Namespace="AjaxControlToolkit" Assembly="AjaxControlToolkit" tagPrefix="ajax" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>User</title>
<style type="text/css">
.style1
{
width: 147px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<ajax:ToolkitScriptManager ID="scriptmanager1" runat="server">
</ajax:ToolkitScriptManager>
<div style=" width:69%">
<ajax:TabContainer ID="usertabContainer" runat="server" ActiveTabIndex="1"
önactivetabchanged="usertabContainer_ActiveTabChanged" AutoPostBack="true" >
<ajax:TabPanel ID="tbpnlbal" runat="server" ><HeaderTemplate>View Balance</HeaderTemplate><ContentTemplate><asp:Panel ID="viewbal" runat="server" Width="498px"><table align="center"><tr><td align="right" colspan="2" ></td><td>Account Balance </td></tr><tr><td></td><td align="right" >Member ID: </td><td><asp:TextBox
ID="txtusermemid" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right" >Card ID: </td><td><asp:TextBox
ID="txtusercardid" runat="server" ></asp:TextBox></td></tr><tr><td></td><td align="right">Name: </td><td><asp:TextBox
ID="txtusername" runat="server"></asp:TextBox></td><td></td>
<td><asp:Label ID="Label1" runat="server" Text="(Optional)"></asp:Label></td>
</tr><tr><td></td><td></td><td align="left" ><asp:Button ID="btnbalok" runat="server" Text="OK" onclick="btnbalok_Click"/>
<asp:Button ID="btnbalcancel" runat="server" Text="Clear"
OnClientClick="this.form.reset();return false;"/></td></tr></table></asp:Panel></ContentTemplate></ajax:TabPanel>
<ajax:TabPanel ID="tbpnltxhistory" runat="server" ><HeaderTemplate>Transaction History</HeaderTemplate><ContentTemplate><asp:Panel ID="txhistory" runat="server" Width="545px"><table align="center"><tr><td align="right" colspan="2" ></td><td>Transaction History </td></tr><tr><td align="right" colspan="2">Member ID: </td><td>
<asp:TextBox ID="txttxmemid" runat="server"></asp:TextBox></td></tr><tr><td align="right" colspan="2">Card ID: </td><td>
<asp:TextBox ID="txttxcardid" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right">From Date: </td><td><asp:TextBox ID="fromdate" runat="server"></asp:TextBox></td> <ajax:CalendarExtender ID="CalendarExtender1"
TargetControlID="fromdate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td></tr><tr><td></td><td align="right">To Date: </td><td><asp:TextBox ID="todate" runat="server"></asp:TextBox></td> <ajax:CalendarExtender ID="CalendarExtender2"
TargetControlID="todate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td></tr><tr><td><asp:Button
ID="btnhistoryok" runat="server" Text="OK" colspan="2" align="center"
onclick="btnhistoryok_Click" /></td><td><asp:Button ID="btnhistorycancel"
runat="server" Text="Clear" OnClientClick="this.form.reset();return false;" /></td></tr></table></asp:Panel></ContentTemplate></ajax:TabPanel>
<ajax:TabPanel ID="tbpnlprofile" runat="server" ><HeaderTemplate>Profile Setting</HeaderTemplate><ContentTemplate><asp:Panel ID="profile" runat="server" Width="569px"><table align="center"><tr><td></td><td align="right" ></td><td align="center">Profile Settings </td></tr><tr><td></td><td align="right" >Member ID: </td><td>
<asp:TextBox ID="txtsettingmemid" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right" >Card ID: </td><td>
<asp:TextBox ID="txtsettingcardid" runat="server" ></asp:TextBox></td></tr><tr><td></td><td align="right">Name: </td><td>
<asp:TextBox ID="txtsettingname" runat="server"></asp:TextBox></td></tr> <tr><td></td><td align="right">Date Of Membership: </td><td>
<asp:TextBox ID="txtsettingdate" runat="server"
></asp:TextBox> </td><td>
<ajax:CalendarExtender ID="calendar2"
TargetControlID="txtsettingdate" runat="server" PopupButtonID="calendar"
Format="yyyy-MM-dd" Enabled="True"></ajax:CalendarExtender></td>
<tr><td></td><td align="right">Opening Balance: </td><td>
<asp:TextBox ID="txtsettingopenbal" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right" >Phone No: </td><td>
<asp:TextBox ID="txtsettingphone" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right" >Address: </td><td align="left">
<asp:TextBox ID="txtsettingaddress" runat="server"></asp:TextBox></td></tr><tr><td></td><td align="right">Password:</td><td align="left">
<asp:TextBox ID="txtsettingpwd" runat="server"></asp:TextBox></td><td><asp:hyperlink ID="Hyperlink1" runat="server">Edit</asp:hyperlink></td></tr><tr><td></td><td align="right">Confirm Password</td><td align="left">
<asp:TextBox ID="txtsettingconfirmpwd" runat="server"></asp:TextBox></td></tr></table></asp:Panel></ContentTemplate></ajax:TabPanel>
</ajax:TabContainer>
</div>
</form>
</body>
</html>
and it’s codebehind is:
and it's codebehind is:
<pre lang="c#">using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using MySql.Data.MySqlClient;
namespace Online_Billing_System
{
public partial class User : System.Web.UI.Page
{
String ConnectionString = WebConfigurationManager.ConnectionStrings["myConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void btnbalok_Click(object sender, EventArgs e)
{
if (txtusermemid.Text != "" || txtusercardid.Text != "")
Response.Redirect("~/Balance.aspx?memberid=" + txtusermemid.Text.Replace("&", "%26") +
"&cardid=" + txtusercardid.Text.Replace("&", "%26"));
else
{
Response.Write("<script type='text/javascript'>");
Response.Write("alert('PLEASE ENTER EITHER MEMBER ID or CARD ID');");
Response.Write("</script>");
}
}
protected void btnhistoryok_Click(object sender, EventArgs e)
{
if (txttxmemid.Text != "" || txttxcardid.Text != "")
Response.Redirect("~/Transaction.aspx?memberid=" + txttxmemid.Text.Replace("&", "%26") +
"&cardid=" + txttxcardid.Text.Replace("&", "%26")+"&fromdate=" +fromdate.Text.Replace("&", "%26") +
"&todate=" + todate.Text.Replace("&", "%26"));
else
{
Response.Write("<script type='text/javascript'>");
Response.Write("alert('PLEASE ENTER DETAILS');");
Response.Write("</script>");
}
}
protected void usertabContainer_ActiveTabChanged(object sender, EventArgs e)
{
string uname = Request.QueryString["UserName"];
String password = Request.QueryString["Password"];
if (usertabContainer.ActiveTabIndex == 2)
{
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "select member_id,card_id,name,date_of_membership,opening_balance,phone_number,address,password,confirm_password from admin where member_id='" + uname + "' ";
MySqlCommand command = new MySqlCommand(query, con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{
txtsettingmemid.Text = rdr["member_id"].ToString();
txtsettingcardid.Text = rdr["card_id"].ToString();
txtsettingname.Text = rdr["name"].ToString();
txtsettingdate.Text = rdr["date_of_membership"].ToString();
txtsettingopenbal.Text = rdr["opening_balance"].ToString();
txtsettingphone.Text = rdr["phone_number"].ToString();
txtsettingaddress.Text = rdr["address"].ToString();
txtsettingpwd.Text = rdr["password"].ToString();
txtsettingconfirmpwd.Text = rdr["confirm_password"].ToString();
}
}
}
}
}
}
}
Transaction.aspx is:
Transaction.aspx is:
<pre lang="c#"><pre lang="c#"><%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Transaction.aspx.cs" Inherits="Online_Billing_System.Transaction" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:GridView ID="transactionGridView" runat="server" BackColor="#DEBA84"
BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px" CellPadding="3"
CellSpacing="2"
>
<FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
<HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
<PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
<RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
<SortedAscendingCellStyle BackColor="#FFF1D4" />
<SortedAscendingHeaderStyle BackColor="#B95C30" />
<SortedDescendingCellStyle BackColor="#F1E5CE" />
<SortedDescendingHeaderStyle BackColor="#93451F" />
</asp:GridView>
</div>
</form>
</body>
</html>
and codebehind for transaction is
and codebehind for transaction is
<pre lang="c#">using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.Configuration;
using MySql.Data.MySqlClient;
namespace Online_Billing_System
{
public partial class Transaction : System.Web.UI.Page
{
String ConnectionString = WebConfigurationManager.ConnectionStrings["myConnectionString"].ToString();
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
String memberid = Request.QueryString["memberid"];
String cardid = Request.QueryString["cardid"];
String fromdate = Request.QueryString["fromdate"];
String todate = Request.QueryString["todate"];
using (MySqlConnection con = new MySqlConnection(ConnectionString))
{
String query = "select member_id,card_id,name,paid_amount,due_amount,paid_date,location,phone_number from transaction where DATE(paid_date)BETWEEN '" + fromdate + "'AND'" + todate + "' ";
if (memberid != "")
{
query = query + " AND " + "member_id=" + "'" + memberid + "' ";
}
if (cardid != "")
{
query = query + " OR " + "card_id=" + "'" + cardid + "' ";
}
MySqlCommand command = new MySqlCommand(query, con);
con.Open();
using (MySqlDataReader rdr = command.ExecuteReader())
{
if (rdr.Read())
{
transactionGridView.DataSource = rdr;
transactionGridView.DataBind();
transactionGridView.Visible = true;
}
}
}
}
}
}
}
How to solve it ,am struggling a lot. plz anybody help me...
How to solve it ,am struggling a lot. plz anybody help me...
推荐答案
First Add some columns to the display the data or set AutoGenerateColumns property to True as per your requirement. And most importantly, Check the DataReader which you are binding with the Gridview contains rows to display.
First Add some columns to the display the data or set AutoGenerateColumns property to True as per your requirement. And most importantly, Check the DataReader which you are binding with the Gridview contains rows to display.
这篇关于gridview没有显示的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!