查看GridView记录的问题 [英] Problem to view GridView records
问题描述
我有ListView,因为有些记录可用,还有一些文本框,
我必须在页面加载时在gridview中插入listview记录和文本框记录,即使在gridview是视图。帮帮我..
- 这是我的设计视图..
I have ListView in that some records are available and also some textbox,
i have to insert listview records and textbox records in the gridview at page load even at the gridview is view. Help me Out..
--Here My Desgin View..
<%@ Page Language="C#" MasterPageFile="~/AdminHome.master" AutoEventWireup="true" CodeFile="ViewSponcorMembers.aspx.cs" Inherits="ViewSponcorMembers" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<style type="text/css">
.TableCSS
{
border-style:none;
background-color:Gray;
width: 550px;
}
.TableHeader
{
background-color:Gray;
color:White;
font-size:large;
font-family:Verdana;
height:45px;
}
.TableData
{
background-color:Silver;
color:White;
font-family:Courier New;
font-size:medium;
font-weight:bold;
height:30px;
}
.TablePager
{
background-color:Gray;
height:50px;
}
.ButtonCSS
{
color:Black;
height:35px;
font-weight:bold;
}
.NumericButtonCSS
{
font-size:x-large;
font-family:Courier New;
color:White;
font-weight:bold;
}
.CurrentPageLabelCSS
{
font-size:xx-large;
font-family:Courier New;
color:White;
font-weight:bold;
}
.NextPreviousButtonCSS
{
font-size:large;
font-family:Courier New;
color:White;
font-weight:bold;
}
</style>
<script type="text/javascript">
function confirmProcess()
{
if (confirm('Your Records Saved...!!!!'))
{
//if you are missing this, always use ClientID to get reference to button //control when used with master pages
document.getElementById('<%=Button2.ClientID%>').click();
}
}
function UpdateProcess()
{
if (confirm('Your Records Updated...!!!!'))
{
//if you are missing this, always use ClientID to get reference to button //control when used with master pages
document.getElementById('<%=Button3.ClientID%>').click();
}
}
</script>
<asp:MultiView ID="MultiView1" runat="server">
<asp:View ID="LinkButton" runat="server">
<asp:LinkButton ID="lnkViewSponcor" runat="server" Font-Bold="True"
Font-Size="Large" Font-Underline="True" onclick="lnkViewSponcor_Click">View Sponcor</asp:LinkButton>
<asp:LinkButton ID="lnkSetPayout" runat="server" Font-Bold="True"
Font-Size="Large" Font-Underline="True" onclick="lnkSetPayout_Click">Set Payout</asp:LinkButton>
<asp:LinkButton ID="lnkPayout" runat="server" Font-Bold="True"
Font-Size="Large" Font-Underline="True" onclick="lnkPayout_Click">Payout</asp:LinkButton>
</asp:View>
<asp:View ID="ViewSponcor" runat="server">
<div>
<h2 style="color:Navy; font-style:italic;">View Sponcor Id</h2>
<hr width="575" align="left" color="PowderBlue" />
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:sqlCon %>"
SelectCommand="SELECT sponcorid,leftcount,rightcount,totcount,pair FROM TestCounter_Master">
</asp:SqlDataSource>
<asp:ListView
ID="gvUserInfo"
runat="server"
DataSourceID="SqlDataSource1" onitemcommand="gvUserInfo_ItemCommand"
onselectedindexchanged="gvUserInfo_SelectedIndexChanged">
<LayoutTemplate>
<table id="Table1" runat="server" class="TableCSS" border="5">
<tr id="Tr1" runat="server" class="TableHeader">
<td id="Td1" runat="server">Sponcor Id</td>
<td id="Td2" runat="server">Left Members</td>
<td id="Td4" runat="server">Right Members</td>
<td id="Td5" runat="server">Total Members</td>
<td id="Td6" runat="server">Total Pairs</td>
</tr>
<tr id="ItemPlaceholder" runat="server">
</tr>
<tr id="Tr2" runat="server" class="TablePager">
<td id="Td3" runat="server" colspan="2">
<asp:DataPager ID="DataPager1" runat="server">
<Fields>
<asp:NextPreviousPagerField
ButtonType="Button"
ShowFirstPageButton="true"
ShowNextPageButton="true"
ShowPreviousPageButton="false"
ButtonCssClass="ButtonCSS"
/>
<asp:NumericPagerField
NumericButtonCssClass="NumericButtonCSS"
CurrentPageLabelCssClass="CurrentPageLabelCSS"
NextPreviousButtonCssClass="NextPreviousButtonCSS"
/>
<asp:NextPreviousPagerField
ButtonType="Button"
ShowLastPageButton="true"
ShowNextPageButton="false"
ButtonCssClass="ButtonCSS"
/>
</Fields>
</asp:DataPager>
</td>
</tr>
</table>
</LayoutTemplate>
<ItemTemplate>
<tr class="TableData">
<td>
<asp:Label
ID="lblsponcorid"
runat="server"
Text='<%# Eval("sponcorid")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID="lblleft"
runat="server"
Text='<%# Eval("leftcount")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID="lblright"
runat="server"
Text='<%# Eval("rightcount")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID="lbltotcount"
runat="server"
Text='<%# Eval("totcount")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID="lblpair"
runat="server"
Text='<%# Eval("pair")%>'>
</asp:Label>
</td>
<td>
<asp:Button ID="btnpaysponcor" runat="server" Text="Pay Sponcor" />
</td>
</tr>
</ItemTemplate>
</asp:ListView>
<asp:Label ID="Label1" runat="server"></asp:Label>
<asp:Label ID="Label2" runat="server"></asp:Label>
<asp:Label ID="Label3" runat="server"></asp:Label>
<asp:Label ID="Label4" runat="server"></asp:Label>
<asp:Label ID="Label5" runat="server"></asp:Label>
<asp:Label ID="Label6" runat="server"></asp:Label>
</div>
</asp:View>
<asp:View ID="ViewSetPayout" runat="server">
<asp:Panel ID="Panel1" runat="server">
<table>
<tr>
<td>
<asp:Label ID="lbltds" runat="server" Text="Tds"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID="txttds" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblsercharge" runat="server" Text="Service Charges"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID="txtsercharge" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lbldeve_charges" runat="server" Text="Development Charges"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID="txtdeve_charges" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lbltrimming" runat="server" Text="Trimming"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID="txttrimming" runat="server"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="2">
<asp:Button ID="btnsubmit" runat="server" Text="INSERT"
onclick="btnsubmit_Click" />
<asp:Button ID="Button2" runat="server" CausesValidation="False" OnClick="Button2_Click"
Style="position: static; display: none" Text="Ok" />
<asp:Button ID="Button3" runat="server" CausesValidation="False" OnClick="Button3_Click"
Style="position: static; display: none" Text="Ok" />
</td>
<td>
<asp:Button ID="btnupdate" runat="server" Text="UPDATE" onclick="btnupdate_Click"
/>
</td>
</tr>
</table>
</asp:Panel>
</asp:View>
<asp:View ID="PaidPayout" runat="server">
<asp:GridView ID="gvpayout" runat="server" BackColor="White"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3"
ForeColor="Black" GridLines="Vertical"
onrowdatabound="gvpayout_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="Sponcor Id">
<ItemTemplate>
<asp:Label ID="lblsponcorid1" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="User Name">
<ItemTemplate>
<asp:Label ID="lblusername" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Left Count">
<ItemTemplate>
<asp:Label ID="lblleftcount" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Right Count">
<ItemTemplate>
<asp:Label ID="lblrightcount" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Total Count">
<ItemTemplate>
<asp:Label ID="lbltotcount" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Total Pairs">
<ItemTemplate>
<asp:Label ID="lblpairs" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Amount">
<ItemTemplate>
<asp:TextBox ID="txtamount" runat="server"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Tds">
<ItemTemplate>
<asp:Label ID="lbltds" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Development Charges">
<ItemTemplate>
<asp:Label ID="lbldcharges" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Trimming">
<ItemTemplate>
<asp:Label ID="lblsercharges" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Total Deduct">
<ItemTemplate>
<asp:Label ID="lbltotdeduct" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Total Amount">
<ItemTemplate>
<asp:Label ID="lbltotamt" runat="server"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor="#CCCCCC" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="#CCCCCC" />
</asp:GridView>
</asp:View>
</asp:MultiView>
</asp:Content>
-----Here My Code Behind
-----Here My Code Behind
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class ViewSponcorMembers : System.Web.UI.Page
{
Entity.TestCounter_Master TPObj = new Entity.TestCounter_Master();
Entity.SetPayout_Master SPMObj = new Entity.SetPayout_Master();
DateTime time = DateTime.Now.AddHours(10.30);
SqlCommand com = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection con = new SqlConnection("Data Source=SHILPA;Initial Catalog=TreeDB;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
try
{
MultiView1.ActiveViewIndex = 0;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}
protected void gvUserInfo_ItemCommand(object sender, ListViewCommandEventArgs e)
{
MultiView1.ActiveViewIndex = 1;
//View Sponcor List Data Grid
Label lblsponcor = (Label)e.Item.FindControl("lblsponcorid");
// Label lbluser = (Label)e.Item.FindControl("lblusername");
Label lblleftcount = (Label)e.Item.FindControl("lblleft");
Label lblrightcount = (Label)e.Item.FindControl("lblright");
Label lbltot = (Label)e.Item.FindControl("lbltotcount");
Label lblpairmatch = (Label)e.Item.FindControl("lblpair");
Label1.Text = lblsponcor.ToString();
//Label2.Text = lbluser.ToString();
Label3.Text = lblleftcount.ToString();
Label4.Text = lblrightcount.ToString();
Label5.Text = lbltot.ToString();
Label6.Text = lblpairmatch.ToString();
}
protected void lstpayout_ItemCommand(object sender, ListViewCommandEventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SHILPA;Initial Catalog=TreeDB;Integrated Security=True");
con.Open();
try
{
string a = Label1.Text;
string b = Label2.Text;
int c = Convert.ToInt32(Label3.Text.ToString());
int d = Convert.ToInt32(Label4.Text.ToString());
int e1 = Convert.ToInt32(Label5.Text.ToString());
int f = Convert.ToInt32(Label6.Text.ToString());
Label lblsponcor = (Label)e.Item.FindControl("lblsponcorid1");
Label lblleftcount = (Label)e.Item.FindControl("lblleft1");
Label lblrightcount = (Label)e.Item.FindControl("lblright1");
Label lbltot = (Label)e.Item.FindControl("lbltotcount1");
Label lblpairmatch = (Label)e.Item.FindControl("lblpair1");
double a1 = Convert.ToDouble(txtdeve_charges.Text);
double b1 = Convert.ToDouble(txtsercharge.Text);
double c1 = Convert.ToDouble(txttds.Text);
double d1 = Convert.ToDouble(txttrimming.Text);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
protected void lnkViewSponcor_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
}
protected void lnkSetPayout_Click(object sender, EventArgs e)
{
string str = "SELECT * FROM SetPayout_Master";
com = new SqlCommand(str, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtstr = new DataTable();
da.Fill(dtstr);
if (dtstr.Rows.Count > 0)
{
viewSetPayout();
}
MultiView1.ActiveViewIndex = 2;
}
protected void lnkPayout_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 3;
}
protected void Button2_Click(object sender, EventArgs e)
{
clear();
}
protected void Button3_Click(object sender, EventArgs e)
{
clear();
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SHILPA;Initial Catalog=TreeDB;Integrated Security=True");
//SqlConnection con = new SqlConnection("Data Source=127.0.0.1;Integrated Security=FALSE;Initial Catalog=TreeDB;User Id=phonixsangli;Password=sangli@123");
con.Open();
try
{
string str = "SELECT * FROM SetPayout_Master";
com = new SqlCommand(str, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtstr = new DataTable();
da.Fill(dtstr);
if (dtstr.Rows.Count == 0)
{
SPMObj.tds = txttds.Text;
SPMObj.sercharge = txtsercharge.Text;
SPMObj.deve_charges = txtdeve_charges.Text;
SPMObj.trimming = txttrimming.Text;
SPMObj.createddate = time;
DataTable dtReg = DAL.SetPayout_Master.AddData(SPMObj);
String csname = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
if (!cs.IsStartupScriptRegistered(cstype, csname))
{
String cstext = "confirmProcess()";
cs.RegisterStartupScript(cstype, csname, cstext, true);
}
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public void viewSetPayout()
{
try
{
string query = "SELECT tds,sercharge,deve_charges,trimming FROM SetPayout_Master";
com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtquery = new DataTable();
da.Fill(dtquery);
if (dtquery.Rows.Count > 0)
{
txttds.Text = dtquery.Rows[0]["tds"].ToString();
txtsercharge.Text =dtquery.Rows[0]["sercharge"].ToString();
txtdeve_charges.Text = dtquery.Rows[0]["deve_charges"].ToString();
txttrimming.Text = dtquery.Rows[0]["trimming"].ToString();
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{
try
{
bool flag = false;
string str = "SELECT * FROM SetPayout_Master";
com = new SqlCommand(str, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtstr = new DataTable();
da.Fill(dtstr);
if (dtstr.Rows.Count > 0)
{
SPMObj.tds = txttds.Text;
SPMObj.sercharge = txtsercharge.Text;
SPMObj.deve_charges = txtdeve_charges.Text;
SPMObj.trimming = txttrimming.Text;
SPMObj.createddate = time;
flag = DAL.SetPayout_Master.UpdateData(SPMObj);
String csname = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
if (!cs.IsStartupScriptRegistered(cstype, csname))
{
String cstext = "UpdateProcess()";
cs.RegisterStartupScript(cstype, csname, cstext, true);
}
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public void clear()
{
txtdeve_charges.Text = "";
txtsercharge.Text = "";
txttds.Text = "";
txttrimming.Text = "";
}
protected void gvpayout_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[1].Text = Label1.Text.ToString();//sponcorid
e.Row.Cells[2].Text = Label2.Text.ToString();//username
e.Row.Cells[3].Text = Label3.Text.ToString();//leftcount
e.Row.Cells[4].Text = Label4.Text.ToString();//rightcount
e.Row.Cells[5].Text = Label5.Text.ToString();//totcount
e.Row.Cells[6].Text = Label6.Text.ToString();//pair
TextBox amount = (TextBox)e.Row.FindControl("txtamount");//amount
e.Row.Cells[8].Text = txttds.Text.ToString();//tds
e.Row.Cells[9].Text = txtdeve_charges.Text.ToString();//development charges
e.Row.Cells[10].Text = txtsercharge.Text.ToString();//service charges
double totdeduct = Convert.ToDouble(txttds.Text) + Convert.ToDouble(txttrimming.Text) + Convert.ToDouble(txtsercharge.Text) + Convert.ToDouble(txtdeve_charges.Text);
double totamount = Convert.ToDouble(amount) - totdeduct;
e.Row.Cells[11].Text = Convert.ToDouble(totdeduct).ToString();
e.Row.Cells[12].Text = Convert.ToDouble(totamount).ToString();
}
}
protected void gvUserInfo_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
--I want records taken from multiview view(gvUserInfo) 1 and multiview view 2 and insert in --gridview which in multiview view 3(gvpayout) and it should viewed at time of view 3
--I want records taken from multiview view(gvUserInfo) 1 and multiview view 2 and insert in --gridview which in multiview view 3(gvpayout) and it should viewed at time of view 3
推荐答案
ConnectionStrings:sqlCon %>\"
SelectCommand=\"SELECT sponcorid,leftcount,rightcount,totcount,pair FROM TestCounter_Master\">
</asp:SqlDataSource>
<asp:ListView
ID=\"gvUserInfo\"
runat=\"server\"
DataSourceID=\"SqlDataSource1\" onitemcommand=\"gvUserInfo_ItemCommand\"
onselectedindexchanged=\"gvUserInfo_SelectedIndexChanged\">
<LayoutTemplate>
<table id=\"Table1\" runat=\"server\" class=\"TableCSS\" border=\"5\">
<tr id=\"Tr1\" runat=\"server\" class=\"TableHeader\">
<td id=\"Td1\" runat=\"server\">Sponcor Id</td>
<td id=\"Td2\" runat=\"server\">Left Members</td>
<td id=\"Td4\" runat=\"server\">Right Members</t d>
<td id=\"Td5\" runat=\"server\">Total Members</td>
<td id=\"Td6\" runat=\"server\">Total Pairs</td>
</tr>
<tr id=\"ItemPlaceholder\" runat=\"server\">
</tr>
<tr id=\"Tr2\" runat=\"server\" class=\"TablePager\">
<td id=\"Td3\" runat=\"server\" colspan=\"2\">
<asp:DataPager ID=\"DataPager1\" runat=\"server\">
<Fields>
<asp:NextPreviousPagerField
ShowLastPageButton=\"true\"
< span class =code-attribute> ButtonType=\"Button\"
< span class =code-attribute> ShowFirstPageButton=\"true\"
ShowNextPageButton=\"true\"
ShowPreviousPageButton=\"false\"
ButtonCssClass=\"ButtonCSS\" NextPreviousButtonCssClass=\"NextPreviousButtonCSS\"
< span class =code-attribute> />
<asp:NumericPagerField
NumericButtonCssClass=\"NumericButtonCSS\"
CurrentPageLabelCssClass=\"CurrentPageLabelCSS\"
/>
<asp:NextPreviousPagerField
ButtonType=\"Button\"
ShowNextPageButton=\"false\"
ButtonCssClass=\"ButtonCSS\"
< span class =code-attribute> />
</Fields>
</asp:DataPager>
</td>
</tr>
</table>
</LayoutTemplate>
<ItemTemplate>
<tr class=\"TableData\">
<td>
<asp:Label
ID=\"lblsponcorid\"
runat=\"server\"
Text='<%# Eval(\"sponcorid\")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID=\"lblleft\"
runat=\"server\"
Text='<%# Eval(\"leftcount\")%>'>
</asp:Label>
</td>
<td> $ b$b <asp:Label
ID=\"lblright\"
runat=\"server\"
Text='<%# Eval(\"rightcount\")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID=\"lbltotcount\"
runat=\"server\"
Text='<%# Eval(\"totcount\")%>'>
</asp:Label>
</td>
<td>
<asp:Label
ID=\"lblpair\"
runat=\"server\"
Text='<%# Eval(\"pair\")%>'>
</asp:Label>
</td>
<td>
<asp:Button ID=\"btnpaysponcor\" runat=\"server\" Text=\"Pay Spo ncor\" />
</td>
</tr>
</ItemTemplate>
</asp:ListView>
<asp:Label ID=\"Label1\" runat=\"server\"></asp:Label>
<asp:Label ID=\"Label2\" runat=\"server\"></asp:Label>
<asp:Label ID=\"Label3\" runat=\"server\"></asp:Label>
<asp:Label ID=\"Label4\" runat=\"server\"></asp:Label>
<asp:Label ID=\"Label5\" runat=\"server\"></asp:Label>
<asp:Label ID=\"Label6\" runat=\"< span class=\"code-keyword\">server\"></asp:Label>
</div>
</asp:View>
<asp:View ID=\"ViewSetPayout\" runat=\"server\">
<< span class=\"code-leadattribute\">asp:Panel ID=\"Panel1\" runat=\"server\">
<table>
<tr>
<td>
<asp:Label ID=\"lbltds\" runat=\"server\" Text=\"Tds\"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID=\"txttds\" runat=\"server\"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID=\"lblsercharge\" runat=\"server\" Text=\"Service Charges\"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID=\"txtsercharge\" runat=\"server\"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID=\"lbldeve_charges\" runat=\"server\" Text=\"Development Charges\"></asp:Label>
</td>
<td> : </td>
<td>
<asp:Text Box ID=\"txtdeve_charges\" runat=\"server\"></asp:TextBox>
</td>
</tr>
<tr>
<td >
<asp:Label ID=\"lbltrimming\" runat=\"server\" Text=\"Trimming\"></asp:Label>
</td>
<td> : </td>
<td>
<asp:TextBox ID=\"txttrimming\" runat=\"server\"></asp:TextBox>
</td>asp:TemplateField HeaderText=\"Left Count\">
</tr>
<tr>
<td colspan=\"2\">
<asp:Button ID=\"btnsubmit\" runat=\"server\" Text=\"INSERT\"
onclick=\"btnsubmit_Click\" />
<asp:Button ID=\"Button2\" runat=\"server\" CausesValidation=\"False\" OnClick=\"Button2_Click\"
Style=\"position: static; display: none\" Text=\"Ok\" />
<asp:Button ID=\"Button3\" runat=\"server\" CausesValidation=\"False\" OnClick=\"Button3_Click\"
Style=\"position: static; display: none\" Text=\"Ok\" />
</td>
<td>
<asp:Button ID=\"btnupdate\" runat=\"server\" Text=\"UPDATE\" onclick=\"btnupdate_Click\"
/>
</td>
</tr>
</table>
</asp:Panel>
</asp:View>
<as p:View ID=\"PaidPayout\" runat=\"server\">
<asp:GridView ID=\"gvpayout\" runat=\"server\" BackColor=\"White\"
BorderColor=\"#999999\" BorderStyle=\"Solid\" BorderWidth=\"1px\" CellPadding=\"3\"
ForeColor=\"Black\" GridLines=\"Vertical\"
onrowdatabound=\"gvpayout_RowDataBound\" >
<Columns>
<asp:TemplateField HeaderText=\"Sponcor Id\">
<ItemTemplate>
<asp:Label ID=\"lblsponcorid1\" runa t=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"User Name\">
<ItemTemplate>
<asp:Label ID=\"lblusername\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<
<ItemTemplate>
<asp:Label ID=\"lblleftcount\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Right Count\">
<ItemTemplate>
<asp:Label ID=\"lblrightcount\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Total Count\">
<ItemTemplate>
<asp:Label ID=\"lbltotcount\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Total Pairs\">
<ItemTemplate>
<asp:Label ID=\"lblpairs\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Amount\">
<ItemTemplate>
<asp:TextBox ID=\"txtamount\" runat=\"server\"></asp:TextBox>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderTe xt=\"Tds\">
<ItemTemplate>
<asp:Label ID=\"lbltds\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Development Charges\">
<ItemTemplate>
<asp:Label ID=\"lbldcharges\" runat=\" server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Trimming\">
<ItemTemplate>
<asp:Label ID=\"lblsercharges\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Total Deduct\">
<ItemTemplate>
<asp:Label ID=\"lbltotdeduct\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText=\"Total Amount\">
<ItemTemplate>
<asp:Label ID=\" lbltotamt\" runat=\"server\"></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<FooterStyle BackColor=\"#CCCCCC\" />
<PagerStyle BackColor=\"#999999\" ForeColor=\"Black\" HorizontalAlign=\"Center\" />
<SelectedRowStyle BackColor=\"#000099\" Font-Bold=\"True\" ForeColor=\"White\" />
<HeaderStyle BackColor=\"Black\" Font-Bold=\"True\" ForeColor=\"White\" />
<AlternatingRowStyle BackColor=\"#CCCCCC\" />
</asp:GridView>
</asp:View>
</asp:MultiView>
</asp:Content>
ConnectionStrings:sqlCon %>" SelectCommand="SELECT sponcorid,leftcount,rightcount,totcount,pair FROM TestCounter_Master"> </asp:SqlDataSource> <asp:ListView ID="gvUserInfo" runat="server" DataSourceID="SqlDataSource1" onitemcommand="gvUserInfo_ItemCommand" onselectedindexchanged="gvUserInfo_SelectedIndexChanged"> <LayoutTemplate> <table id="Table1" runat="server" class="TableCSS" border="5"> <tr id="Tr1" runat="server" class="TableHeader"> <td id="Td1" runat="server">Sponcor Id</td> <td id="Td2" runat="server">Left Members</td> <td id="Td4" runat="server">Right Members</td> <td id="Td5" runat="server">Total Members</td> <td id="Td6" runat="server">Total Pairs</td> </tr> <tr id="ItemPlaceholder" runat="server"> </tr> <tr id="Tr2" runat="server" class="TablePager"> <td id="Td3" runat="server" colspan="2"> <asp:DataPager ID="DataPager1" runat="server"> <Fields> <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="true" ShowNextPageButton="true" ShowPreviousPageButton="false" ButtonCssClass="ButtonCSS" /> <asp:NumericPagerField NumericButtonCssClass="NumericButtonCSS" CurrentPageLabelCssClass="CurrentPageLabelCSS" NextPreviousButtonCssClass="NextPreviousButtonCSS" /> <asp:NextPreviousPagerField ButtonType="Button" ShowLastPageButton="true" ShowNextPageButton="false" ButtonCssClass="ButtonCSS" /> </Fields> </asp:DataPager> </td> </tr> </table> </LayoutTemplate> <ItemTemplate> <tr class="TableData"> <td> <asp:Label ID="lblsponcorid" runat="server" Text='<%# Eval("sponcorid")%>'> </asp:Label> </td> <td> <asp:Label ID="lblleft" runat="server" Text='<%# Eval("leftcount")%>'> </asp:Label> </td> <td> <asp:Label ID="lblright" runat="server" Text='<%# Eval("rightcount")%>'> </asp:Label> </td> <td> <asp:Label ID="lbltotcount" runat="server" Text='<%# Eval("totcount")%>'> </asp:Label> </td> <td> <asp:Label ID="lblpair" runat="server" Text='<%# Eval("pair")%>'> </asp:Label> </td> <td> <asp:Button ID="btnpaysponcor" runat="server" Text="Pay Sponcor" /> </td> </tr> </ItemTemplate> </asp:ListView> <asp:Label ID="Label1" runat="server"></asp:Label> <asp:Label ID="Label2" runat="server"></asp:Label> <asp:Label ID="Label3" runat="server"></asp:Label> <asp:Label ID="Label4" runat="server"></asp:Label> <asp:Label ID="Label5" runat="server"></asp:Label> <asp:Label ID="Label6" runat="server"></asp:Label> </div> </asp:View> <asp:View ID="ViewSetPayout" runat="server"> <asp:Panel ID="Panel1" runat="server"> <table> <tr> <td> <asp:Label ID="lbltds" runat="server" Text="Tds"></asp:Label> </td> <td> : </td> <td> <asp:TextBox ID="txttds" runat="server"></asp:TextBox> </td> </tr> <tr> <td> <asp:Label ID="lblsercharge" runat="server" Text="Service Charges"></asp:Label> </td> <td> : </td> <td> <asp:TextBox ID="txtsercharge" runat="server"></asp:TextBox> </td> </tr> <tr> <td> <asp:Label ID="lbldeve_charges" runat="server" Text="Development Charges"></asp:Label> </td> <td> : </td> <td> <asp:TextBox ID="txtdeve_charges" runat="server"></asp:TextBox> </td> </tr> <tr> <td> <asp:Label ID="lbltrimming" runat="server" Text="Trimming"></asp:Label> </td> <td> : </td> <td> <asp:TextBox ID="txttrimming" runat="server"></asp:TextBox> </td> </tr> <tr> <td colspan="2"> <asp:Button ID="btnsubmit" runat="server" Text="INSERT" onclick="btnsubmit_Click" /> <asp:Button ID="Button2" runat="server" CausesValidation="False" OnClick="Button2_Click" Style="position: static; display: none" Text="Ok" /> <asp:Button ID="Button3" runat="server" CausesValidation="False" OnClick="Button3_Click" Style="position: static; display: none" Text="Ok" /> </td> <td> <asp:Button ID="btnupdate" runat="server" Text="UPDATE" onclick="btnupdate_Click" /> </td> </tr> </table> </asp:Panel> </asp:View> <asp:View ID="PaidPayout" runat="server"> <asp:GridView ID="gvpayout" runat="server" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" ForeColor="Black" GridLines="Vertical" onrowdatabound="gvpayout_RowDataBound"> <Columns> <asp:TemplateField HeaderText="Sponcor Id"> <ItemTemplate> <asp:Label ID="lblsponcorid1" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="User Name"> <ItemTemplate> <asp:Label ID="lblusername" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Left Count"> <ItemTemplate> <asp:Label ID="lblleftcount" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Right Count"> <ItemTemplate> <asp:Label ID="lblrightcount" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Total Count"> <ItemTemplate> <asp:Label ID="lbltotcount" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Total Pairs"> <ItemTemplate> <asp:Label ID="lblpairs" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Amount"> <ItemTemplate> <asp:TextBox ID="txtamount" runat="server"></asp:TextBox> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Tds"> <ItemTemplate> <asp:Label ID="lbltds" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Development Charges"> <ItemTemplate> <asp:Label ID="lbldcharges" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Trimming"> <ItemTemplate> <asp:Label ID="lblsercharges" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Total Deduct"> <ItemTemplate> <asp:Label ID="lbltotdeduct" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> <asp:TemplateField HeaderText="Total Amount"> <ItemTemplate> <asp:Label ID="lbltotamt" runat="server"></asp:Label> </ItemTemplate> </asp:TemplateField> </Columns> <FooterStyle BackColor="#CCCCCC" /> <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" /> <SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White" /> <HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" /> <AlternatingRowStyle BackColor="#CCCCCC" /> </asp:GridView> </asp:View> </asp:MultiView> </asp:Content>
-----Here My Code Behind
-----Here My Code Behind
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class ViewSponcorMembers : System.Web.UI.Page
{
Entity.TestCounter_Master TPObj = new Entity.TestCounter_Master();
Entity.SetPayout_Master SPMObj = new Entity.SetPayout_Master();
DateTime time = DateTime.Now.AddHours(10.30);
SqlCommand com = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter();
SqlConnection con = new SqlConnection("Data Source=SHILPA;Initial Catalog=TreeDB;Integrated Security=True");
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
try
{
MultiView1.ActiveViewIndex = 0;
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
}
protected void gvUserInfo_ItemCommand(object sender, ListViewCommandEventArgs e)
{
MultiView1.ActiveViewIndex = 1;
//View Sponcor List Data Grid
Label lblsponcor = (Label)e.Item.FindControl("lblsponcorid");
// Label lbluser = (Label)e.Item.FindControl("lblusername");
Label lblleftcount = (Label)e.Item.FindControl("lblleft");
Label lblrightcount = (Label)e.Item.FindControl("lblright");
Label lbltot = (Label)e.Item.FindControl("lbltotcount");
Label lblpairmatch = (Label)e.Item.FindControl("lblpair");
Label1.Text = lblsponcor.ToString();
//Label2.Text = lbluser.ToString();
Label3.Text = lblleftcount.ToString();
Label4.Text = lblrightcount.ToString();
Label5.Text = lbltot.ToString();
Label6.Text = lblpairmatch.ToString();
}
protected void lstpayout_ItemCommand(object sender, ListViewCommandEventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SHILPA;Initial Catalog=TreeDB;Integrated Security=True");
con.Open();
try
{
string a = Label1.Text;
string b = Label2.Text;
int c = Convert.ToInt32(Label3.Text.ToString());
int d = Convert.ToInt32(Label4.Text.ToString());
int e1 = Convert.ToInt32(Label5.Text.ToString());
int f = Convert.ToInt32(Label6.Text.ToString());
Label lblsponcor = (Label)e.Item.FindControl("lblsponcorid1");
Label lblleftcount = (Label)e.Item.FindControl("lblleft1");
Label lblrightcount = (Label)e.Item.FindControl("lblright1");
Label lbltot = (Label)e.Item.FindControl("lbltotcount1");
Label lblpairmatch = (Label)e.Item.FindControl("lblpair1");
double a1 = Convert.ToDouble(txtdeve_charges.Text);
double b1 = Convert.ToDouble(txtsercharge.Text);
double c1 = Convert.ToDouble(txttds.Text);
double d1 = Convert.ToDouble(txttrimming.Text);
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
protected void lnkViewSponcor_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 1;
}
protected void lnkSetPayout_Click(object sender, EventArgs e)
{
string str = "SELECT * FROM SetPayout_Master";
com = new SqlCommand(str, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtstr = new DataTable();
da.Fill(dtstr);
if (dtstr.Rows.Count > 0)
{
viewSetPayout();
}
MultiView1.ActiveViewIndex = 2;
}
protected void lnkPayout_Click(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 3;
}
protected void Button2_Click(object sender, EventArgs e)
{
clear();
}
protected void Button3_Click(object sender, EventArgs e)
{
clear();
}
protected void btnsubmit_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("Data Source=SHILPA;Initial Catalog=TreeDB;Integrated Security=True");
//SqlConnection con = new SqlConnection("Data Source=127.0.0.1;Integrated Security=FALSE;Initial Catalog=TreeDB;User Id=phonixsangli;Password=sangli@123");
con.Open();
try
{
string str = "SELECT * FROM SetPayout_Master";
com = new SqlCommand(str, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtstr = new DataTable();
da.Fill(dtstr);
if (dtstr.Rows.Count == 0)
{
SPMObj.tds = txttds.Text;
SPMObj.sercharge = txtsercharge.Text;
SPMObj.deve_charges = txtdeve_charges.Text;
SPMObj.trimming = txttrimming.Text;
SPMObj.createddate = time;
DataTable dtReg = DAL.SetPayout_Master.AddData(SPMObj);
String csname = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
if (!cs.IsStartupScriptRegistered(cstype, csname))
{
String cstext = "confirmProcess()";
cs.RegisterStartupScript(cstype, csname, cstext, true);
}
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public void viewSetPayout()
{
try
{
string query = "SELECT tds,sercharge,deve_charges,trimming FROM SetPayout_Master";
com = new SqlCommand(query, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtquery = new DataTable();
da.Fill(dtquery);
if (dtquery.Rows.Count > 0)
{
txttds.Text = dtquery.Rows[0]["tds"].ToString();
txtsercharge.Text =dtquery.Rows[0]["sercharge"].ToString();
txtdeve_charges.Text = dtquery.Rows[0]["deve_charges"].ToString();
txttrimming.Text = dtquery.Rows[0]["trimming"].ToString();
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
protected void btnupdate_Click(object sender, EventArgs e)
{
try
{
bool flag = false;
string str = "SELECT * FROM SetPayout_Master";
com = new SqlCommand(str, con);
com.CommandType = CommandType.Text;
da = new SqlDataAdapter(com);
DataTable dtstr = new DataTable();
da.Fill(dtstr);
if (dtstr.Rows.Count > 0)
{
SPMObj.tds = txttds.Text;
SPMObj.sercharge = txtsercharge.Text;
SPMObj.deve_charges = txtdeve_charges.Text;
SPMObj.trimming = txttrimming.Text;
SPMObj.createddate = time;
flag = DAL.SetPayout_Master.UpdateData(SPMObj);
String csname = "PopupScript";
Type cstype = this.GetType();
ClientScriptManager cs = Page.ClientScript;
if (!cs.IsStartupScriptRegistered(cstype, csname))
{
String cstext = "UpdateProcess()";
cs.RegisterStartupScript(cstype, csname, cstext, true);
}
}
}
catch (SqlException ex)
{
throw ex;
}
finally
{
con.Close();
}
}
public void clear()
{
txtdeve_charges.Text = "";
txtsercharge.Text = "";
txttds.Text = "";
txttrimming.Text = "";
}
protected void gvpayout_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Cells[1].Text = Label1.Text.ToString();//sponcorid
e.Row.Cells[2].Text = Label2.Text.ToString();//username
e.Row.Cells[3].Text = Label3.Text.ToString();//leftcount
e.Row.Cells[4].Text = Label4.Text.ToString();//rightcount
e.Row.Cells[5].Text = Label5.Text.ToString();//totcount
e.Row.Cells[6].Text = Label6.Text.ToString();//pair
TextBox amount = (TextBox)e.Row.FindControl("txtamount");//amount
e.Row.Cells[8].Text = txttds.Text.ToString();//tds
e.Row.Cells[9].Text = txtdeve_charges.Text.ToString();//development charges
e.Row.Cells[10].Text = txtsercharge.Text.ToString();//service charges
double totdeduct = Convert.ToDouble(txttds.Text) + Convert.ToDouble(txttrimming.Text) + Convert.ToDouble(txtsercharge.Text) + Convert.ToDouble(txtdeve_charges.Text);
double totamount = Convert.ToDouble(amount) - totdeduct;
e.Row.Cells[11].Text = Convert.ToDouble(totdeduct).ToString();
e.Row.Cells[12].Text = Convert.ToDouble(totamount).ToString();
}
}
protected void gvUserInfo_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
--I want records taken from multiview view(gvUserInfo) 1 and multiview view 2 and insert in --gridview which in multiview view 3(gvpayout) and it should viewed at time of view 3
--I want records taken from multiview view(gvUserInfo) 1 and multiview view 2 and insert in --gridview which in multiview view 3(gvpayout) and it should viewed at time of view 3
这篇关于查看GridView记录的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!