Abhimanyu Singh

Search the grid row data....

Feb 18 2013 3:03 AM

Hello budy,
Gud noon to every one!!

Actually i have generated/bind a Grid (insert update delete) through Data base property/sqldatasource1. and its working well now

But i want to put the some code in c# so that i can search any row data by putting their columnname in text boxes.

For this i have putted the following code insde .CS Page
but its not working please help me.

.CS code for searching :
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select h_id as 'Hoarding ID', Address,Size as 'Hoarding Size', State, District, Cost as 'Hoarding Cost', Pincode,From_date as 'Available From', To_date as 'Available To', hoarding_type as 'Hoarding Type', Lightboxes_type as 'Light Boxes', hoarding_image as 'Hoarding Image' from providers_post where h_id = '"+ TextBox1.Text+"' ",con);
DataSet ds = new DataSet();
da.Fill(ds);
DataTable dt = new DataTable();
dt =ds.Tables[0];
if (dt.Rows.Count > 0)
{
//GridView1.DataSource = null;
//GridView1.DataSource = dt;
////GridView1.DataBind();

GridView1.DataSourceID = "SqlDataSource1";
GridView1.DataBind();

//GridView1.DataSourceID = "SqlDataSource1";
////GridView1.DataBind();
}
else
{
//Response.Write("<script>alert('No data Available')</script>");
Page.ClientScript.RegisterStartupScript(this.GetType(), "test", "alert('No Data Available.');", true);
}
con.Close();

}

And SqlDataSource1 code from designing page

<asp:GridView ID="GridView1" runat="server" AllowPaging="True" BackColor="#CCCCCC"
BorderColor="#999999" BorderStyle="Solid" BorderWidth="3px" CellPadding="4"
CellSpacing="2" ForeColor="Black" Width="1100" AllowSorting="True"
DataSourceID="SqlDataSource1" ondatabound="GridView1_DataBound" >
<FooterStyle BackColor="#CCCCCC" Wrap="False" />
<RowStyle BackColor="White" />

<Columns>
<asp:CommandField ShowDeleteButton="True" ShowEditButton="True" ShowSelectButton="True" />

<asp:TemplateField HeaderText="View Image">
<ItemTemplate>
<div id="gallery" > 
<ul>
<li>
<a href="<%# DataBinder.Eval (Container.DataItem, "hoarding_image") %>" >
<span style="text-align:center; margin-top:10px; float:left;">View Image</span>
</a>
</li>
</ul>
<%--<a href="<%# DataBinder.Eval(Container.DataItem, "hoarding_image") %>">IMAGE</a>--%> 
</ItemTemplate>
</asp:TemplateField>
</Columns>

<PagerStyle BackColor="#CCCCCC" ForeColor="Black" Wrap="True" />
<SelectedRowStyle BackColor="#000099" Font-Bold="True" ForeColor="White"
Wrap="True" />
<HeaderStyle BackColor="Black" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle HorizontalAlign="Left" Wrap="False" />
</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConflictDetection="CompareAllValues"
ConnectionString="<%$ ConnectionStrings:HoardingIndiaConnectionString %>"
DeleteCommand="DELETE FROM [providers_post] WHERE [h_id] = @original_h_id AND (([Address] = @original_Address) OR ([Address] IS NULL AND @original_Address IS NULL)) AND (([Details] = @original_Details) OR ([Details] IS NULL AND @original_Details IS NULL)) AND (([Size] = @original_Size) OR ([Size] IS NULL AND @original_Size IS NULL)) AND (([State] = @original_State) OR ([State] IS NULL AND @original_State IS NULL)) AND (([District] = @original_District) OR ([District] IS NULL AND @original_District IS NULL)) AND (([Landmark] = @original_Landmark) OR ([Landmark] IS NULL AND @original_Landmark IS NULL)) AND (([Cost] = @original_Cost) OR ([Cost] IS NULL AND @original_Cost IS NULL)) AND (([Pincode] = @original_Pincode) OR ([Pincode] IS NULL AND @original_Pincode IS NULL)) AND (([From_date] = @original_From_date) OR ([From_date] IS NULL AND @original_From_date IS NULL)) AND (([To_date] = @original_To_date) OR ([To_date] IS NULL AND @original_To_date IS NULL)) AND (([hoarding_type] = @original_hoarding_type) OR ([hoarding_type] IS NULL AND @original_hoarding_type IS NULL)) AND (([hoarding_image] = @original_hoarding_image) OR ([hoarding_image] IS NULL AND @original_hoarding_image IS NULL)) AND (([Lightboxes_type] = @original_Lightboxes_type) OR ([Lightboxes_type] IS NULL AND @original_Lightboxes_type IS NULL)) AND (([Valid] = @original_Valid) OR ([Valid] IS NULL AND @original_Valid IS NULL))"
InsertCommand="INSERT INTO [providers_post] ([Address], [Details], [Size], [State], [District], [Landmark], [Cost], [Pincode], [From_date], [To_date], [hoarding_type], [hoarding_image], [Lightboxes_type], [Valid]) VALUES (@Address, @Details, @Size, @State, @District, @Landmark, @Cost, @Pincode, @From_date, @To_date, @hoarding_type, @hoarding_image, @Lightboxes_type, @Valid)"
OldValuesParameterFormatString="original_{0}"
SelectCommand="SELECT [h_id], [Address], [Details], [Size], [State], [District], [Landmark], [Cost], [Pincode], [From_date], [To_date], [hoarding_type], [hoarding_image], [Lightboxes_type], [Valid] FROM [providers_post] ORDER BY [h_id]"

UpdateCommand="UPDATE [providers_post] SET [Address] = @Address, [Details] = @Details, [Size] = @Size, [State] = @State, [District] = @District, [Landmark] = @Landmark, [Cost] = @Cost, [Pincode] = @Pincode, [From_date] = @From_date, [To_date] = @To_date, [hoarding_type] = @hoarding_type, [hoarding_image] = @hoarding_image, [Lightboxes_type] = @Lightboxes_type, [Valid] = @Valid WHERE [h_id] = @original_h_id AND (([Address] = @original_Address) OR ([Address] IS NULL AND @original_Address IS NULL)) AND (([Details] = @original_Details) OR ([Details] IS NULL AND @original_Details IS NULL)) AND (([Size] = @original_Size) OR ([Size] IS NULL AND @original_Size IS NULL)) AND (([State] = @original_State) OR ([State] IS NULL AND @original_State IS NULL)) AND (([District] = @original_District) OR ([District] IS NULL AND @original_District IS NULL)) AND (([Landmark] = @original_Landmark) OR ([Landmark] IS NULL AND @original_Landmark IS NULL)) AND (([Cost] = @original_Cost) OR ([Cost] IS NULL AND @original_Cost IS NULL)) AND (([Pincode] = @original_Pincode) OR ([Pincode] IS NULL AND @original_Pincode IS NULL)) AND (([From_date] = @original_From_date) OR ([From_date] IS NULL AND @original_From_date IS NULL)) AND (([To_date] = @original_To_date) OR ([To_date] IS NULL AND @original_To_date IS NULL)) AND (([hoarding_type] = @original_hoarding_type) OR ([hoarding_type] IS NULL AND @original_hoarding_type IS NULL)) AND (([hoarding_image] = @original_hoarding_image) OR ([hoarding_image] IS NULL AND @original_hoarding_image IS NULL)) AND (([Lightboxes_type] = @original_Lightboxes_type) OR ([Lightboxes_type] IS NULL AND @original_Lightboxes_type IS NULL)) AND (([Valid] = @original_Valid) OR ([Valid] IS NULL AND @original_Valid IS NULL))">
<DeleteParameters>
<asp:Parameter Name="original_h_id" Type="Int32" />
<asp:Parameter Name="original_Address" Type="String" />
<asp:Parameter Name="original_Details" Type="String" />
<asp:Parameter Name="original_Size" Type="String" />
<asp:Parameter Name="original_State" Type="String" />
<asp:Parameter Name="original_District" Type="String" />
<asp:Parameter Name="original_Landmark" Type="String" />
<asp:Parameter Name="original_Cost" Type="Decimal" />
<asp:Parameter Name="original_Pincode" Type="String" />
<asp:Parameter Name="original_From_date" Type="String" />
<asp:Parameter Name="original_To_date" Type="String" />
<asp:Parameter Name="original_hoarding_type" Type="String" />
<asp:Parameter Name="original_hoarding_image" Type="String" />
<asp:Parameter Name="original_Lightboxes_type" Type="String" />
<asp:Parameter Name="original_Valid" Type="String" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="Address" Type="String" />
<asp:Parameter Name="Details" Type="String" />
<asp:Parameter Name="Size" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="District" Type="String" />
<asp:Parameter Name="Landmark" Type="String" />
<asp:Parameter Name="Cost" Type="Decimal" />
<asp:Parameter Name="Pincode" Type="String" />
<asp:Parameter Name="From_date" Type="String" />
<asp:Parameter Name="To_date" Type="String" />
<asp:Parameter Name="hoarding_type" Type="String" />
<asp:Parameter Name="hoarding_image" Type="String" />
<asp:Parameter Name="Lightboxes_type" Type="String" />
<asp:Parameter Name="Valid" Type="String" />
<asp:Parameter Name="original_h_id" Type="Int32" />
<asp:Parameter Name="original_Address" Type="String" />
<asp:Parameter Name="original_Details" Type="String" />
<asp:Parameter Name="original_Size" Type="String" />
<asp:Parameter Name="original_State" Type="String" />
<asp:Parameter Name="original_District" Type="String" />
<asp:Parameter Name="original_Landmark" Type="String" />
<asp:Parameter Name="original_Cost" Type="Decimal" />
<asp:Parameter Name="original_Pincode" Type="String" />
<asp:Parameter Name="original_From_date" Type="String" />
<asp:Parameter Name="original_To_date" Type="String" />
<asp:Parameter Name="original_hoarding_type" Type="String" />
<asp:Parameter Name="original_hoarding_image" Type="String" />
<asp:Parameter Name="original_Lightboxes_type" Type="String" />
<asp:Parameter Name="original_Valid" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="Address" Type="String" />
<asp:Parameter Name="Details" Type="String" />
<asp:Parameter Name="Size" Type="String" />
<asp:Parameter Name="State" Type="String" />
<asp:Parameter Name="District" Type="String" />
<asp:Parameter Name="Landmark" Type="String" />
<asp:Parameter Name="Cost" Type="Decimal" />
<asp:Parameter Name="Pincode" Type="String" />
<asp:Parameter Name="From_date" Type="String" />
<asp:Parameter Name="To_date" Type="String" />
<asp:Parameter Name="hoarding_type" Type="String" />
<asp:Parameter Name="hoarding_image" Type="String" />
<asp:Parameter Name="Lightboxes_type" Type="String" />
<asp:Parameter Name="Valid" Type="String" />
</InsertParameters>
</asp:SqlDataSource>

Answers (11)

How to select values from 4 chekboxes C#

uploading ms word document as blob