Member Avatar for saravanarajan

Hi everyone!
Please help me, I am beginner of the vb.net , I want know how to create dataset coding and
binding a textboxes,combobox and masked textbox pelase help me

  • 3 Contributors
  • 3 Replies
  • 122 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by saravanarajan

Dani AI

Generated

Good start: pointed toward a DataAdapter and demonstrated the basic control-binding that made it work for . For a more robust, beginner-friendly pattern use a BindingSource between your DataSet/DataTable and the controls. BindingSource centralizes the current record, simplifies navigation, and makes updates and null handling easier.

A concise VB.NET workflow (fill a DataTable, attach a BindingSource, then bind controls):

' fill and bind (example using SqlClient)
Using cn As New System.Data.SqlClient.SqlConnection("Data Source=.;Initial Catalog=MyDb;Integrated Security=True")
    Dim da As New System.Data.SqlClient.SqlDataAdapter("SELECT Id, Name, Phone FROM Customers", cn)
    Dim myDS As New DataSet()
    da.Fill(myDS, "Customers")

    Dim bs As New BindingSource()
    bs.DataSource = myDS.Tables("Customers")

    TextBoxName.DataBindings.Clear()
    TextBoxName.DataBindings.Add("Text", bs, "Name", True, DataSourceUpdateMode.OnPropertyChanged)

    ComboBox1.DataSource = bs
    ComboBox1.DisplayMember = "Name"
    ComboBox1.ValueMember = "Id"

    MaskedTextBox1.DataBindings.Clear()
    MaskedTextBox1.DataBindings.Add("Text", bs, "Phone", True, DataSourceUpdateMode.OnPropertyChanged, "")
End Using

Troubleshooting and tips:

  • Confirm the DataTable and column names exist (check myDS.Tables.Count and myDS.Tables("Customers").Columns).
  • Call DataBindings.Clear() before rebinding to avoid duplicate bindings.
  • Use DataSourceUpdateMode.OnPropertyChanged for immediate updates; call bs.EndEdit() to commit edits.
  • MaskedTextBox can need Format/Parse handlers to manage DBNulls or enforce mask formatting.
  • Always dispose connections/adapters (the Using block above does that).

For reference reading see the ADO.NET dataset overview and WinForms data-binding basics:
DataSet, DataTable, and DataView overview

Recommended Answers

All 3 Replies

Member Avatar for Jx_Man

you can use dataAdapter n generate dataset. or declare variable as new data set.

Member Avatar for emurf

Is this what you are looking for?

'declare the dataset
Dim ds As New DataSet

'bind to textbox
Me.textbox1.DataBindings.Add(New Binding("Text", ds, "Tablename.ColumnName"))

'bind combo
me.ComboBox1.DataBindings.Add(new Binding("Text", ds, "tablename.columnname"))

'bind the masked text
Me.MaskedTextBox1.DataBindings.Add(New Binding("Text", ds, "tablename.columnname"))

Member Avatar for saravanarajan

yes Its working thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.