/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

10 votes191 views2 answers
How to solve error CS0619: 'GUIText' is obsolete: 'GUIText has been removed. Use UI.Text instead.'
C#
1 vote247 views1 answer
Unity custom editor save changes
C#Unity
4 votes186 views1 answer
Asp.net data annotations email
C#
0 vote190 views2 answers
Total sales in array c++ two dimensional array
C#
2 votes187 views1 answer
To create Blazor project using CLI
C#
5 votes137 views2 answers
C# how to download file from url
C#
0 vote219 views1 answer
Unity get default font
C#
0 vote193 views1 answer
Email object c#
C#
94 votes236 views6 answers
How to convert string to int in c#
C#
3 votes202 views1 answer
How to make a global string c#
C#