在代码中(我在page_load)加载相应的程序代码,如下:
基本上就是用
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If IsPostBack Then Exit Sub
GridView1.DataSource = MakeTable(3,4)
GridView1.DataBind()
End Sub
' 这个是生成一个数据表格的函数
private function MakeTable(ByVal rows as integer,ByVal cols as integer) as datatable
Dim dt As New DataTable
Dim i, j, v As Integer
v = 1
For j = 0 To cols-1
Dim dc As New DataColumn(j.ToString, System.Type.GetType("System.Int32"))
dt.Columns.Add(dc)
Next
For i = 0 To rows-1
Dim dr As DataRow
dr = dt.NewRow
For j = 0 To dt.Columns.Count - 1
dr(j) = v
v += 1
Next
dt.Rows.Add(dr)
Next
return dt
end function
<%function table(rows,cols)
response.write("<table border='1'>")
for i = 1 to rows
response.write("<tr>")
for j = 1 to cols
response.write("<td>" &"无显示内容" &"</td>")
next
response.write("</tr>")
next
response.write("</table>")
end function
call table(9,2)
%>
既然是生成新表,你可以定义一个参加拼凑sql语句,游标抓出proName的值,作为表名,sql_str = 'create table '+表名+'(colname varchar(100))',然后游标抓出txtLog的值,作为表里的值,这时候sql_str+='insert into 表名 values('+txtLog的值+')'欢迎分享,转载请注明来源:内存溢出
评论列表(0条)