LOGIN Page and Home page with Grid View in asp.net

Using System.Data.SqlClient;


private string GetConnectionString()
{
  return System.Configuration.ConfigurationManager.ConnectionStrings["dbconstr"].ConnectionString;
}


protected void btnlog_Click(object sender, EventArgs e)
{
  sqlConnection con=new sqlConnection(GetConnectionString());
  string sqlstmt=string.Empty;
  sqlstmt=" select * from register where username='"+tbus.Text+"' ";
 
  try
 {
   sqlCommand cmd=new sqlCommand(sqlstmt,con);
   sqlDataAdapter sqlda=new sqlDataAdapter(cmd);
   dataTable dt=new dataTbale();
   dataSet ds=new dataSet();

   sqlda.Fill(ds,"register");
  dt=ds.Tables[0];
 
  string dbusna="";
  string dbpwd="";

 foreach(DataRow DR in dt.Rows)
  {
    dbusna = DR["username"].ToString();
    dbpwd=DR["pwd"].ToString();
   }

 if(dbusna==tbus.Text)
 {
   if(dbpwd == tbpwd.Text)
  {
     Response.Redirect("home.aspx");
   }
}
else
 {
   response.write("Check UserName & Password ");
 }

}

catch(sqlException ex)
{
  string msg="Login Error";
  msg+=ex.Message;
 throw new Exception(msg);
}

finally
{
  con.close();
}

}// end of login button


                                                     HOME.aspx




in Design View::::::::::::::


    <asp:GridView id="GridView1" runat="server" AutoGenerateColumns="False">
        <columns>
            <asp:BoundField DataField="username" HeaderText="USERNAME"/>
             <asp:BoundField DataField="pwd" HeaderText="PASWORD"/>
             <asp:BoundField DataField="repwd" HeaderText="CONFIRM PASSWORD"/>
             <asp:BoundField DataField="gender" HeaderText="GENDER"/>
             <asp:BoundField DataField="qual" HeaderText="QUALIFICATION"/>
             <asp:BoundField DataField="addr" HeaderText="ADDRESS"/>
             <asp:BoundField DataField="mobno" HeaderText="MOBILE NO"/>
             <asp:BoundField DataField="country" HeaderText="COUNTRY"/>
         </columns>
    <asp:GridView>


in C# page:::::::::::::


Using System.Data.SqlClient;

public partial class home:System.web.UI.Page
{
 protected void Page_Load(object sender,EventArgs e)
 {
  if(!IsPostBack)
  {
       BindGridView();
   }
 }

private string GetConnectionString()
{
  return System.Configuration.ConfigurationManager.ConnectionStrings["dbconstr"].ConnectionString;
}

private void BindGridView()
{
 DataTable dt=new DataTable();
 sqlConnection con=new sqlConnection(GetConnectionString());
 string sqlstmt=string.Empty;
 sqlstmt="select * from register";
 try
 {
   con.open();
   sqlCommand cmd=new sqlCommand(sqlstmt,con);
   sqlDataAdapter sqlda=new sqlDataAdapter(cmd);
   sqlda.Fill(dt);
   if(dt.Rows.Count > 0)
  {
    GridView1.DataSource = dt;
    GridView1.DataBind();
  }
}

catch(sqlException ex)
{
  string msg="Fetch Error";
  msg+=ex.Message;
 throw new Exception(msg);
}

finally
{
  con.close();
}

}// end of home page......