hello every1,i have a aspx page and i want coding for button1(name-Show Records) on the behalf of selecting values by dropdownlist1 and dropdownlist4.... i am uploading my aspx page with this ....thnx in advance.
----------------------------------
---------------------------------------
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="show.aspx.cs" Inherits="fixed_deposit.show" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>Untitled Page</title>
<style type="text/css">
.style1
{
width: 72%;
background-color: #66CCFF;
}
.style2
{
width: 157px;
}
.style3
{
width: 459px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>
<td align ="center" colspan="4"><span style="font-size: 25px;"><strong>Show Record</strong></span></td></div>
<table class="style1">
<tr>
<td class="style2">
Block Name</td>
<td class="style3">
<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="SqlDataSource1" DataTextField="block_name"
DataValueField="block_code" AutoPostBack="true">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:fdConnectionString3 %>"
SelectCommand="SELECT [block_code], [block_name] FROM [block]">
</asp:SqlDataSource>
<br />
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
Department Name</td>
<td class="style3">
<asp:DropDownList ID="DropDownList2" runat="server"
DataSourceID="SqlDataSource2" DataTextField="dept_name"
DataValueField="dept_address" ondatabound="mylist1">
</asp:DropDownList>
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server"
ConnectionString="<%$ ConnectionStrings:fdConnectionString4 %>"
SelectCommand="SELECT [dept_name], [dept_address] FROM [dept]">
</asp:SqlDataSource>
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
GP/Owner Name</td>
<td class="style3">
<asp:TextBox ID="TextBox1" runat="server" Width="177px"></asp:TextBox>
<br />
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
Village Name</td>
<td class="style3">
<asp:DropDownList ID="DropDownList4" runat="server"
DataSourceID="SqlDataSource4" DataTextField="vill_name"
DataValueField="vill_code" />
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource4" runat="server"
ConnectionString="<%$ ConnectionStrings:fdConnectionString6 %>"
SelectCommand="SELECT vill_name, vill_code FROM village WHERE (block_code = @block_code) ORDER BY vill_name">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="block_code"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<br />
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
Bank Name</td>
<td class="style3">
<asp:DropDownList ID="DropDownList5" runat="server"
DataSourceID="SqlDataSource5" DataTextField="BankName" DataValueField="SrNo">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource5" runat="server"
ConnectionString="<%$ ConnectionStrings:fdConnectionString7 %>"
SelectCommand="SELECT [BankName], [SrNo] FROM [bank]"></asp:SqlDataSource>
<br />
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
Branch Name</td>
<td class="style3">
<asp:DropDownList ID="DropDownList6" runat="server"
DataSourceID="SqlDataSource6" DataTextField="Branch" DataValueField="SrNo">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource6" runat="server"
ConnectionString="<%$ ConnectionStrings:fdConnectionString8 %>"
SelectCommand="SELECT [Branch], [SrNo] FROM [Branch]"></asp:SqlDataSource>
<br />
</td>
<td>
</td>
</tr>
<tr>
<td class="style2">
</td>
<td class="style3">
<asp:Button ID="Button1" runat="server" Text="Show Records" Width="186px"
onclick="Button1_Click" />
</td>
<td>
</td>
</tr>
</table>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" BackColor="White" BorderColor="#336666"
BorderStyle="Double" BorderWidth="3px" CellPadding="4"
DataSourceID="SqlDataSource7" GridLines="Horizontal">
<FooterStyle BackColor="White" ForeColor="#333333" />
<RowStyle BackColor="White" ForeColor="#333333" />
<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
</Columns>
<PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource7" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:fdConnectionString16 %>"
DeleteCommand="DELETE FROM [main] WHERE [sr_no] = @original_sr_no AND [block_name] = @original_block_name AND [dept_name] = @original_dept_name AND [gp_ownername] = @original_gp_ownername AND [vill_name] = @original_vill_name AND [fd_amount] = @original_fd_amount AND [fd_startdate] = @original_fd_startdate AND [fd_period] = @original_fd_period AND [roi] = @original_roi AND [bank_name] = @original_bank_name AND [branch] = @original_branch AND [remarks] = @original_remarks"
InsertCommand="INSERT INTO [main] ([block_name], [dept_name], [gp_ownername], [vill_name], [fd_amount], [fd_startdate], [fd_period], [roi], [bank_name], [branch], [remarks]) VALUES (@block_name, @dept_name, @gp_ownername, @vill_name, @fd_amount, @fd_startdate, @fd_period, @roi, @bank_name, @branch, @remarks)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT * FROM [main]"
UpdateCommand="UPDATE [main] SET [block_name] = @block_name, [dept_name] = @dept_name, [gp_ownername] = @gp_ownername, [vill_name] = @vill_name, [fd_amount] = @fd_amount, [fd_startdate] = @fd_startdate, [fd_period] = @fd_period, [roi] = @roi, [bank_name] = @bank_name, [branch] = @branch, [remarks] = @remarks WHERE [sr_no] = @original_sr_no AND [block_name] = @original_block_name AND [dept_name] = @original_dept_name AND [gp_ownername] = @original_gp_ownername AND [vill_name] = @original_vill_name AND [fd_amount] = @original_fd_amount AND [fd_startdate] = @original_fd_startdate AND [fd_period] = @original_fd_period AND [roi] = @original_roi AND [bank_name] = @original_bank_name AND [branch] = @original_branch AND [remarks] = @original_remarks">
<DeleteParameters>
<asp:Parameter Name="original_sr_no" Type="Int32" />
<asp:Parameter Name="original_block_name" Type="String" />
<asp:Parameter Name="original_dept_name" Type="String" />
<asp:Parameter Name="original_gp_ownername" Type="String" />
<asp:Parameter Name="original_vill_name" Type="String" />
<asp:Parameter Name="original_fd_amount" Type="Int64" />
<asp:Parameter Name="original_fd_startdate" Type="DateTime" />
<asp:Parameter Name="original_fd_period" Type="String" />
<asp:Parameter Name="original_roi" Type="String" />
<asp:Parameter Name="original_bank_name" Type="String" />
<asp:Parameter Name="original_branch" Type="String" />
<asp:Parameter Name="original_remarks" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="block_name" Type="String" />
<asp:Parameter Name="dept_name" Type="String" />
<asp:Parameter Name="gp_ownername" Type="String" />
<asp:Parameter Name="vill_name" Type="String" />
<asp:Parameter Name="fd_amount" Type="Int64" />
<asp:Parameter Name="fd_startdate" Type="DateTime" />
<asp:Parameter Name="fd_period" Type="String" />
<asp:Parameter Name="roi" Type="String" />
<asp:Parameter Name="bank_name" Type="String" />
<asp:Parameter Name="branch" Type="String" />
<asp:Parameter Name="remarks" Type="String" />
<asp:Parameter Name="original_sr_no" Type="Int32" />
<asp:Parameter Name="original_block_name" Type="String" />
<asp:Parameter Name="original_dept_name" Type="String" />
<asp:Parameter Name="original_gp_ownername" Type="String" />
<asp:Parameter Name="original_vill_name" Type="String" />
<asp:Parameter Name="original_fd_amount" Type="Int64" />
<asp:Parameter Name="original_fd_startdate" Type="DateTime" />
<asp:Parameter Name="original_fd_period" Type="String" />
<asp:Parameter Name="original_roi" Type="String" />
<asp:Parameter Name="original_bank_name" Type="String" />
<asp:Parameter Name="original_branch" Type="String" />
<asp:Parameter Name="original_remarks" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="block_name" Type="String" />
<asp:Parameter Name="dept_name" Type="String" />
<asp:Parameter Name="gp_ownername" Type="String" />
<asp:Parameter Name="vill_name" Type="String" />
<asp:Parameter Name="fd_amount" Type="Int64" />
<asp:Parameter Name="fd_startdate" Type="DateTime" />
<asp:Parameter Name="fd_period" Type="String" />
<asp:Parameter Name="roi" Type="String" />
<asp:Parameter Name="bank_name" Type="String" />
<asp:Parameter Name="branch" Type="String" />
<asp:Parameter Name="remarks" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
<br />
<asp:Button ID="Button2" runat="server"
Text="Main Page" onclick="Button2_Click" />
<asp:Button ID="Button3" runat="server"
Text="Close" OnClick="Button3_Click" />
</form>
</body>
</html>