/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

2 votes182 views1 answer
How to chagne rotation in unity
C#Unity
0 vote182 views1 answer
C# datetime.now to string only numbers
C#
0 vote188 views1 answer
Csc is not recognized
C#
0 vote168 views1 answer
Monegame deltatime
C#
6 votes181 views3 answers
How add script to html in jquery
C#
1 vote166 views2 answers
Getcomponent
C#
3 votes165 views6 answers
C# while loop
C#
1 vote181 views1 answer
How to set the frame rate unity
C#
7 votes163 views2 answers
C# stop loop
C#
3 votes176 views1 answer
Add leading zeroes in c#
C#