/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 vote162 views1 answer
C# udpclient receive buffer size
C#
8 votes199 views3 answers
Save byte array to file c#
C#
0 vote246 views1 answer
C# int to string date conversion
C#
0 vote241 views1 answer
Unity conditional field
C#Unity
0 vote227 views1 answer
For what is percent sign in unity c#
C#Unity
0 vote184 views1 answer
Aps.net core mvc chek box
C#
0 vote232 views1 answer
C# configurationmanager load from file
C#
0 vote194 views1 answer
C# How to display text in console
C#
31 votes197 views3 answers
Get key unity
C#
0 vote168 views1 answer
Dictionary plus generic class c#
C#