/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 vote125 views1 answer
C# .net 3.5 post json httpclient
C#
2 votes55 views1 answer
How to add reference to rigidbody 2d
C#
20 votes121 views4 answers
Arrays in c#
C#
3 votes108 views1 answer
C# object list attribute to string
C#
0 vote106 views1 answer
Unity Reverse string
C#
19 votes109 views3 answers
C# string array to string
C#
1 vote96 views1 answer
C# wpf change label text color
C#
3 votes101 views2 answers
C# read file by line
C#
0 vote110 views1 answer
Ilist validation wpf mvvm
C#
3 votes97 views1 answer
C# async sleep
C#