Databases
StackOverflow2013
Postsdbo
POHow to fetch data according to my search in a grid
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POHow to fetch data according to my search in a grid
    primarykey
    data
    text
    <p>In textbox I have to type string which will be searched in a table. if data is found in any of the 3 columns data will be shown in a gridview.3 columns are title, description and keywords. If title chk box is checked it will search through title and if keyword s checked it will search in it. if any of the checkbox is not checked it wont search in tht particular column. I have 2 radio button also one of them need to be selected.if and_radio is clicked it will search data in both columns if or is clicked idf data is found in any of the column will be shown.... Help trying it for a long...It has to be done with procedure.. What code should i have to write on search button click for searching data in textbox and then populate the result in grid STORED PROCEDURE i used </p> <pre><code>set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER Procedure [dbo].[sp_Normal_Search_Library] @title AS nvarchar(max), @Description AS nvarchar(max), @Keywords AS nvarchar(max), @Chk_title AS BIT , @Chk_Description AS Bit , @Chk_Keywords AS BIT, @RD_AND AS BIT, @RD_OR AS BIT AS if @RD_AND = 1 Begin if @Chk_title = 1 Begin Select title from server_des where title Like '%'+@title+'%' End if @Chk_Description=1 Begin Select Description from server_des where Description Like '%'+@Description+'%' End if @Chk_Keywords=1 Begin Select Keywords from server_des where Keywords Like '%'+@Keywords+'%' End if @Chk_title = 1 AND @Chk_Description = 1 Begin Select title, Description from server_des where title Like '%'+ @title+'%' AND Description Like '%'+@Description+'%' End if @Chk_Description=1 AND @Chk_Keywords=1 Begin Select Description, Keywords from server_des where Description Like'%'+@Description+'%' AND Keywords Like '%'+@Keywords+'%' End if @Chk_title=1 AND @Chk_Keywords=1 Begin Select title, Keywords from server_des where title Like'%'+@title+'%' AND Keywords Like'%'+@Keywords+'%' End if @Chk_title=1 AND @Description=1 AND @title=1 Begin Select title,Description, Keywords from server_des where title Like '%'+@title+'%'AND Description Like '%'+@Description+'%' AND Keywords Like '%' +@Keywords+'%' End End ELSE IF @RD_OR=0 Begin if @Chk_title = 1 Begin Select title from server_des where title Like'%'+ @title+'%' End if @Chk_Description=1 Begin Select Description from server_des where Description Like '%'+@Description+'%' End if @Chk_Keywords=1 Begin Select Keywords from server_des where Keywords Like '%'+@Keywords+'%' End if @Chk_title = 1 AND @Chk_Description = 1 Begin Select title, Description from server_des where title Like '%'+ @title+'%' AND Description Like '%'+@Description+'%' End if @Chk_Description=1 AND @Chk_Keywords=1 Begin Select Description, Keywords from server_des where Description Like '%'+@Description+'%' AND Keywords Like '%'+@Keywords+'%' End if @Chk_title=1 AND @Chk_Keywords=1 Begin Select title, Keywords from server_des where title Like '%'+@title+'%' AND Keywords Like '%'+@Keywords+'%' End if @Chk_title=1 AND @Description=1 AND @title=1 Begin Select title, Description, Keywords from server_des where title Like'%'+@title+'%'AND Description Like '%'+@Description+'%' AND Keywords Like '%' +@Keywords+'%' End End </code></pre> <p>In business logic I created method: </p> <pre><code> public DataTable Fillgrid(string title,string Description, string Keywords) { con.ConnectionString = ConfigurationManager.ConnectionStrings["LibrarySql"].ConnectionString; SqlCommand cmd = new SqlCommand(); cmd.CommandText = "sp_Normal_Search_Library"; cmd.CommandType = CommandType.StoredProcedure; //string query = "select * from Server_des"; cmd.Parameters.AddWithValue("@title", title); cmd.Parameters.AddWithValue("@Description",Description); cmd.Parameters.AddWithValue("@Keywords",Keywords); cmd.Connection = con; SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); con.Open(); sda.Fill(dt); return dt; </code></pre> <p>Now how do I populate data in the grid on my web form?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USJeremy Thompson
    1. USAishna
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POHow to fetch data according to my search in a grid
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POHow to fetch data according to my search in a grid
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POHow to fetch data according to my search in a grid
      1. USdivya
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload