melissa_77
New member
- Joined
- Nov 3, 2008
- Messages
- 2
- Programming Experience
- Beginner
hi, I am new using VB.net
I confuse with how to connected
I'm using visual studio 2005
to connected I have 2 way
1.
with code , I must write
Dim conn As New OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\dbPoliklinikSamaria.mdb")
.
.
.
and then if I want to insert, update, delete, I use SQL command.
2
with datagridview. (at visual studio 2005 there's nothing oledbadapter component)
and then I connected with acess with datagrid component
and if I do insert,update,delete I use
TableAdapter.Connection.Open()
TableAdapter.Insert(TextBoxNoKartuPasien.Text)
TableAdapter.Fill(DbDataSet.TableName)
TableAdapter.Connection.Close()
...
and now my question is
I want use connected with way 2
but I want to use insert,update,delete with SQL command
how can I do that?
thx for the answer
I confuse with how to connected
I'm using visual studio 2005
to connected I have 2 way
1.
with code , I must write
Dim conn As New OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\dbPoliklinikSamaria.mdb")
.
.
.
and then if I want to insert, update, delete, I use SQL command.
2
with datagridview. (at visual studio 2005 there's nothing oledbadapter component)
and then I connected with acess with datagrid component
and if I do insert,update,delete I use
TableAdapter.Connection.Open()
TableAdapter.Insert(TextBoxNoKartuPasien.Text)
TableAdapter.Fill(DbDataSet.TableName)
TableAdapter.Connection.Close()
...
and now my question is
I want use connected with way 2
but I want to use insert,update,delete with SQL command
how can I do that?
thx for the answer
