在SqlDataSource使用的SQL中设置参数 [英] Setting parameters in the SQL used by a SqlDataSource

问题描述

 <asp:DataGrid ID="dgv" runat="server"></asp:DataGrid>

        <asp:SqlDataSource id="roreleaseorder"  runat="server" ConnectionString =
"Data Source=server2005;Initial Catalog=databasename;User Id=userid;Password=password;Integrated Security=False"  SelectCommand ="SELECT NO AS REFNO,DATE,RONO,RODT,CLIENT,FDATE,TDATE,AMOUNT FROM RO07_08  where condintion? ORDER BY DATE,CLIENT"></asp:SqlDataSource> 
        
        <asp:DataGrid id="dg" GridLines= "Both" runat ="server"   AutoGenerateColumns ="false" DataSourceID  ="roreleaseorder" >
        <HeaderStyle Font-Bold="true" ForeColor="#E7E7FF" BackColor="#4A3C8C" Font-Names="Verdana, Arial, Helvetica" font-Size="12px"></HeaderStyle>	
        <Columns>                  
          <asp:HyperLinkColumn DataNavigateUrlField ="refno" HeaderText="Refno" DataNavigateUrlFormatString="./scheduling.aspx?refno={0}" Target="_self"></asp:HyperLinkColumn> 
          <asp:BoundColumn DataField="date" HeaderText="Date" ReadOnly ="true" ></asp:BoundColumn>
          <asp:BoundColumn DataField="rono" HeaderText="rono" ReadOnly ="true" ></asp:BoundColumn>
          <asp:BoundColumn DataField="rodt" HeaderText="rodate" ReadOnly ="true" ></asp:BoundColumn>
          <asp:BoundColumn DataField="client" HeaderText="Agency/Client" ReadOnly ="true" ></asp:BoundColumn>
          <asp:BoundColumn DataField="fdate" HeaderText="From Date" ReadOnly ="true" ></asp:BoundColumn>
          <asp:BoundColumn DataField="tdate" HeaderText="To Date" ReadOnly ="true" ></asp:BoundColumn>
          <asp:BoundColumn DataField="amount" HeaderText="Amount" ReadOnly ="true" ></asp:BoundColumn>                   
        </Columns>     
                </asp:DataGrid> 

SelectCommand ="SELECT NO AS REFNO,DATE,RONO,RODT,CLIENT,FDATE,TDATE,AMOUNT FROM RO07_08  where condintion? ORDER BY DATE,CLIENT"
How to pass parameter in runtime?

如何在运行时传递参数?</

How to pass parameter in runtime?</

推荐答案

我删除了重复的问题.一次问一个问题就足够了.

SqlDataSource的内容令人毛骨悚然.它不适合用于商业应用.相反，您应该编写一个适当的数据层，以支持接受参数来搜索和过滤数据.

I deleted your duplicate question. Once is enough to ask something.

The SqlDataSource stuff is hideous. It''s not fit for use in commercial applications. Instead, you should write a proper data layer, which will support accepting paramaters to search and filter the data.

这篇关于在SqlDataSource使用的SQL中设置参数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！