/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

3 votes311 views5 answers
If c#
C#
0 vote308 views1 answer
C# how to fill a datatable
C#
0 vote303 views2 answers
Object list to csv c#
C#
4 votes326 views1 answer
Covert char[] to string C#
C#
0 vote322 views2 answers
Selenium scroll to element c#
C#
6 votes354 views1 answer
Function on animation end unity
C#
6 votes296 views4 answers
Increment laravel
C#
0 vote298 views2 answers
Linq top selling products
C#
0 vote291 views1 answer
Open another form with C# Winforms
C#
0 vote309 views1 answer
If vlaue exists don't enter event c#
C#