Searching Record From a DataBase and Displaying In a Gridviw

Question

Hi to all I am new in .net.. have a one problem.. in my code i have two textboxes like Student and Course and one button Submit and Gridview. when am enter student name in student textbox it display partucular name related data only display in gridview.. if am enter course dtails it display course related data in same gridview.. Database name is StudentCourse (1 Table only).. Could any body help me how to write code for above query...

Nimit Joshi · Answer

Following is the code for searching name and display the related field in GridView. Suppose you have Name column in database table. In the WebForm1.aspx.cs file: using System; using System.Data; using System.Data.SqlClient; namespace SampleHomeApplication { public partial class DataForm : System.Web.UI. Page { SqlConnection con; SqlDataAdapter adap; DataTable dt; public DataForm() { con = new SqlConnection ( Your Connection String ); } protected void Page_Load( object sender EventArgs e) { if (!IsPostBack) { GetData(); } } public void GetData() { string Name = TxtName.Text; adap = new SqlDataAdapter ( Select * from Student where Name= ' +Name+ ' con); dt = new DataTable (); adap.Fill(dt); DataGridView.DataSource = dt; DataGridView.DataBind(); } } }

Sourabh Somani · Answer

SqlConnection conn = new SqlConnection (  server=./SQLEXPRESS;DATABASE= StudentCourse; Integreted security=true ); String query = SELECT * FROM where student_name='+TextBox1.Text+' or course_details='+TextBox2.Text+' ; SqlDataAdapter adapter = new SqlDataAdapter (queryconn); DataSet ds = new DataSet (); adapter. Fill (ds); adapter. Dispose (); .datasource= ds; .databind();