Hi, I have a database and a dataset in C# application. The dataset has the list of my friends with phone number, address and a id. This is for learning purposes. I need to find the count of certain elements , say for example the total count of all the friends with ID > 3. How can I do that?
I have a database and a dataset in visual studio. I updated the database by adding two new columns to a table in the database. Then I updated the dataset using Configure Data Source With Wizard and everything is fine. But the problem is the order of the columns in the dataset. In the...
I am trying to learn database management system that exists in my company. I am new to this. So there are things that I have understood so far. I want to know what I understood is correct or not. So there is this Database which when I checked in Visual studio is of type Microsoft Sql...
I have some code for listing product names and corresponding categories, by using Data Sets :
created the Connection, Data Adapter, and Data Set
Filling the Data Set with the Categories table
Changed the command text and retrieve the Products table
Defining the relationship between Categories...