/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 vote205 views1 answer
Go right unity
C#Unity
0 vote227 views1 answer
C# how to refresh input field
C#
0 vote163 views1 answer
Validate base64 string c#
C#
1 vote255 views1 answer
Get appdata file path c#
C#
1 vote201 views1 answer
C# verify in class exist in list
C#
17 votes217 views2 answers
Sleep in C#
C#
1 vote124 views1 answer
C# concant 2 tab
C#
0 vote183 views1 answer
Trygetvalue dictionary c# example
C#
0 vote188 views1 answer
Edit pdf itextsharip
C#
0 vote203 views1 answer
How can datetimepicker accept hour as well
C#