/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 vote407 views1 answer
C# video to frames
C#
1 vote357 views1 answer
C# monogame mouse position
C#
0 vote379 views1 answer
Button not working unity
C#Unity
2 votes346 views6 answers
Linq where
C#
-1 vote335 views1 answer
How to backgrund c# red
C#
1 vote398 views1 answer
Unity Rotate around the real center
C#Unity
-1 vote339 views1 answer
C# array inst working
C#
2 votes371 views1 answer
Scene switch unity
C#Unity
22 votes373 views2 answers
Unity coroutine
C#Unity
-1 vote416 views1 answer
C# count items in listbox
C#