database access

[john andrew]

--
hello
I have VB.net standard.
I thought this version has no data access but I have data controls .

Do these things work with standard?

Can i connect to a access database? I tried OLEadapter1 and a datagrid but
nothing happens when i click on datasource property like VB6...i dont know,
can anyone help please.

[Ken Tucker [MVP]]

Hi,

Click on the oledbdataadapte r1 in the properties you will see in the
bottom you will see generate dataset. After that wizard is finished you
will see the dataset in the datasource property of the datagrid. One last
step in the form load event you need to fill the dataset.

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load

DataSet11.Clear ()

OleDbDataAdapte r1.Fill(DataSet 11)

End Sub

Ken

-------------------------

"john andrew" <jo********@dis cussions.micros oft.com> wrote in message
news:D8******** *************** ***********@mic rosoft.com...

--
hello
I have VB.net standard.
I thought this version has no data access but I have data controls .

Do these things work with standard?

Can i connect to a access database? I tried OLEadapter1 and a datagrid but
nothing happens when i click on datasource property like VB6...i dont know,
can anyone help please.

[john andrew]

I have got a datagrid working, can I assign a datafield from a datasource to
a textbox like in VB6?

[john andrew]

"john andrew" wrote:

I have got a datagrid working, can I assign a datafield from a datasource to
a textbox like in VB6?

scrub that as i just found out what to do in databindings.

can I navigate like in VB6, move and add ect....can you do this?

[Ken Tucker [MVP]]

Hi,

TextBox1.DataBi ndings.Add("Tex t", DataSet11.Table s(0), "Country")

Ken

------------------------

"john andrew" <jo********@dis cussions.micros oft.com> wrote in message
news:A0******** *************** ***********@mic rosoft.com...
I have got a datagrid working, can I assign a datafield from a datasource to
a textbox like in VB6?

[john andrew]

"Ken Tucker [MVP]" wrote:

Hi,

TextBox1.DataBi ndings.Add("Tex t", DataSet11.Table s(0), "Country")

Ken

------------------------

"john andrew" <jo********@dis cussions.micros oft.com> wrote in message
news:A0******** *************** ***********@mic rosoft.com...
I have got a datagrid working, can I assign a datafield from a datasource to
a textbox like in VB6?


Thanks i will try it out,
How do I move next recprd for example? I n VB6 you have a recordset.( Where
can i find this information instead of asking so many questions)

[james]

In your declarations add:
Private bmb As BindingManagerB ase

Then in the section where you make your connection: (or in Form Load if you are not making your connection in code)
bmb = Me.BindingConte xt(Me.DataGrid1 .DataSource, Me.DataGrid1.Da taMember)

To step forward thru the records:

Private Sub btnNext_Click(B yVal sender As System.Object, ByVal e As System.EventArg s) Handles btnNext.Click

If bmb.Position < bmb.Count - 1 Then

bmb.Position = bmb.Position + 1

' add code here to change the display......su ch as textboxes etc. that you might have bound to the datagrid fields.

End If

End Sub

To move backwards:

Private Sub btnPrevious_Cli ck(ByVal sender As System.Object, ByVal e As System.EventArg s) Handles btnPrevious.Cli ck

If bmb.Position > 0 Then

bmb.Position = bmb.Position - 1

End If

' add code here to change the display......su ch as textboxes etc. that you might have bound to the datagrid fields.

End Sub

This should give you and idea on how it works.
Good luck.
james
"john andrew" <jo********@dis cussions.micros oft.com> wrote in message news:BC******** *************** ***********@mic rosoft.com...

"Ken Tucker [MVP]" wrote:

Hi,

TextBox1.DataBi ndings.Add("Tex t", DataSet11.Table s(0), "Country")

Ken

------------------------

"john andrew" <jo********@dis cussions.micros oft.com> wrote in message
news:A0******** *************** ***********@mic rosoft.com...
I have got a datagrid working, can I assign a datafield from a datasource to
a textbox like in VB6?

Thanks i will try it out,
How do I move next recprd for example? I n VB6 you have a recordset.( Where
can i find this information instead of asking so many questions)