Function/Method to get DataTable from SQL Server Database in c#

Abu Ben Reaz — Sun, 15 Sep 2024 10:16:01 +0000

Function/Method to get DataTable from SQL Server Database in c#

In this sample, you pass SQL String to the function and get the result in DataTable. You can use this function from anywhere of your application to get DataTable based on SQL String.

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

namespace DBUtilities
{
public class Program
{
public static void Main(string[] args)
{
//Declare the variable
DataTable MyTable;
//Calling the function to get the result in DataTable
MyTable =GetTable("SELECT * FROM tblAccount”);
}
public static DataTable GetTable(string strSQL)
{
SqlConnection FillConn = new SqlConnection(YourConnetionString);
System.Data.DataTable UserTable = new System.Data.DataTable();
FillConn.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.Connection = FillConn;
sqlCommand.CommandText = strSQL;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter();
sqlDataAdapter.SelectCommand = sqlCommand;
sqlDataAdapter.Fill(UserTable);
return UserTable;
}
}
}

DEV Community: Abu Ben Reaz

Function/Method to get DataTable from SQL Server Database in c#

Function/Method to get DataTable from SQL Server Database in c#