类型：转载 责任编辑：asp.net 日期：2007/05/23
热门软件下载：
如何连接oracle数据库啊,怎么写的?
网友回答：
Dim strConnect As String = "Server=192.168.2.109;Database=ShoboDB;User ID=shobo;Password=shobo;"
Dim objConnection As SqlConnection = New SqlConnection(strConnect)
objConnection.Open()
Dim objCommand As SqlCommand = New SqlCommand()
objCommand.Connection = objConnection
objCommand.CommandType = CommandType.Text
Dim sda As SqlDataAdapter = New SqlDataAdapter()
Dim sda As New SqlDataAdapter(objCommand, objConnection)
sda.SelectCommand = objCommand
Dim ds As DataSet = New DataSet()
strSql = "Select * From smg_kaib "
objCommand.CommandText = strSql
sda.Fill(ds)
DataGrid1.PageSize = 5
DataGrid1.PagerStyle.HorizontalAlign = HorizontalAlign.Right
DataGrid1.PagerStyle.PageButtonCount = 3
DataGrid1.PagerStyle.Mode = PagerMode.NumericPages
DataGrid1.PagerStyle.Mode = PagerMode.NextPrev
DataGrid1.PagerStyle.NextPageText = "next page"
DataGrid1.PagerStyle.PrevPageText = "last page"
DataGrid1.DataSource = ds
DataGrid1.DataBind()
objConnection.Close()