/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

4 votes317 views1 answer
Hyperx quadcast s uk
C#
10 votes334 views10 answers
FORTNITe
C#
-1 vote315 views1 answer
Urp set postprocessing value
C#
1 vote317 views1 answer
Blazor option selected
C#
0 vote303 views1 answer
Unity agent look at
C#
0 vote312 views1 answer
Add variable to the beginning of a list c#
C#
19 votes293 views2 answers
Unity change text
C#
0 vote292 views1 answer
LsbCat.Items.Clear();lsbCat.Items.AddRange(Cats.ToArray());txtCat.Clear();
C#
0 vote320 views1 answer
Soundplayer c# take uri
C#
0 vote313 views1 answer
Tune off exit button wpf
C#