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" %>





  Untitled Page
 


 

 

 
  Show Record

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

  Block Name

    DataSourceID="SqlDataSource1" DataTextField="block_name"
  DataValueField="block_code" AutoPostBack="true">
 

 
    ConnectionString="<%$ ConnectionStrings:fdConnectionString3 %>"
  SelectCommand="SELECT [block_code], [block_name] FROM [block]">
 
 
 

 

   

  Department Name

    DataSourceID="SqlDataSource2" DataTextField="dept_name"
  DataValueField="dept_address" ondatabound="mylist1">
 

 

    ConnectionString="<%$ ConnectionStrings:fdConnectionString4 %>"
  SelectCommand="SELECT [dept_name], [dept_address] FROM [dept]">
 

 

   

  GP/Owner Name

 
 

 

   

  Village Name

    DataSourceID="SqlDataSource4" DataTextField="vill_name"
  DataValueField="vill_code" />
 

 
    ConnectionString="<%$ ConnectionStrings:fdConnectionString6 %>"
  SelectCommand="SELECT vill_name, vill_code FROM village WHERE (block_code = @block_code) ORDER BY vill_name">
 
    PropertyName="SelectedValue" Type="String" />
 

 

 

 

   

  Bank Name

    DataSourceID="SqlDataSource5" DataTextField="BankName" DataValueField="SrNo">
 

    ConnectionString="<%$ ConnectionStrings:fdConnectionString7 %>"
  SelectCommand="SELECT [BankName], [SrNo] FROM [bank]">

 

 

   

  Branch Name

    DataSourceID="SqlDataSource6" DataTextField="Branch" DataValueField="SrNo">
 

    ConnectionString="<%$ ConnectionStrings:fdConnectionString8 %>"
  SelectCommand="SELECT [Branch], [SrNo] FROM [Branch]">

 

 

   

   

    onclick="Button1_Click" />
 

         

    AllowSorting="True" BackColor="White" BorderColor="#336666"
  BorderStyle="Double" BorderWidth="3px" CellPadding="4"
  DataSourceID="SqlDataSource7" GridLines="Horizontal">
 
 
 
 
 

 
 
 
 

    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">
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

 
 
 
 
 
 
 
 
 
 
 
 
 

 

 

         Text="Main Page" onclick="Button2_Click" />
         Text="Close" OnClick="Button3_Click" />