Local DataBase Help

Question

Hello everyone,

I am making a project that saves the information recieved by a serial port in a database. Then the information must be sent to the table. And finally shown on a grid view.

I have seen local data tutorials but they add data manually by a Binding Navigator and by a Data Grew View, but how is it possible to add data automatically by code?

Thanks,

Albert

Answer 1

Albert,

How are you setting up your database? Are you using the Wizard? If so it will add a DataSet, a BindingSource, and a TableAdapter.

Adding data to it is pretty simple:

Dim nr As MyDataSet.MyDataTableRow = MyDataSet.MyDataTable.NewMyDataTableRow

With nr
    .MyField1 = whatever
    .MyField2 = whatever
    .MyField3 = whatever
End With

MyDataSet.MyDataTable.Rows.Add(nr)

If MyDataSet.MyDataTable.GetChanges IsNot Nothing Then
    ' Now use the table adapter's .Update method
End If

Obviously pseudo-code but hopefully that's close.

---

Please call me Frank :)

Answer 2

Thank you very much!

This is what I was looking for. Now I'm working on table adapter's, as I never worked with it before, but seems easy. Thank you again!

Albert

Answer 3

Thank you very much!

This is what I was looking for. Now I'm working on table adapter's, as I never worked with it before, but seems easy. Thank you again!

Albert

Glad it helped!

---

Please call me Frank :)

Answer 4

I did it and it works perfect! :)

I have another question. All columns are numeric, except one, that is datatime. It is showed in my form as a DateTimePicker. What I want to do is that when I pick a date, all other columns show all the data of that day. Is that possible?

Answer 5

I did it and it works perfect! :)

I have another question. All columns are numeric, except one, that is datatime. It is showed in my form as a DateTimePicker. What I want to do is that when I pick a date, all other columns show all the data of that day. Is that possible?

Well, first off - another question needs to be just that, another question in the forum.

It sounds like you're describing filtering of data and sure that's possible. When you form your new question, please be sure to show what you have (the pertinent code) and what you're trying to accomplish. A few screenshots would be helpful also.

---

Please call me Frank :)

Answer 6

Sorry man, I have already posted a new question!