Retrieve Column Names From Table

follow this link.
http://stackoverflow.com/questions/452464/how-can-i-get-column-names-from-a-table

Thanks & Regards
Hari

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

SELECT COLUMN_NAME
FROM information_schema.columns
WHERE table_name = 'tablename'
ORDER BY ordinal_position

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

Please use following simply.........

Sp_help Bill_master

or

select column_name 'Column Name', data_type 'Data Type', character_maximum_length 'Maximum Length' from information_schema.columns where table_name = 'table_name'

please mark as answer if it is helpful.......

Regards,
Vikash Pathak

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

I think I am not clear with the question.

To retrieve column names from sql we can just use below query

select name from syscolumns where id=object_id('TableName ')

But I am using Entityframework, so I am askin how to retrieve the column names that are properties.

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

hi Prathap,

This might help you

IEnumerable<FieldList> properties = from p in typeof(T).GetProperties()
where (from a in p.GetCustomAttributes(false)
where a is EdmScalarPropertyAttribute
select true).FirstOrDefault()
select new FieldList
{
FieldName = p.Name,
FieldType = p.PropertyType,
FieldPK = p.GetCustomAttributes(false).Where(a => a is EdmScalarPropertyAttribute && ((EdmScalarPropertyAttribute)a).EntityKeyProperty).Count() > 0
};


A good answer and explanation to your query in the below link..
http://stackoverflow.com/questions/6056597/entity-framework-how-do-i-get-the-columns

Hope this solves ur problem.

Thanks and Regards,
Gayathri P

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

hi

refer this url

http://www.dotnetfunda.com/codes/code3293-how-to-bind-particular-table-columns-bind-the-gridview-and-dropdownlist.aspx 

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator

hi
try this
Please mark as answer if it helpful to you.

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com

Nkkppp, if this helps please login to Mark As Answer. | Alert Moderator