DataSet dtDataSet = new DataSet(); strsql="select * from Tab_FieldType order by f_Code"; OleDbDataAdapter dtCmd = new OleDbDataAdapter(strsql,myconn); dtCmd.Fill(dtDataSet,"Table_View"); DataView dtDataView=new DataView(dtDataSet.Tables["Table_View"]); f_Type.DataSource=dtDataView; f_Type.DataTextField="f_Name"; f_Type.DataValueField="f_Code"; f_Type.DataBind();
strsql="select * from Tab_FieldType order by f_Code";
OleDbDataAdapter dtCmd = new OleDbDataAdapter(strsql,myconn);
dtCmd.Fill(dtDataSet,"Table_View");
DataView dtDataView=new DataView(dtDataSet.Tables["Table_View"]);
f_Type.DataSource=dtDataView;
f_Type.DataTextField="f_Name";
f_Type.DataValueField="f_Code";
f_Type.DataBind();