Help Regarding Asp.Net Project Using c#

Question

Hi !

Now i want to show a entered filed from sql database, for Example student table contains name,address, and id, In textbox if i enter "name" means it display name filed from student table,

I am a beginner in Asp.Net, So please Help me to do this project.....

Thanks!

Regards!

G.Arun Prasath

Krishna Garad · Answer

you can try this //Connection and Command SqlConnection cn=new SqlConnection("Your Connection String"); //pass the field name from textbox to command SqlCommand cmd=new SqlCommand("Select"+textbox1.Text+" From Student ",cn); //Create Dataset DataSet ds=new DataSet(); //Call data addapeter to fill the dataset SqlDataAdapter da=new SqlDataAtapter(cmd); da.Fill(ds); //Bind to Gridview GridView1.DataSource=ds.Tables[0]; GridView1.DataBind();

Satyapriya Nayak · Answer

Hi Arun, You question is not clear.As per my understanding you need perhaves when you write name in the textbox all records related to this name field you want to fetch. Try this... Untitled Page Text="Show Records" /> 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 WebApplication1 { 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 Button1_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection(connStr); conn.Open(); str = "select * from student where name = '" + TextBox1.Text + "'"; cmd = new SqlCommand(str, conn); sqlda = new SqlDataAdapter(cmd); ds = new DataSet(); sqlda.Fill(ds, "student"); conn.Close(); GridView1.DataSource = ds; GridView1.DataMember = "student"; GridView1.DataBind(); } } } Thanks

arun prasath · Answer

Thanks Krishna.....i got it....

Krishna Garad · Answer

you are mainly mixing events in page load you written button click write like bellow 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; //Page_Load public partial class testsearch : System.Web.UI.Page { } //Button Click Event protected void Button1_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection("Data Source=admin;Initial Catalog=detail;Integrated Security=True"); //pass the field name from textbox to command SqlCommand cmd = new SqlCommand("Select" + TextBox1.Text + " From annauniversity ", cn); //Create Dataset DataSet ds = new DataSet(); //Call data addapeter to fill the dataset SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); //Bind to Gridview GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); }

arun prasath · Answer

This is my code....i don't know what is error... 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; public partial class testsearch : System.Web.UI.Page { protected void Button1_Click(object sender, EventArgs e) { SqlConnection cn = new SqlConnection("Data Source=admin;Initial Catalog=detail;Integrated Security=True"); //pass the field name from textbox to command SqlCommand cmd = new SqlCommand("Select" + TextBox1.Text + " From annauniversity ", cn); //Create Dataset DataSet ds = new DataSet(); //Call data addapeter to fill the dataset SqlDataAdapter da = new SqlDataAtapter(cmd); da.Fill(ds); //Bind to Gridview GridView1.DataSource = ds.Tables[0]; GridView1.DataBind(); } }

Krishna Garad · Answer

add reference to System.Data.SqlClient namespace.

arun prasath · Answer

I got the above error while compile your code.....

arun prasath · Answer

Krishna Garad · Answer

just write the given code in any click event and on you page put one gridview say in button click event you want to display the values in gridview then write the code in button click protected void Button1_Click(object sender, EventArgs e) { SqlConnection cn=new SqlConnection("Your Connection String"); //pass the field name from textbox to command SqlCommand cmd=new SqlCommand("Select"+textbox1.Text+" From Student ",cn); //Create Dataset DataSet ds=new DataSet(); //Call data addapeter to fill the dataset SqlDataAdapter da=new SqlDataAtapter(cmd); da.Fill(ds); //Bind to Gridview GridView1.DataSource=ds.Tables[0]; GridView1.DataBind(); } and on your source page

arun prasath · Answer

@krishna Please Give full code page....please....

arun prasath · Answer

Thank You Satyapriya and krishna.......