ak1_2004
پنج شنبه 08 بهمن 1388, 08:30 صبح
سلام
یه برنامه دارم می نویسم که با بانک اطلاعاتی مشکل پیدا کردم !
اطلاعات رو به بانک اطلاعاتی اضافه می کنم اما برای بیرون کشیدن اطلاعات مشکل دارم !
Imports System.Data.OleDb
Imports System.Data.SqlClient
Public Class Form5
Dim id As Integer
Private Sub CommandGet(ByVal sqlstring As String)
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Database1.mdb"
Dim con As OleDbConnection = New OleDbConnection(strcon)
Dim cmd As OleDbCommand = New OleDbCommand
Dim data As OleDbDataReader
con.Open()
cmd.CommandText = sqlstring
cmd.Connection = con
data = cmd.ExecuteReader
While data.Read
id = data.Item(0)
TextBox1.Text = data.Item(1)
TextBox2.Text = data.Item(2)
TextBox3.Text = data.Item(3)
RichTextBox1.Text = data.Item(4)
End While
con.Close()
End Sub
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.GorupTableAdapter.Fill(Me.Database1DataSet.Goru p)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
End Sub
Private Sub RichTextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
CommandGet("SELECT * FROM Group ORDER BY Id")
End Sub
End Class
این کد بالا یکی از فرم های من هست !
تا روی BUtton2 کلیک می کنم ، اررور می ده !
یه برنامه دارم می نویسم که با بانک اطلاعاتی مشکل پیدا کردم !
اطلاعات رو به بانک اطلاعاتی اضافه می کنم اما برای بیرون کشیدن اطلاعات مشکل دارم !
Imports System.Data.OleDb
Imports System.Data.SqlClient
Public Class Form5
Dim id As Integer
Private Sub CommandGet(ByVal sqlstring As String)
Dim strcon As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Database1.mdb"
Dim con As OleDbConnection = New OleDbConnection(strcon)
Dim cmd As OleDbCommand = New OleDbCommand
Dim data As OleDbDataReader
con.Open()
cmd.CommandText = sqlstring
cmd.Connection = con
data = cmd.ExecuteReader
While data.Read
id = data.Item(0)
TextBox1.Text = data.Item(1)
TextBox2.Text = data.Item(2)
TextBox3.Text = data.Item(3)
RichTextBox1.Text = data.Item(4)
End While
con.Close()
End Sub
Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.GorupTableAdapter.Fill(Me.Database1DataSet.Goru p)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
End Sub
Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
End Sub
Private Sub RichTextBox1_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RichTextBox1.TextChanged
End Sub
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
CommandGet("SELECT * FROM Group ORDER BY Id")
End Sub
End Class
این کد بالا یکی از فرم های من هست !
تا روی BUtton2 کلیک می کنم ، اررور می ده !