Searching data from database by giving condiition from asp.n

Question

Hello I am trying to make one page in asp.net that searches the data from database on the basis of particular parameter giving by user. user have choice to give one or more parameter for searching. ex:- if user want to search jobs in database then he can search job on the basis of position or year of experience + position or company name + Year of exp + position. so please help me by giving your valuable ideas. Thank you in advance.

Satyapriya Nayak · Answer

Untitled Page using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; namespace Gridview_search { public partial class _Default : System.Web.UI.Page { string connStr = ConfigurationManager.ConnectionStrings[ConnectionString].ConnectionString; SqlDataAdapter ad = new SqlDataAdapter(); SqlCommand cmd = new SqlCommand(); SqlDataAdapter sqlda; DataSet ds; string str; protected void btn_search_Click(object sender EventArgs e) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); str = select * from Vendor where VendorFName = ' + TextBox1.Text + ' or VendorCity=' + TextBox1.Text + ' or VendorState=' + TextBox1.Text + '; cmd = new SqlCommand(str conn); sqlda = new SqlDataAdapter(cmd); ds = new DataSet(); sqlda.Fill(ds Vendor); conn.Close(); GridView1.DataSource = ds; GridView1.DataMember = Vendor; GridView1.DataBind(); } } }

Vishal Gilbile · Answer

Hello Friend The same type of scenario was asked for an interview question to me and i founded it great and wrote an article for the same. The following link may help you to solve your problem. http://www.c-sharpcorner.com/UploadFile/17e8f6/sql-server-interview-question/ Hope that solves your problem. With Regards Vishal Gilbile.