Answers for "how to retrieve data from database in c# using datatable"

how to retrieve data from database in c# using datatable

using System.Data;
using System.Data.SqlClient;

public DataTable StudentView()
{
    SqlConnection sqlCon = new SqlConnection(@"Server= localhost\SQLINSTANCENAME; Database= DBNAME; Integrated Security=True;");

    SqlDataAdapter sqlDa = new SqlDataAdapter("QUERY", sqlCon);

    DataTable dtbl = new DataTable();
    sqlDa.Fill(dtbl);

    return dtbl;
}

Posted by: Guest on September-20-2021

Code answers related to "how to retrieve data from database in c# using datatable"

Code answers related to "C#"

C# Answers by Framework

Browse Popular Code Answers by Language

Answers for "how to retrieve data from database in c# using datatable"

Code answers related to "how to retrieve data from database in c# using datatable"

Code answers related to "C#"

C# Answers by Framework

Browse Popular Code Answers by Language

Answers for "how to retrieve data from database in c# using datatable"

Code answers related to "how to retrieve data from database in c# using datatable"

Code answers related to "C#"

C# Answers by Framework

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us