GridView中的链接按钮中的问题 [英] Problem in linkbutton in gridview
问题描述
gridview中的linkbutton中的问题
我想从gridview内的linkbutton检索表格,但是我对LE_YN列的外观感到不满意,并且在单元格中显示了标签l_no,我想使用linkbutton le_yn并单击它来查看表格anthor表letter_dept
主gridview表是viewyn
Problem in linkbutton in gridview
I want retrive anthor table from linkbutton inside gridview,But i am not satified with look LE_YN column linkbutton plus label l_no is showing in cell ,I want Use linkbutton le_yn and click it see anthor table letter_dept
Main gridview table is viewyn
CREATE TABLE [dbo].[viewyn]
[l_no] [varchar](50) ,
[nam_dep] [varchar](50) ,
[no_deo] [int] NULL,
[no_mon] [int] NULL,
[le_yn] [varchar](50) ,
[dd_yn] [varchar](50)
le_yn用于链接按钮
现在,anthor表
le_yn is used linkbuttons
Now anthor table
CREATE TABLE [dbo].[Letter_dept](
[Dep_nam] [varchar](50),
[l_no] [varchar](50),
[le_jap] [varchar](50),
[date] [varchar](50),
[amount_dd] [int] NULL,
[le_yn] [varchar](50)
)
ASP.NET语法(切换纯文本)
ASP.NET Syntax (Toggle Plain Text)
<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>
<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" AllowPaging="True" DataSourceID="SqlDataSource1"
onselectedindexchanged="GridView1_SelectedIndexChanged" >
<Columns>
<asp:BoundField DataField="l_no" HeaderText="l_no"
SortExpression="l_no" />
<asp:BoundField DataField="nam_dep" HeaderText="nam_dep"
SortExpression="nam_dep" />
<asp:BoundField DataField="no_deo" HeaderText="no_deo"
SortExpression="no_deo" />
<asp:BoundField DataField="no_mon" HeaderText="no_mon"
SortExpression="no_mon" />
<asp:TemplateField HeaderText="le_yn">
<ItemTemplate>
<asp:Label runat="server" ID="letterno" Text='<%# Eval("le_yn") %>' />
<asp:LinkButton runat="server" ID ="l_no" Text='<%# Eval("l_no") %>' OnClick="l_no_Click" />
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="dd_yn" HeaderText="dd_yn" SortExpression="dd_yn" />
</Columns>
</asp:GridView>
<asp:ModalPopupExtender ID="ModalPopupExtender1" runat="server"
TargetControlID="btnShowModalPopup"
PopupControlID="divPopUp"
BackgroundCssClass="popUpStyle"
PopupDragHandleControlID="panelDragHandle"
DropShadow="true"> </asp:ModalPopupExtender>
<asp:Button runat="server" ID="btnShowModalPopup" style="display:none"/>
<div class="popUpStyle" id="divPopUp" style="display:none;">
<asp:Panel runat="Server" ID="panelDragHandle" CssClass="drag">
</asp:Panel>
<asp:Label runat="server" ID="lblText" Text="letter no: "></asp:Label>
<asp:Label ID="lblCustValue" runat="server"></asp:Label>
<asp:GridView ID="GridView2" runat="server">
</asp:GridView>
<asp:Button ID="btnClose" runat="server" Text="Close" />
<br />
</div>
</ContentTemplate>
</asp:UpdatePanel>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:JAPITConnectionString %>"
SelectCommand="SELECT * FROM [viewyn]"></asp:SqlDataSource>
ASP.NET语法(切换纯文本)
ASP.NET Syntax (Toggle Plain Text)
protected void l_no_Click(object sender, EventArgs e)
{
// Fetch the customer id
LinkButton lb = sender as LinkButton;
string l_no = lb.Text;
lblCustValue.Text = l_no;
// Connection
string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["JAPITConnectionString"].ConnectionString;
string sql = "SELECT * FROM Letter_dept WHERE l_no= @l_no";
SqlConnection connection = new SqlConnection(constr);
connection.Open();
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@l_no", l_no);
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();
// Bind the reader to the GridView
// You can also use a lighter control
// like the Repeater to display data
GridView2.DataSource = dr;
GridView2.DataBind();
connection.Close();
// Show the modalpopupextender
ModalPopupExtender1.Show();
}
推荐答案
ConnectionStrings:JAPITConnectionString%>" span> SelectCommand =" 选择*来自[viewyn]" < /asp:SqlDataSource >
ConnectionStrings:JAPITConnectionString %>" SelectCommand="SELECT * FROM [viewyn]"></asp:SqlDataSource>
ASP.NET语法(切换纯文本)
ASP.NET Syntax (Toggle Plain Text)
protected void l_no_Click(object sender, EventArgs e)
{
// Fetch the customer id
LinkButton lb = sender as LinkButton;
string l_no = lb.Text;
lblCustValue.Text = l_no;
// Connection
string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["JAPITConnectionString"].ConnectionString;
string sql = "SELECT * FROM Letter_dept WHERE l_no= @l_no";
SqlConnection connection = new SqlConnection(constr);
connection.Open();
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@l_no", l_no);
cmd.CommandType = CommandType.Text;
SqlDataReader dr = cmd.ExecuteReader();
// Bind the reader to the GridView
// You can also use a lighter control
// like the Repeater to display data
GridView2.DataSource = dr;
GridView2.DataBind();
connection.Close();
// Show the modalpopupextender
ModalPopupExtender1.Show();
}
如果您对外观不满意,请使用CSS对其进行更改,或使用模板"列根据需要添加控件.
If you are not satisfied with the look then use CSS to change it or use a Template column to add controls as you desire.
这篇关于GridView中的链接按钮中的问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!