How to Retrieve Data from Database using C# | retrieve data from sql server in c# | Ado.Net Tutorial

class Program
{
static void Main(string[] args)
{
string cs = "data source = .; database = TestDB; Integrated security = true";

SqlConnection con = new SqlConnection(cs);

string query = "select * from employee";

SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandText = query;

Console.WriteLine("Id FName LName Age Salary");
Console.WriteLine("--- ------- ------- ----- --------");


con.Open();

SqlDataReader rdr = cmd.ExecuteReader();

if(rdr.HasRows)
{
while(rdr.Read())
{
Console.WriteLine("{0} {1} {2} {3} {4}"
,rdr["Empid"],rdr["First_Name"],rdr["Last_Name"],rdr["Age"],rdr["Salary"]);
}
}
con.Close();

//SqlCommand cmd1 = new SqlCommand(query, con);
}
}

Question:

How to access data from sql server using c#
How to fetch data from database in c#
ExecuteReader in c#
ExecuteReader() in c#
accessing data from database using c#
how to fetch data from database using c# in console application
retrieve data from sql database in c#
How to Retrieve Data from Database using C#
how to display data from database in c#
how to show data from database in c#
c# display data from database
display data from database .net c#

#informtechi
#ADO
#dataRetrive

[epicurean_panda]

Awesome Content bro, I am on the verge to complete your Ado.net series Please keep uploading video soon you will gain some followers, Don't just stop here. The way you explain is quite simple Love it

[conaxlearn]

Hi, how do you handle null values coming from SQL?

[lalitshahane]

Sir Excellent video Mujhe ye data agar excel me save karna ho to kaise karenge

[hardysingh]

Bhai apne jo string ke pahle write line me {0}. {1} likha vo console me print kyo nahi hua

[FarhanKhan-iovt]

Agr ye humko radio button m chahiye hoga to kaise kre bataye ?

[HeelsOnTheHills]

How to get those sql server data on button click?