/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 vote144 views1 answer
How to get integer value from textbox in c#
C#
6 votes138 views1 answer
Unity call function on animation end
C#
0 vote134 views1 answer
Delay seconds in unity
C#
7 votes136 views1 answer
How to reference function in unity
C#
9 votes152 views3 answers
Null coalescing operator c#
C#
3 votes236 views1 answer
Unity editor select object in script
C#Unity
3 votes165 views1 answer
Check connection c#
C#
0 vote172 views1 answer
Hello world in unity c#
C#Unity
2 votes132 views1 answer
How to insert into a list c#
C#
0 vote134 views1 answer
C# copy array
C#