declare @top30 table(rid INT IDENTITY(1,1), CustomerID nchar(10), name text)
insert @top30
select top 30 topic_id,topic_name from z1_Topic order by newID()
select * from @top30
DataSet myDataSet03 = new DataSet(); //開一個dataset
myDataSet03.Tables.Add("Reg_Pro_Item"); // 開一個table*註
DataColumn newcolumn = new DataColumn("pro_id", typeof(System.String)); //新增columns a (注意型態
myDataSet03.Tables["Reg_Pro_Item"].Columns.Add(newcolumn);//把columns a塞到你要的tables
DataColumn newcolumn2 = new DataColumn("pro_name", typeof(System.String));//依樣畫葫蘆
myDataSet03.Tables["Reg_Pro_Item"].Columns.Add(newcolumn2);//再塞一次
DataRow new_row3 = myDataSet03.Tables["Reg_Pro_Item"].NewRow();
new_row3["pro_id"] = "000";
new_row3["pro_name"] = "請選擇";