/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

1 vote154 views2 answers
C# get first and last day of current month
C#
0 vote153 views1 answer
The type or namespace name 'Notifications' does not exist in the namespace 'Unity' (are you missing an assembly reference?)
C#
12 votes188 views2 answers
C# messagebox yes no "wpf"
C#
0 vote138 views1 answer
Unity script template folder
C#
-1 vote128 views1 answer
C# get regedit value
C#
0 vote177 views1 answer
Attribute decorator to require email format of string c#
C#
2 votes200 views2 answers
Unity rotate around axis
C#Unity
0 vote138 views1 answer
Bitwise Left Shift C#
C#
9 votes166 views1 answer
C# lambdas
C#
0 vote152 views1 answer
C# join strings with comma
C#