retrive mysql database values to a textbox in asp.net

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





 


 

 

 
 

 
 
 

 
 
 

 
 
 

 
 
 

 
 
 

 
 

using System;
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 _Default : System.Web.UI.Page
{
  string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
  SqlCommand com;
  //SqlDataAdapter sqlda;
  //DataSet ds;
  string str;
 
    protected void Page_Load(object sender, EventArgs e)
  {
  SqlConnection con = new SqlConnection(connStr);
  con.Open();
  str = "select * from std";
  com = new SqlCommand(str, con);
  SqlDataReader reader = com.ExecuteReader();
  if (reader.Read())
  {
  TextBox2.Text=reader["NAME"].ToString();
  TextBox3.Text = reader["BRANCH"].ToString();
  TextBox4.Text = reader["ADDRESS"].ToString();
  TextBox5.Text = reader["PHNO"].ToString();
  TextBox6.Text = reader["STATE"].ToString();

  reader.Close();
  con.Close();
  }
  }
}