/C#/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;
}

Source: stackoverflow.com

Similar codes

0 vote213 views1 answer
Bubble sort recursive c#
C#
1 vote237 views1 answer
Unity editor dropdown
C#
9 votes237 views3 answers
Switch case with 2 variables c#
C#
0 vote202 views1 answer
Phone
C#
2 votes213 views4 answers
C# linq select only unique values from list
C#
0 vote265 views1 answer
C# check if object is of any generic type
C#
0 vote228 views2 answers
Using Tls12 .net 3.5
C#
0 vote239 views1 answer
C# dictionary key set
C#
0 vote214 views1 answer
.net core upgrade assistant
C#
17 votes229 views2 answers
Visual studio c# print to console
C#