/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 vote334 views1 answer
C# print exception stack trace
C#
0 vote345 views2 answers
C# capitalize first letter of each word in a string
C#
0 vote351 views1 answer
Unity how to find the smallest value out of 2 numbers
C#Unity
1 vote352 views1 answer
This in unity
C#
0 vote343 views1 answer
Unity rigidbody drag and top speed relation
C#
3 votes316 views1 answer
Invoke once on update unity
C#
89 votes372 views3 answers
How to generate random numbers in c#
C#
0 vote321 views1 answer
How to make a string a list of characters c#
C#
24 votes316 views7 answers
Qwertyuiopasdfghjklzxcvbnm
C#
1 vote321 views1 answer
Unity check if a animator parameter trigger is activated
C#