<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?
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)