Displaying Specific Database Records in a Form (VB .NET)

[dheroan]

Hi there,

I'm fairly new to using databases with VB .NET. I'm currently working on an application using a Microsoft Access database as a data source. I have created a form to display the fields for each record in a particular table (using the feature that allows you to drag and drop a field from a table in the database onto the form, automatically attaching a BindingNavigator and TableAdapter and all that jazz to it). As you probably know, when the application is run the form will display all records in the table.

What I want to be able to do is find particular records in the table and display only these records on the previously mentioned form (there will be at least one record, but occasionally more).

I can successfully find the records I need from the database, but I can't seem to get the form to display only those records. Instead, it still displays ALL of the records in the table.

Currently, I am retrieving the relevant records from the database then storing them in an array of objects (and this works fine). I retrieve the row number of the first object in the array (I was just trying to get one working first) and then set the myBindingSource.Position property to that row number. However, this does nothing, and as I said the form still shows all of the records in the table (starting at the first record) rather than the required record. I'm also not sure how to go about limiting the number of records displayed.

I don't really know what options are available for me to get this working. I would appreciate any help at all at this stage.

Cheers,

dheroan

[dip_developer]

Hi there,

I'm fairly new to using databases with VB .NET. I'm currently working on an application using a Microsoft Access database as a data source. I have created a form to display the fields for each record in a particular table (using the feature that allows you to drag and drop a field from a table in the database onto the form, automatically attaching a BindingNavigator and TableAdapter and all that jazz to it). As you probably know, when the application is run the form will display all records in the table.

What I want to be able to do is find particular records in the table and display only these records on the previously mentioned form (there will be at least one record, but occasionally more).

I can successfully find the records I need from the database, but I can't seem to get the form to display only those records. Instead, it still displays ALL of the records in the table.

Currently, I am retrieving the relevant records from the database then storing them in an array of objects (and this works fine). I retrieve the row number of the first object in the array (I was just trying to get one working first) and then set the myBindingSource.Position property to that row number. However, this does nothing, and as I said the form still shows all of the records in the table (starting at the first record) rather than the required record. I'm also not sure how to go about limiting the number of records displayed.

I don't really know what options are available for me to get this working. I would appreciate any help at all at this stage.

Cheers,

dheroan

why are you not using sql???
a simple select query with your condition will do everything.......

take a DataSet(say ds)...fill dataset with a DataAdapter(say da).......Populate a Datagrid or Gridview or Table with your DataSet

i am giving you a code snippet in VB.NET..................

 
Dim sqlString As String="Select myrecord FROM myTable WHERE myColumn=myCondition"
da = New OleDbDataAdapter(sqlString , myConnection) 
ds = New DataSet
da.Fill(ds)
dg.DataSource=ds
dg.DataBind()