Loading

How to get fields exist on table by passing table name by us

How to get fields exist on table by passing table name by us

ahmed elbarbary

7y962.NET

How to get fields exist on table by passing table name by using asp.net core 2.1 ?

How to get fields exist on table by passing table name ?

suppose I have table name Employee on SQL server 2012 and this is fields of Employee Table EmployeeCode,EmployeeName,,..etc

How to make function pass to it table name and it will retrieve fields or columns as

EmployeeCode,

EmployeeName

I work on web API core project with angular 7

structure of function as below

public List GetColumnNames(string tablename)

{

}

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jignesh Kumar7y ago
Hi ,

You can create function like this.
public List<string> GetColumnNames(string tablename)
  {
      List<string> listacolumnas = new List<string>();
      using (SqlConnection connection = new SqlConnection(Connection))
      using (SqlCommand command = connection.CreateCommand())
      {
          command.CommandText = "select c.name from sys.columns c inner join sys.tables t on t.object_id = c.object_id and t.name = '"+tablename+"' and t.type = 'U'";
          connection.Open();
          using (var reader = command.ExecuteReader())
          {
              while (reader.Read())
              {
                  listacolumnas.Add(reader.GetString(0));
              }
          }
      }
      return listacolumnas;
  }
+1
Vivek Kumar7y ago
Hi,
Have a look to below links for your reference.

https://www.aspsnippets.com/Articles/Tip-Query-to-get-all-column-names-from-database-table-in-SQL-Server.aspx

https://stackoverflow.com/questions/1054984/how-can-i-get-column-names-from-a-table-in-sql-server
0
Amit Gupta7y ago
1. SELECT COLUMN_NAME
2. FROM INFORMATION_SCHEMA.COLUMNS
3. WHERE TABLE_NAME = 'Your Table Name'
5. ORDER BY ORDINAL_POSITION
You can comment order by line (its optional)
+1