This blog gives you information about how to
get column name of a particular table from database.
Here .cs file : Program.cs
namespace
ColumnNames
{
class Program
{
static void
Main(string[] args)
{
try
{
var objDataset1 = new
DataSet();
var presentTable = new
DataSet();
Console.Write("Enter Database Name : ");
var dbname = Console.ReadLine();
Console.WriteLine();
Console.Write("Enter Table Name : ");
var tname = Console.ReadLine();
Console.WriteLine();
#region
Connection String For Database
OleDbConnection conn = new OleDbConnection();
conn.ConnectionString =
"provider=SQLOLEDB;" +
"Data Source=ServerName;" +
"Initial Catalog=" + dbname +
";" +
"User id=UserName;" +
"Password=Secrete;";
conn.Open();
#endregion
Connection String For Database
#region Is
Table Present
// Check table present or not in
database
var isPresentTable =
new OleDbCommand("Select * from
INFORMATION_SCHEMA.TABLES where table_name='" + tname +
"';", conn);
var res = new
OleDbDataAdapter(isPresentTable);
res.Fill(presentTable);
if (presentTable.Tables[0].Rows.Count == 0)
{
Console.WriteLine("Table
Not Present");
return;
}
#endregion
OleDbCommand
objCmdSelect = new OleDbCommand("select
* from " + tname + ";", conn);
var objAdapter1 = new
OleDbDataAdapter(objCmdSelect);
objAdapter1.Fill(objDataset1);
Console.WriteLine("Column Names of Table ");
Console.WriteLine();
//Featch column name of a table from
the dataset
foreach (DataColumn column
in objDataset1.Tables[0].Columns)
{
Console.WriteLine(column.ColumnName);
}
conn.Close();
}
catch (Exception)
{
throw;
}
Console.ReadKey();
}
}
}
Output