cmd.Parameters.AddWithValue("@ l_no"，l_no)中的问题没有得到l_no [英] Problem in cmd.Parameters.AddWithValue("@l_no", l_no) Not getting l_no

问题描述

< pre lang ="xml"> I表viewyn和dept_letter.主ket l_no

]& lt; asp:TemplateField HeaderText =& quot; l_no& quot;& gt;
& lt; ItemTemplate& gt;
& lt; asp:LinkBut​​ton runat =& quot;服务器& quot; ID =&"l_no&".文字=&#39;& lt;％#Eval(&"l_no& quot;)％&#39; OnClick =& quot; l_no_Click& quot; /& gt;
& lt;/ItemTemplate& gt;
& lt;/asp:TemplateField& gt;

受保护的void l_no_Click(对象发送者，EventArgs e)
{
//获取客户ID
LinkBut​​ton lb =发送者为LinkBut​​ton;
字符串custID = lb.Text;
lblCustValue.Text = custID;
//连接
字符串constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings [&"JAPITConnectionString&"].ConnectionString;
字符串sql =& quot; SELECT * FROM Letter_dept WHERE l_no = @ l_no& quot ;;
SqlConnection连接=新的SqlConnection(constr);
connection.Open();
SqlCommand cmd =新的SqlCommand(sql，连接);
cmd.Parameters.AddWithValue(&"@ l_no&"，l_no);
cmd.CommandType = CommandType.Text;

SqlDataReader dr = cmd.ExecuteReader();
//将阅读器绑定到GridView
//您也可以使用较轻的控件
//像中继器一样显示数据
GridView2.DataSource = dr;
GridView2.DataBind();
connection.Close();
//显示modalpopupextender
ModalPopupExtender1.Show();

}


错误即将到来错误1名称&#39; l_no&#39;当前上下文中不存在</pre>

<pre lang="xml">I table viewyn and dept_letter. primary ket l_no

]&lt;asp:TemplateField HeaderText=&quot;l_no&quot;&gt;
&lt;ItemTemplate&gt;
&lt;asp:LinkButton runat=&quot;server&quot; ID =&quot;l_no&quot; Text=&#39;&lt;%# Eval(&quot;l_no&quot;) %&gt;&#39; OnClick=&quot;l_no_Click&quot; /&gt;
&lt;/ItemTemplate&gt;
&lt;/asp:TemplateField&gt;

protected void l_no_Click(object sender, EventArgs e)
{
// Fetch the customer id
LinkButton lb = sender as LinkButton;
string custID = lb.Text;
lblCustValue.Text = custID;
// Connection
string constr = System.Web.Configuration.WebConfigurationManager.ConnectionStrings[&quot;JAPITConnectionString&quot;].ConnectionString;
string sql = &quot;SELECT * FROM Letter_dept WHERE l_no= @l_no&quot;;
SqlConnection connection = new SqlConnection(constr);
connection.Open();
SqlCommand cmd = new SqlCommand(sql, connection);
cmd.Parameters.AddWithValue(&quot;@l_no&quot;, 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();

}


Error is coming Error 1 The name &#39;l_no&#39; does not exist in the current context</pre>

推荐答案

cmd.Parameters.AddWithValue("@ l_no"，l_no)


您正在将值传递为l_no，但这是可变的，或者您没有提到那件事.因此定义了那个东西

cmd.Parameters.AddWithValue("@l_no", l_no)


you are passing value as l_no but that is variable or any thing you are not mentioned that.so defined that thing

我对此知之甚少，我想要l_no请帮助我.感谢帮助

< asp:Content ID ="Content1" ContentPlaceHolderID ="ContentPlaceHolder1" Runat ="Server">

< asp:ScriptManager ID ="ScriptManager1" runat ="server">
</asp:ScriptManager>


< asp:UpdatePanel ID ="UpdatePanel1" runat ="server">
< ContentTemplate>

< asp:GridView ID ="GridView1" runat ="server"
AutoGenerateColumns ="False" AllowPaging ="True" DataSourceID ="SqlDataSource1"
onselectedindexchanged ="GridView1_SelectedIndexChanged">
<专栏>

< asp:TemplateField HeaderText ="l_no">
< ItemTemplate>
< asp:LinkBut​​ton runat ="server" ID ="l_no" Text =''<％#Eval("l_no")％>''OnClick ="l_no_Click"/>
</ItemTemplate>
</asp:TemplateField>

< 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:BoundField DataField ="le_yn" HeaderText ="le_yn"
SortExpression ="le_yn"/>





< asp:BoundField DataField ="dd_yn" HeaderText ="dd_yn" SortExpression ="dd_yn"/>
</列>
</asp:GridView>
< asp:ModalPopupExtender ID ="ModalPopupExtender1" runat =服务器"
TargetControlID ="btnShowModalPopup"
PopupControlID ="divPopUp"
BackgroundCssClass ="popUpStyle"
PopupDragHandleControlID ="panelDragHandle"
DropShadow ="true"> </asp:ModalPopupExtender>
< asp:Button runat =服务器" 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 =服务器" ID ="lblText" Text ="CustomerID:"></asp:Label>
< asp:标签ID ="lblCustValue" runat =服务器"></asp:标签>
< asp:GridView ID ="GridView2" runat ="server">
</asp:GridView>
< asp:按钮ID ="btnClose" runat =服务器" Text ="Close"/>
< br/>
</div>

</ContentTemplate>
</asp:UpdatePanel>
< asp:SqlDataSource ID ="SqlDataSource1" runat =服务器"
ConnectionString =<％

I have less knowledge this i want l_no please help me .thank for help

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">

<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>


<asp:UpdatePanel ID="UpdatePanel1" runat="server">
<ContentTemplate>

<asp:GridView ID="GridView1" runat="server"
AutoGenerateColumns="False" AllowPaging="True" DataSourceID="SqlDataSource1"
onselectedindexchanged="GridView1_SelectedIndexChanged" >
<Columns>

<asp:TemplateField HeaderText="l_no">
<ItemTemplate>
<asp:LinkButton runat="server" ID ="l_no" Text=''<%# Eval("l_no") %>'' OnClick="l_no_Click" />
</ItemTemplate>
</asp:TemplateField>

<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:BoundField DataField="le_yn" HeaderText="le_yn"
SortExpression="le_yn" />





<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">
Hold here to Drag this Box
</asp:Panel>
<asp:Label runat="server" ID="lblText" Text="CustomerID: "></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>

ConnectionStrings:JAPITConnectionString %>"
SelectCommand="SELECT * FROM [viewyn]"></asp:SqlDataSource>

这篇关于cmd.Parameters.AddWithValue("@ l_no"，l_no)中的问题没有得到l_no的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！