Where to ask .NET DB questions?

Question

I have questios about datasets, binding, tableadapters etc. Where do I ask them? I didn't see a forum specific to it, so ask here.

I read MSDN and did the how-tos. In one it explains how to change the data shown on your form by allowing the user to enter a parameter. So, I've got to controls on my form now along with the data fields to be shown as labels. One is a navigator where you can walk through records and one is a box to enter a paramter to seatch by.

My problem is that if I seach by an ID the record shows up, but then the navigation control becomes disabled and I can no longer walk through records. How do I get the functionality of both at once? Do I need to have seperate views for each? One set of fields that you can walkthrough and another you can lookup using a parameter? It seems kind of silly to have two places to show data...

Also, how do I disable some of the functionality of the navigator control? For instance, I may not want a user to be able to delete a record....

Answer 1

I use a bit of a non-conventional way to achieve what you are asking...It goes like this...

1) Create the query
2) Create the SQL Command which contains the query
3) Issue the query via a DataAdapter fill. 
4) Bind the dataset to a datagridview to show the returned information
5) Allow the user to input a filter via a textbox
6) Use a dataview to filter the records...
7) You can use the dataadapter to update, insert and delete as well...based on the changes made to the dataset via the datagridview.

The other way entails using Databinding agents which I haven't used a lot.

---

Javaman

Answer 2

You can ask questions here:
ADO.NET DataSet

Helpful content:

ADO.NET Architecture

Provides an overview of the architecture and components of ADO.NET.

ADO.NET Technology Options and Guidelines

Describes the products and technologies included with the Entity Data Platform.

LINQ and ADO.NET

Describes how Language-Integrated Query (LINQ) is implemented in ADO.NET and provides links to relevant topics.

.NET Framework Data Providers (ADO.NET)

Provides an overview of the design of the .NET Framework data provider and of the .NET Framework data providers that are included with ADO.NET.

ADO.NET DataSets

Provides an overview of the DataSet design and components.

Side-by-Side Execution in ADO.NET

Discusses differences in ADO.NET versions and their effect on side-by-side execution and application compatibility.

ADO.NET Code Examples

Provides code samples that retrieve data using the ADO.NET data providers.

 Related Sections

What's New in ADO.NET

Introduces features that are new in ADO.NET.

Securing ADO.NET Applications

Describes secure coding practices when using ADO.NET.

Data Type Mappings in ADO.NET

Describes data type mappings between .NET Framework data types and the .NET Framework data providers.

Retrieving and Modifying Data in ADO.NET

Describes how to connect to a data source, retrieve data, and modify data. This includes DataReaders and DataAdapters.

Answer 3

Hi,
I redirect this post to appropriate forum for better support.

Thanks,

Eric

---

Please remember to mark helpful replies as answers and unmark them if they provide no help.

Answer 4

Hi Christopher,

For showing up the found record, it just depends on your design of code. If you can provide more details about it, we'll have better understanding of it. If you want to disable the functionnali of navigaotor, you can choose the icon and set its enable property of false or you can just delete it.

If you have any questions or concerns, please update the thread and we will have a further discussion.

Best Regards
Yichun Feng

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.

Answer 5

Mr. Javaman -- your methodology is NOT non-conventional. I do similar stuff (bind to DataSets/DataTables), and so do lots of others.

---

~~Bonnie Berent [C# MVP]

geek-goddess-bonnie.blogspot.com