/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 vote325 views1 answer
C# asp.net hover tooltip
C#
0 vote322 views1 answer
First digit of number ic c#
C#
1 vote303 views1 answer
How set element in middle in bootstrap
C#
1 vote330 views1 answer
Csharp get integer part of number
C#
0 vote334 views1 answer
Dictionary instanciation
C#
1 vote342 views1 answer
How can you learn C# on your own
C#
0 vote370 views2 answers
Unity screentoworldpoint
C#
22 votes339 views2 answers
How do i convert to base64 c#
C#
0 vote316 views1 answer
C# converting to string examples
C#
0 vote323 views1 answer
Unity matchinfo
C#