Aspx page
<asp:Panel ID="pnlsearch" Visible="false" runat="server" Width="100%">
<table width="100%" class="col-lg-12 table-responsive">
<tr>
<td colspan="3"><h3 style="color: #1876AF">Search Service Providers</h3></td>
</tr>
<tr>
<td>
<asp:Label ID="lblsproid" runat="server" Text="Service Pro. Id:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtsproid" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
<td>
<asp:Label ID="lblsproname" runat="server" Text="Service Pro. Name:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtsproname" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
<td>
<asp:Label ID="lblperson" runat="server" Text="Contact Person:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtperson" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
</tr>
<tr>
<td>
<asp:Label ID="lblcitysearch" runat="server" Text="City:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtcitysearch" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
<td>
<asp:Label ID="lblstatesearch" runat="server" Text="State:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtstatesearch" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
<td>
<asp:Label ID="lblmobsearch" runat="server" Text="Mobile No:"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtmobsearch" runat="server" AutoPostBack="True"></asp:TextBox>
</td>
</tr>
<tr>
<td colspan="3">
</td>
</tr>
<tr>
<td> </td><td> </td><td>
<asp:Label ID="lblresult" runat="server" Visible="false" Text=""></asp:Label></td>
</tr>
<tr><td> </td></tr>
</table>
<asp:Button ID="btnsearch1" CssClass="btn btn-primary" runat="server"
Text="Search" onclick="btnsearch1_Click" />
<asp:Panel ID="pnlgrid" runat="server" ScrollBars="Auto" Width="100%">
<asp:GridView ID="GridView1" CssClass="table table-bordered table-responsive"
runat="server" AllowPaging="True"
AutoGenerateColumns="False"
OnPageIndexChanging="GridView1_PageIndexChanging"
Height="100px" DataKeyNames="S_Provider_Id,S_Provider_Name"
PageSize="5" onrowcancelingedit="GridView1_RowCancelingEdit"
onrowdeleting="GridView1_RowDeleting" onrowediting="GridView1_RowEditing"
onrowupdating="GridView1_RowUpdating"
onrowdatabound="GridView1_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="View">
<ItemTemplate>
<asp:ImageButton ID="ImageButton1" CommandName="View" runat="server"
ImageUrl="~/images/view.png" ToolTip="View" Height="20px" Width="20px"
PostBackUrl='<%# "SPro_Result.aspx?id="+Eval("S_Provider_Id") %>'
CausesValidation="False" />
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit">
<ItemTemplate>
<asp:ImageButton ID="imgbtnEdit" CommandName="Edit" runat="server" ImageUrl="~/images/edit.png"
ToolTip="Edit" Height="20px" Width="20px" CausesValidation="False"/>
</ItemTemplate>
<EditItemTemplate>
<asp:ImageButton ID="imgbtnUpdate" CommandName="Update" CausesValidation="False" runat="server" ImageUrl="~/images/edit.png" ToolTip="Update" Height="20px" Width="20px" />
<asp:ImageButton ID="imgbtnCancel" runat="server" CausesValidation="False" CommandName="Cancel" ImageUrl="~/images/Button Cancel.png" ToolTip="Cancel" Height="20px" Width="20px" />
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:ImageButton ID="imgbtnDelete" CommandName="Delete" Text="Edit" runat="server"
ImageUrl="~/images/del.png" OnClientClick="return confirm('Are you sure you want to delete this Row?')"
ToolTip="Delete" Height="20px" Width="20px" CausesValidation="False"
/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="S.Pro Id">
<EditItemTemplate>
<asp:TextBox ID="txtid" ReadOnly="true" runat="server" Text='<%#Eval("S_Provider_Id") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfid" runat="server" ControlToValidate="txtid" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblid" runat="server" Text='<%#Eval("S_Provider_Id") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="S.Pro Name">
<EditItemTemplate>
<asp:TextBox ID="txtsproname" runat="server" Text='<%#Eval("S_Provider_Name") %>'></asp:TextBox>
<asp:RequiredFieldValidator ID="rfsproname" runat="server" ControlToValidate="txtsproname" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblsproname" runat="server" Text='<%#Eval("S_Provider_Name") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Contact Person">
<EditItemTemplate>
<asp:TextBox ID="txtperson" runat="server" Text='<%#Eval("Contact_Person") %>'/>
<asp:RequiredFieldValidator ID="rfperson" runat="server" ControlToValidate="txtperson" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblperson" runat="server" Text='<%#Eval("Contact_Person") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<EditItemTemplate>
<asp:TextBox ID="txtadd" runat="server" Text='<%#Eval("Address") %>'/>
<asp:RequiredFieldValidator ID="rfadd" runat="server" ControlToValidate="txtadd" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lbladd" runat="server" Text='<%#Eval("Address") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="City">
<EditItemTemplate>
<asp:TextBox ID="txtcity" runat="server" Text='<%#Eval("City") %>'/>
<asp:RequiredFieldValidator ID="rfcity" runat="server" ControlToValidate="txtcity" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblcity" runat="server" Text='<%#Eval("City") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Pincode">
<EditItemTemplate>
<asp:TextBox ID="txtpin" runat="server" Text='<%#Eval("Pincode") %>'/>
<asp:RequiredFieldValidator ID="rfpin" runat="server" ControlToValidate="txtpin" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblpin" runat="server" Text='<%#Eval("Pincode") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="State">
<EditItemTemplate>
<asp:TextBox ID="txtstate" runat="server" Text='<%#Eval("State") %>'/>
<asp:RequiredFieldValidator ID="rfstate" runat="server" ControlToValidate="txtstate" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblstate" runat="server" Text='<%#Eval("State") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Office Phone">
<EditItemTemplate>
<asp:TextBox ID="txtph" runat="server" Text='<%#Eval("Office_Phone") %>'/>
<asp:RequiredFieldValidator ID="rfph" runat="server" ControlToValidate="txtph" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblph" runat="server" Text='<%#Eval("Office_Phone") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Mobile No">
<EditItemTemplate>
<asp:TextBox ID="txtmob" runat="server" Text='<%#Eval("Mobile_No") %>'/>
<asp:RequiredFieldValidator ID="rfmob" runat="server" ControlToValidate="txtmob" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblmob" runat="server" Text='<%#Eval("Mobile_No") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Email">
<EditItemTemplate>
<asp:TextBox ID="txtemail" runat="server" Text='<%#Eval("E_Mail") %>'/>
<asp:RequiredFieldValidator ID="rfemail" runat="server" ControlToValidate="txtemail" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblemail" runat="server" Text='<%#Eval("E_Mail") %>'/>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Website">
<EditItemTemplate>
<asp:TextBox ID="txtweb" runat="server" Text='<%#Eval("Website") %>'/>
<asp:RequiredFieldValidator ID="rfweb" runat="server" ControlToValidate="txtweb" Text="*" ValidationGroup="validaiton"/>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="lblweb" runat="server" Text='<%#Eval("Website") %>'/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings FirstPageText="First" LastPageText="Last" PageButtonCount="5" />
<PagerStyle CssClass="pagination" />
<HeaderStyle ForeColor="#1876AF" />
<SelectedRowStyle BackColor="#CCCCCC" />
<RowStyle VerticalAlign="Middle" />
</asp:GridView>
</asp:Panel>
</asp:Panel>
c# page code
protected void clearsearch()
{
txtsproid.Text = "";
txtsproname.Text = "";
txtcitysearch.Text = "";
txtmobsearch.Text = "";
txtstatesearch.Text = "";
txtperson.Text = "";
}
protected void btnsearch1_Click(object sender, EventArgs e)
{
conn.Open();
qry = "Select * from Service_Provider where S_Provider_Id Like @sproid and S_Provider_Name Like @sproname and Contact_Person Like @person and City Like @city and State Like @state and Mobile_No Like @mob ";
SqlCommand cmd = new SqlCommand(qry, conn);
cmd.Parameters.AddWithValue("@sproid", "%" + txtsproid.Text + "%");
cmd.Parameters.AddWithValue("@sproname", "%" + txtsproname.Text + "%");
cmd.Parameters.AddWithValue("@person", "%" + txtperson.Text + "%");
cmd.Parameters.AddWithValue("@state", "%" + txtstatesearch.Text + "%");
cmd.Parameters.AddWithValue("@city", "%" + txtcitysearch.Text + "%");
cmd.Parameters.AddWithValue("@mob", "%" + txtmobsearch.Text + "%");
SqlDataReader dr = cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close();
clearsearch();
}
this is my code for searching data no error is coming but when i click on button search it is not displaying data that i want to search
this code is working for one page but not working for another page or in this page
plz help me....
