专注收集记录技术开发学习笔记、技术难点、解决方案
网站信息搜索 >> 请输入关键词:
您当前的位置: 首页 > VB Dotnet

datagridview数据绑定的代码,该怎么处理

发布时间:2011-06-23 14:44:45 文章来源:www.iduyao.cn 采编人员:星星草
datagridview数据绑定的代码
知道SQL SA的密码123,IP 192.168.1.253,数据库名EN4,表名ANNA,用VB.NET如何写代码将表ANNA内容绑定到datagridview,表ANNA有12个字段,我只要其中3个字段,这个如何解决

------解决方案--------------------
连接数据库:
VB.NET code
Dim strConn As String = "server=192.168.1.253;database=EN4;uid=sa;pwd=123;"
Dim strConnection As String = strConn
Dim sqlConnection As New SqlConnection(strConnection)
Dim sqlStr as String = "select 字段1,字段2,字段3 from ANNA"

------解决方案--------------------
连接数据库:
Dim strConn As String = "server=192.168.1.253;database=EN4;uid=sa;pwd=123;"
Dim strConnection As String = strConn
Dim sqlConnection As New SqlConnection(strConnection)
Dim sqlStr as String = "select 字段1,字段2,字段3 from ANNA"

将数据转换为数据表:
Public Function GetDataTable(ByVal sqlcmd As String, ByVal tablename As String, ByVal sqlConnection As SqlConnection) As DataTable
'数据库连接
Dim dataAdapter As New SqlDataAdapter
Dim dst As New DataSet
Dim dt As New DataTable

sqlConnection.Open() '打开数据库

Dim sql As String = sqlcmd
Dim cmd As SqlCommand = New SqlCommand(sql, sqlConnection)

dataAdapter.SelectCommand = cmd
dataAdapter.Fill(dst, tablename)
dt = dst.Tables(tablename)
sqlConnection.Close() '关闭数据库

Return dt
End Function

将数据表绑定到datagridview
datagridview.DataSource = GetDataTable(sqlStr, "result", sqlConnection)
友情提示:
信息收集于互联网,如果您发现错误或造成侵权,请及时通知本站更正或删除,具体联系方式见页面底部联系我们,谢谢。

其他相似内容:

热门推荐: