Imports System.Data.SqlClient
Public Class GetBookInfo
'得到图书列表的collection,显示用
inherits login
Public Function GetBookInfo()as collection
Dim BookId As String '输出
Dim BookCode As String
Dim BooKName As String
Dim BookType As String
Dim Publisher As String
Dim PurchaseTime As String
Dim Comment As String Dim myCommand As SqlCommand
Dim da As New SqlDataAdapter("select * from BookInfo", conn)
Dim ds As New DataSet
Dim table As New DataTable
Dim dr As DataRow
Dim i As Integer
Dim cTotal As New Collection
Dim c As New Collection
getConnection()
da.Fill(ds, "BookInfo")
table = ds.Tables.Item(0) For i = 0 To table.Rows.Count - 1
dr = table.Rows.Item(i)
BookId = dr.Item(0)
BookCode = dr.Item(1)
BooKName = dr.Item(2)
BookType = dr.Item(3)
Publisher = dr.Item(4)
PurchaseTime = dr.Item(5)
Comment = dr.Item(6)c.add(bookid)
c.add(bookcode)
c.Add(bookName)
c.add(booktype)
c.add(publisher)
c.add(purchaseTime)
c.add(comment)ctotal.add(c) Next
return ctotal
End Function
End Class我要用Asp.NET的data.grid 控件怎么去调用?(以上程序是vb)
过程是怎么样的?
Public Class GetBookInfo
'得到图书列表的collection,显示用
inherits login
Public Function GetBookInfo()as collection
Dim BookId As String '输出
Dim BookCode As String
Dim BooKName As String
Dim BookType As String
Dim Publisher As String
Dim PurchaseTime As String
Dim Comment As String Dim myCommand As SqlCommand
Dim da As New SqlDataAdapter("select * from BookInfo", conn)
Dim ds As New DataSet
Dim table As New DataTable
Dim dr As DataRow
Dim i As Integer
Dim cTotal As New Collection
Dim c As New Collection
getConnection()
da.Fill(ds, "BookInfo")
table = ds.Tables.Item(0) For i = 0 To table.Rows.Count - 1
dr = table.Rows.Item(i)
BookId = dr.Item(0)
BookCode = dr.Item(1)
BooKName = dr.Item(2)
BookType = dr.Item(3)
Publisher = dr.Item(4)
PurchaseTime = dr.Item(5)
Comment = dr.Item(6)c.add(bookid)
c.add(bookcode)
c.Add(bookName)
c.add(booktype)
c.add(publisher)
c.add(purchaseTime)
c.add(comment)ctotal.add(c) Next
return ctotal
End Function
End Class我要用Asp.NET的data.grid 控件怎么去调用?(以上程序是vb)
过程是怎么样的?
解决方案 »
- 简单的jQuery事件处理问题
- asp.net开发的ERP系统后台权限如何设计?
- Web.Config如何改
- GridView如何吧图片放再gv内的列内
- 怎么把这个XML梆定到DropDownList1的2级联动菜单里面?
- web.cofig的问题
- 页面间怎么传送数据!急
- 我下载了一个ioffice2001,以前我记得没有什么访问许可,这回下载的,访问许可数只有一个,怎么解决啊?
- xp中写的程序在2003的服务器中模板不能调用...但在xp中可以用..求助高手
- 谁有用C#写的数据库连接组件的源码?cs文件。
- 请问从A表中取出的数据填充到DataSet中,如何将数据存入表B中?
- asp.net如何将从表(A)中随机取出的N条数据,插入到表(B)中去?
datagrid.bind()
我是新手,不是很懂,所以麻烦你能给我讲解一下吗?
谢谢
在VS的SDK的快速入门的第1讲就是这个(还是第2??忘记了)自己看看
2.如下绑定
datagrid.datasource=数据集;
datagrid.DataKeyField = "主键名";
datagrid.bind();仅仅绑定是非常简单的
我们一起做毕业设计的,实现的是图书管理系统,我是做数据库这一端的,我做的事存储过程,
B用VB。NET编写了上面的类,
现在是C要用ASP。NET来调用这个类,从而实现点击按钮就可以显示一个表格。
datagrid.bind()上面的程序是写在******.aspx.vb程序文件中的么?
谢谢!:)
getbookinfo是获得一个datatable
也就是dataset.Tables("表名")
你可以写个函数来做
比如:
private sub BindGrid()
datagrid.datasource=GetBookInfo()
datagrid.bind()
end sub
在Page_load里调用
if not page.IsPostBack then
BindGrid()
end if
至于datagrid的datasoruce可以是datareader,dataset,table...,只要是具有ICollection接口就可以了。
Inherits System.Web.UI.Page#Region " Web 窗体设计器生成的代码 " '该调用是 Web 窗体设计器所必需的。
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() End Sub
Protected WithEvents MyDataGrid As System.Web.UI.WebControls.DataGrid '注意: 以下占位符声明是 Web 窗体设计器所必需的。
'不要删除或移动它。
Private designerPlaceholderDeclaration As System.Object Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: 此方法调用是 Web 窗体设计器所必需的
'不要使用代码编辑器修改它。
InitializeComponent()
End Sub#End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'在此处放置初始化页的用户代码
End Sub Private Sub MyDataGrid_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyDataGrid.SelectedIndexChanged
DataGrid.DataSource = GetBookInfo()
DataGrid.bind()
End Sub
End Class
这样对不对阿
?
不知道.vs的广告吗?让你不用加班
{
string connstr = "Provider=MSDAORA.1;Password=aqjc;User ID=aqjc;Data Source=aqjc";
this.conn = new OleDbConnection(connstr);
this.conn.Open();
OleDbCommand myOleDbCommand = new OleDbCommand(sql,this.conn);
OleDbDataAdapter myData = new OleDbDataAdapter(myOleDbCommand); DataSet myDataset = new DataSet();
try
{
myData.Fill(myDataset);
}
catch(Exception ex)
{
throw ex;
} this.conn.Close();
return myDataset.Tables[0];
}private void Page_Load(object sender, System.EventArgs e)
{
string sql = "select * from tmp ";
DataTable mytab = this.conn_open(sql);
this.DataGrid1.DataSource = mytab;
this.DataGrid1.DataBind();
}