首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 网站开发 > asp.net >

【一个巨简单的有关问题】个很简单的有关问题:怎么从后台传参给SelectParameters?

2013-03-19 
【求助一个巨简单的问题】个很简单的问题:如何从后台传参给SelectParameters???如下代码: asp:SqlDataSourc

【求助一个巨简单的问题】个很简单的问题:如何从后台传参给SelectParameters???
如下代码:


 <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                                                                                        ConnectionString="<%$ ConnectionStrings:LH700ConnectionString %>" 
                                                                                        SelectCommand="SELECT [DocEntry], [LineNum], [ItemCode], [Dscription],[Quantity], [U_U001], [U_DW], [U_ZMJ], [U_U012],[Price], 
                                                                                                               [PriceBefDi],[U_ZK], [LineTotal],[INMPrice],[ShipDate],[U_U018], [U_NDFL], [U_JDFL], [U_YDFL], [U_ZXFL], [U_GGFL],
                                                                                                               [U_ZLFL] FROM [PRE_RDR1] WHERE [DocEntry] = @DocEntry" >
                                                                                      <SelectParameters>
                                                                                        <asp:ControlParameter ControlID="NewGridView" Name="DocEntry" PropertyName="SelectedValue" />


                                                                                      </SelectParameters>

                                                                                    </asp:SqlDataSource>




在后台:


private void defineDataSet()
        {
            string connStr = ConfigurationManager.ConnectionStrings["LHT400ConnectionString"].ToString();
            SqlConnection conn = new SqlConnection(connStr);
            dsOrderLine = new DataSet();
            dsOrder = new DataSet();
            int docentry = Convert.ToInt16(Session["DocEntry"]);


            conn.Open();


如何将后台的textBox.Text传给前台的DocEntry????
[解决办法]

 this.SqlDataSource1.SelectParameters["pName"] = value;
            this.SqlDataSource1.DataBind();

热点排行