Searching data from database by giving condiition from asp.n

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="Gridview_search._Default" %>

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(); } } }

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.