标题:求助
只看楼主
csx223
Rank: 1
等 级:新手上路
帖 子:3
专家分:0
注 册:2004-8-4
 问题点数:0 回复次数:2 
求助
各位朋友,我是一名初学者,我不知道如何从数据库中检索一条记录赋值给一个变量,请大家指教,谢谢
搜索更多相关主题的帖子: 数据库 朋友 记录 
2004-08-04 11:10
griefforyou
Rank: 6Rank: 6
等 级:贵宾
威 望:27
帖 子:3336
专家分:0
注 册:2004-4-15
得分:0 

我也是初学,给个例子

Public Class Form1 Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

Public Sub New() MyBase.New()

'该调用是 Windows 窗体设计器所必需的。 InitializeComponent()

'在 InitializeComponent() 调用之后添加任何初始化

End Sub

'窗体重写处置以清理组件列表。 Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub

'Windows 窗体设计器所必需的 Private components As System.ComponentModel.IContainer

'注意:以下过程是 Windows 窗体设计器所必需的 '可以使用 Windows 窗体设计器修改此过程。 '不要使用代码编辑器修改它。 Friend WithEvents ListBox1 As System.Windows.Forms.ListBox Friend WithEvents Button1 As System.Windows.Forms.Button

<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.ListBox1 = New System.Windows.Forms.ListBox() Me.Button1 = New System.Windows.Forms.Button() Me.SuspendLayout() '

Me.ListBox1.ItemHeight = 12 Me.ListBox1.Location = New System.Drawing.Point(16, 16) Me.ListBox1.Name = "ListBox1" Me.ListBox1.Size = New System.Drawing.Size(176, 268) Me.ListBox1.TabIndex = 0 ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point(264, 240) Me.Button1.Name = "Button1" Me.Button1.Size = New System.Drawing.Size(96, 32) Me.Button1.TabIndex = 1 Me.Button1.Text = "Button1" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14) Me.ClientSize = New System.Drawing.Size(408, 293) Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button1, Me.ListBox1}) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False)

End Sub

#End Region

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim Conn As New System.Data.OleDb.OleDbConnection() Dim Cmd As New System.Data.OleDb.OleDbCommand() Dim DataReader As System.Data.OleDb.OleDbDataReader

Conn.ConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=D:\Inetpub\wwwroot\data.mdb" Conn.Open() Cmd.CommandText = "Select * from users" Cmd.Connection = Conn DataReader = Cmd.ExecuteReader While DataReader.Read() ListBox1.Items.Add(DataReader.Item(0) & "-" & DataReader.Item(1)) End While DataReader.Close() Conn.Close()

End Sub End Class

[此贴子已经被作者于2004-08-04 14:11:42编辑过]


天津网站建设 http://www./
2004-08-04 14:08
csx223
Rank: 1
等 级:新手上路
帖 子:3
专家分:0
注 册:2004-8-4
得分:0 
谢谢这位朋友,我的QQ是269779161,你可否告诉我你的QQ号码
2004-08-10 19:11



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-3863-1-1.html




关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.116537 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved