using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class retrive : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=CODEM-PC;Initial Catalog=technology;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False");
SqlCommand cmd = new SqlCommand(("select * from anvesh"), con);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (dr.Read())
{
fn.Text = dr["firstName"].ToString();
ln.Text = dr["lastName"].ToString();
un.Text = dr["username"].ToString();
p.Text = dr["password"].ToString();
dob.Text = dr["dob"].ToString();
g.Text = dr["gender"].ToString();
m.Text = dr["mobile"].ToString();
Label1.Text = dr["email"].ToString();
}
}
}
cmd.ExecuteNonQuery();
con.Close();
}
}
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class retrive : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=CODEM-PC;Initial Catalog=technology;Integrated Security=True;Connect Timeout=15;Encrypt=False;TrustServerCertificate=False");
SqlCommand cmd = new SqlCommand(("select * from anvesh"), con);
con.Open();
using (SqlDataReader dr = cmd.ExecuteReader())
{
while (dr.Read())
{
if (dr.Read())
{
fn.Text = dr["firstName"].ToString();
ln.Text = dr["lastName"].ToString();
un.Text = dr["username"].ToString();
p.Text = dr["password"].ToString();
dob.Text = dr["dob"].ToString();
g.Text = dr["gender"].ToString();
m.Text = dr["mobile"].ToString();
Label1.Text = dr["email"].ToString();
}
}
}
cmd.ExecuteNonQuery();
con.Close();
}
}
No comments:
Post a Comment