<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataKeyNames="id" DataSourceID="SqlDataSource1" BackColor="White"
BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" ReadOnly="True"
SortExpression="name" />
<asp:BoundField DataField="tel" HeaderText="tel" ReadOnly="True"
SortExpression="tel" />
<asp:TemplateField HeaderText="yw" SortExpression="yw">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server"
SelectedValue='<%# Bind("yw") %>'>
<asp:ListItem>aa</asp:ListItem>
<asp:ListItem>bb</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("yw") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="bianji" ShowEditButton="True" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4" />
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM [yw] WHERE [id] = @original_id AND (([name] = @original_name) OR ([name] IS NULL AND @original_name IS NULL)) AND (([tel] = @original_tel) OR ([tel] IS NULL AND @original_tel IS NULL)) AND (([yw] = @original_yw) OR ([yw] IS NULL AND @original_yw IS NULL))"
InsertCommand="INSERT INTO [yw] ([id], [name], [tel], [yw]) VALUES (@id, @name, @tel, @yw)"
OldValuesParameterFormatString="original_{000}"
SelectCommand="SELECT * FROM [yw] WHERE [yw]=@type order by id desc"
UpdateCommand="UPDATE yw SET yw = @yw WHERE (id = @original_id) AND (name = @original_name) AND (tel = @original_tel) AND (yw = @original_yw) OR (id = @original_id) AND (name IS NULL) AND (tel = @original_tel) AND (yw = @original_yw) AND (@original_name IS NULL) OR (id = @original_id) AND (name = @original_name) AND (tel IS NULL) AND (yw = @original_yw) AND (@original_tel IS NULL) OR (id = @original_id) AND (name IS NULL) AND (tel IS NULL) AND (yw = @original_yw) AND (@original_name IS NULL) AND (@original_tel IS NULL) OR (id = @original_id) AND (name = @original_name) AND (tel = @original_tel) AND (yw IS NULL) AND (@original_yw IS NULL) OR (id = @original_id) AND (name IS NULL) AND (tel = @original_tel) AND (yw IS NULL) AND (@original_name IS NULL) AND (@original_yw IS NULL) OR (id = @original_id) AND (name = @original_name) AND (tel IS NULL) AND (yw IS NULL) AND (@original_tel IS NULL) AND (@original_yw IS NULL) OR (id = @original_id) AND (name IS NULL) AND (tel IS NULL) AND (yw IS NULL) AND (@original_name IS NULL) AND (@original_tel IS NULL) AND (@original_yw IS NULL)">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="String" />
<asp:Parameter Name="original_name" Type="String" />
<asp:Parameter Name="original_tel" Type="String" />
<asp:Parameter Name="original_yw" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="String" />
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="tel" Type="String" />
<asp:Parameter Name="yw" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="tel" Type="String" />
<asp:Parameter Name="yw" Type="String" />
<asp:Parameter Name="original_id" Type="String" />
<asp:Parameter Name="original_name" Type="String" />
<asp:Parameter Name="original_tel" Type="String" />
<asp:Parameter Name="original_yw" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>想实现对yw不同条件的查询该如何做,我这是使用控件操作生成的前台代码。GridViewASP多数据查询
DataKeyNames="id" DataSourceID="SqlDataSource1" BackColor="White"
BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4">
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" />
<asp:BoundField DataField="name" HeaderText="name" ReadOnly="True"
SortExpression="name" />
<asp:BoundField DataField="tel" HeaderText="tel" ReadOnly="True"
SortExpression="tel" />
<asp:TemplateField HeaderText="yw" SortExpression="yw">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server"
SelectedValue='<%# Bind("yw") %>'>
<asp:ListItem>aa</asp:ListItem>
<asp:ListItem>bb</asp:ListItem>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("yw") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField HeaderText="bianji" ShowEditButton="True" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<RowStyle BackColor="White" ForeColor="#003399" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<SortedAscendingCellStyle BackColor="#EDF6F6" />
<SortedAscendingHeaderStyle BackColor="#0D4AC4" />
<SortedDescendingCellStyle BackColor="#D6DFDF" />
<SortedDescendingHeaderStyle BackColor="#002876" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
DeleteCommand="DELETE FROM [yw] WHERE [id] = @original_id AND (([name] = @original_name) OR ([name] IS NULL AND @original_name IS NULL)) AND (([tel] = @original_tel) OR ([tel] IS NULL AND @original_tel IS NULL)) AND (([yw] = @original_yw) OR ([yw] IS NULL AND @original_yw IS NULL))"
InsertCommand="INSERT INTO [yw] ([id], [name], [tel], [yw]) VALUES (@id, @name, @tel, @yw)"
OldValuesParameterFormatString="original_{000}"
SelectCommand="SELECT * FROM [yw] WHERE [yw]=@type order by id desc"
UpdateCommand="UPDATE yw SET yw = @yw WHERE (id = @original_id) AND (name = @original_name) AND (tel = @original_tel) AND (yw = @original_yw) OR (id = @original_id) AND (name IS NULL) AND (tel = @original_tel) AND (yw = @original_yw) AND (@original_name IS NULL) OR (id = @original_id) AND (name = @original_name) AND (tel IS NULL) AND (yw = @original_yw) AND (@original_tel IS NULL) OR (id = @original_id) AND (name IS NULL) AND (tel IS NULL) AND (yw = @original_yw) AND (@original_name IS NULL) AND (@original_tel IS NULL) OR (id = @original_id) AND (name = @original_name) AND (tel = @original_tel) AND (yw IS NULL) AND (@original_yw IS NULL) OR (id = @original_id) AND (name IS NULL) AND (tel = @original_tel) AND (yw IS NULL) AND (@original_name IS NULL) AND (@original_yw IS NULL) OR (id = @original_id) AND (name = @original_name) AND (tel IS NULL) AND (yw IS NULL) AND (@original_tel IS NULL) AND (@original_yw IS NULL) OR (id = @original_id) AND (name IS NULL) AND (tel IS NULL) AND (yw IS NULL) AND (@original_name IS NULL) AND (@original_tel IS NULL) AND (@original_yw IS NULL)">
<DeleteParameters>
<asp:Parameter Name="original_id" Type="String" />
<asp:Parameter Name="original_name" Type="String" />
<asp:Parameter Name="original_tel" Type="String" />
<asp:Parameter Name="original_yw" Type="String" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="id" Type="String" />
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="tel" Type="String" />
<asp:Parameter Name="yw" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="name" Type="String" />
<asp:Parameter Name="tel" Type="String" />
<asp:Parameter Name="yw" Type="String" />
<asp:Parameter Name="original_id" Type="String" />
<asp:Parameter Name="original_name" Type="String" />
<asp:Parameter Name="original_tel" Type="String" />
<asp:Parameter Name="original_yw" Type="String" />
</UpdateParameters>
</asp:SqlDataSource>想实现对yw不同条件的查询该如何做,我这是使用控件操作生成的前台代码。GridViewASP多数据查询
解决方案 »
- Input里加超链接实现访问本地地址
- 关于验证码的一点想法!大家来讨论下~
- 2003 VS 2005
- like 模糊查找时间/日期类型,sql语名格式问题。
- this.close()方法关闭的是什么东西
- 怎样得到虚拟目录的物理路径?(如:我的网站放在 d:\Dir1\MyWeb\ 下面) 我怎样得到这个路径(用这个吗:server.MapPath(??) ??)
- <%=copyright%>的问题
- LeapFTP软件上传问题
- 微软的Server2003和Oracle的客户端访问许可权限(CAL)是怎么算的,如25份是什么意思?
- 为什么用asp.net作的程序比asp做的同样功能的程序慢? 请asp.net专家解释
- dev ASPxNavBar无刷新如何实现
- 弱问一个网页url里面aspx变量的问题
多条件查询,就是判断条件,组合条件,然后根据sql查询数据库,将获得的数据绑定即可。