♣

sql如何查找某一个表的所有字段名，并在c#中绑定到DropDownList

所属目录：Java | 类型：技术问答 | 时间：2007-05-21

问题：

以前有过一个这样的帖子，但不知怎么现在csdn搜不出来那个帖子了，郁闷

· 网友精彩回答：

发表者：wgsasd311

sql如何查找某一个表的所有字段名==>
select name from syscolumns where id=object_id(表名)

发表者：maoxianqiang

select column_name from information_schema.columns where table_name = 表名

发表者：zlp321002

----绑定dropdownlist控件---------
public function bindingdropdownlist(byval lstrsql as string, byref dropdownlist_ennm as web.ui.webcontrols.dropdownlist)
dim lconn as system.data.oledb.oledbconnection
dim lcmd as system.data.oledb.oledbcommand
dim lreader as system.data.oledb.oledbdatareader
dim ltext, lvalue as string
dropdownlist_ennm.items.clear()
try
lconn = new system.data.oledb.oledbconnection(connstring)
if lconn.state <> connectionstate.open then lconn.open()
lcmd = new system.data.oledb.oledbcommand(lstrsql, lconn)
lreader = lcmd.executereader
while lreader.read
ltext = lreader("ennm").tostring.trim
lvalue = lreader("ennmcd").tostring.trim
dropdownlist_ennm.items.add(new web.ui.webcontrols.listitem(ltext, lvalue))
end while
lreader.close()
catch ex as exception
exnotebugs(ex.message, "bindingdropdownlist.vb")
finally
disposeobject(lcmd, lconn)
end try
end function

↓热门目录：