column wise search engin in gridview using asp net

Question

Iftikar Hussain · Answer

try like this private DataTable GetRecords() { string name=textbox1.Text; string address=textbox2.Text; string id=textbox3.Text; SqlConnection conn = new SqlConnection(strConnection); conn.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.Text; cmd.CommandText = "Select * from Employees where (@Name IS NULL OR @Name = '' OR Name LIKE @Name) AND (@Address IS NULL OR @Address = '' OR Address LIKE @Address) AND (@ID IS NULL OR @ID = '' OR ID LIKE @ID) "; cmd.Parameters.AddWithValue("@Name", name); cmd.Parameters.AddWithValue("@Address", address); cmd.Parameters.AddWithValue("@ID", id); SqlDataAdapter dAdapter = new SqlDataAdapter(); dAdapter.SelectCommand = cmd; DataSet objDs = new DataSet(); dAdapter.Fill(objDs); return objDs.Tables[0]; } Regards, Iftikar

KRayudu V · Answer

protected void Page_Load( object sender, EventArgs e) 02 { 03 if (!IsPostBack) 04 { 05 BindGrid(); 06 } 07 } 08 private DataTable GetRecords() 09 { 10 SqlConnection conn = new SqlConnection(strConnection); 11 conn.Open(); 12 SqlCommand cmd = new SqlCommand(); 13 cmd.Connection = conn; 14 cmd.CommandType = CommandType.Text; 15 cmd.CommandText = "Select * from Employees" ; 16 SqlDataAdapter dAdapter = new SqlDataAdapter(); 17 dAdapter.SelectCommand = cmd; 18 DataSet objDs = new DataSet(); 19 dAdapter.Fill(objDs); 20 return objDs.Tables[0]; 21 22 } 23 private void BindGrid() 24 { 25 DataTable dt = GetRecords(); 26 if (dt.Rows.Count > 0) 27 { 28 grdSearch.DataSource = dt; 29 grdSearch.DataBind(); 30 } 31 }

Iftikar Hussain · Answer

share me the code for databind to gridview

KRayudu V · Answer

Hi Hussain, i done with data bind in gridview for that i have to implement search records column wise(EX:Suppose my field name is CITY, and i have records like Bangalore,Hyderabad,Chennai,Maysore)if i enter B in textbox it has to search B in that column.i does not search from other columns(SPECFIC COLUMN RECORDS)

KRayudu V · Answer

Hi Hussain, i done with data bind in gridview for that i have to implement search records column wise(EX:Suppose my field name is CITY, and i have records like Bangalore,Hyderabad,Chennai,Maysore)if i enter B in textbox it has to search B in that column.i does not search from other columns(SPECFIC COLUMN RECORDS)

Iftikar Hussain · Answer

Hi, First create a procedure like below CREATE PROCEDURE [dbo].[usp_GetSearchData] ( @Name varchar(50), @Address varchar(100), @ID varchar(10) ) AS SET NOCOUNT ON SELECT Name,Address,ID FROM YourTable WHERE (@Name IS NULL OR @Name = '' OR Name LIKE @Name) AND (@Address IS NULL OR @Address = '' OR Address LIKE @Address) AND (@ID IS NULL OR @ID = '' OR ID LIKE @ID) SET NOCOUNT OFF then in your code private void SearchData() { DataTable dt = new DataTable(); using (SqlConnection conn = new SqlConnection(@"Data Source=SQLEXPRESS;Initial Catalog=MyDb;Persist Security Info=True;User ID=MyUser;Password=MyPassword")) { if (conn.State == ConnectionState.Closed) conn.Open(); string sql = "usp_GetSearchData"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Name", textbox1.Text); cmd.Parameters.AddWithValue("@Address", textbox2.Text); cmd.Parameters.AddWithValue("@ID", textbox3.Text; SqlDataAdapter dap = new SqlDataAdapter(cmd); dap.Fill(dt); if (conn.State == ConnectionState.Open) conn.Close(); conn.Dispose(); } GrdiView1.DataSource=dt; GrdiView1.DataBind() } Regards, Iftikar

KRayudu V · Answer

column wise search engin in gridview using asp net for example in gridview we have columns like textbox1 textbox2 textbox3 Name Address ID suppose if we type A in textbox1 for that particular Column(Name) data has to search. the same way,it has to search each and every column in gridview

Sanjeeb Lenka · Answer

HI, can you plz provide more details.