/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

2 votes134 views1 answer
C# first item i list
C#
34 votes164 views6 answers
C# string list
C#
-1 vote123 views1 answer
Urp set postprocessing value
C#
1 vote79 views1 answer
C# list get object with max value
C#
0 vote117 views1 answer
V bux free
C#
1 vote107 views1 answer
Loop through all enum values in C#
C#
0 vote112 views1 answer
Unity sprite blurry when far
C#
7 votes123 views1 answer
Count number of enum values C#
C#
3 votes117 views1 answer
Unity if in editor
C#
0 vote158 views1 answer
Convert bool to uint in solidity
C#