/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

1 vote148 views1 answer
How to stop player rotating when hit by object
C#
25 votes151 views3 answers
If get key down unity
C#Unity
0 vote134 views1 answer
C# domain name to ip address
C#
0 vote116 views1 answer
Quine in c#
C#
0 vote120 views1 answer
Ocr library for c#
C#
0 vote106 views1 answer
How to create a class and objects in C#
C#
2 votes109 views2 answers
Get diff btw datetimes two C#
C#
1 vote149 views1 answer
C# settings file
C#
0 vote114 views1 answer
C# datatable column alias
C#
0 vote141 views1 answer
Add row and columns to grid wpf in code
C#