first..
i hve create combobox & text box and add database source to my project...
i know how to binding data or load data to combobox using SELECT query..
but can i change SELECT to INSERT query cz i wont when i type data into textbox,data will be in database...
second..
can i binding without add database to project..i mean mydatabase in debug folder..i hve problem binding data if database is not in myproject..
your post is not clear. i can't understand what do you want to do.
1. you want to insert data in textbox to database?
2. what kind of database?access?
3. how far you doing this?
my project 90% complete..
i using accessdatabse and put in debug folder..
i know hw to using insert statment..
ok i just to know,can i binding data to combobox if database on debug folder...
still not clear..where is your code? i even didn't know what type of database connection you're using to connected.
your program is 90% completed. so, binding data is not hard to you.
how to bind it? just select the field that you want to display on combobox, read data until the last record and finish.
this following code using oledb..modified as u needed.
Private Sub ReadData()
Dim con As New OleDb.OleDbConnection
Dim cmdAuthor As New OleDb.OleDbCommand
Dim dsAuthor As New DataSet
Dim daAuthor As New OleDb.OleDbDataAdapter
Dim dtAuthor As New DataTable
Dim i, k As Integer
' Got the debug path
con.ConnectionString = ("Provider = Microsoft.JET.OLEDB.4.0;Data Source=" & Application.StartupPath & "\Authors.mdb")
Try
cmdAuthor = con.CreateCommand
cmdAuthor.CommandText = "SELECT * FROM Authors "
daAuthor.SelectCommand = cmdAuthor
daAuthor.Fill(dsAuthor, "Authors")
dtAuthor = dsAuthor.Tables("Authors")
For i = 0 To dtAuthor.Rows.Count - 1
cmbAuthor.Items.Add(dtAuthor.Rows(i).Item(1))
Next
Catch ex As Exception
MsgBox("Error: " & ex.Source & ": " & ex.Message, MsgBoxStyle.OKOnly, "Connection Error !!")
End Try
con.Close()
End Subyes i using oOleDbConnectio
Dim conn As New OleDbConnection("provider=microsoft.jet.oleDB.4.0;Data Source=" & Application.StartupPath & "\mydatabase.mdb")
still not work...do i need to add database using add new source
not working?
can u tell where u put database file?
i mean the path of it..
i put in debug folder...
application.StartupPath refers to debug folder..
what the result of your startup execution?
if you feel hard to use application.startup then write your current address manually.
ex :
con.ConnectionString = ("Provider = Microsoft.JET.OLEDB.4.0;Data Source=C:\Documents and Settings\Ichigo\My Documents\Visual Studio 2008\Projects\WindowsApplication1\WindowsApplication1\bin\Debug\mydatabase.mdb")We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.