Adding columns to DataSet

Question

0.00/5 (No votes)

See more:

, +

I am gathering a set of information from users and they are : name,rollnum,fathername,dept,branch,Sem and gender. When user enters this information and click button SubCode, SubTitle has to be fetched based of Dept,Branch and Sem entered by the user from the other table for which I have written a Query and it is working fine.
Defination of table (TblSub)

HTML

SubCode   |SubTitle         |Dept              |Branch           |Sem
C1        C Programming      Computer Science  Computer Science   1
J1        Java Programming   Computer Science  Computer Science   1
J1        C++ Programming    Computer Science  Computer Science   2

Now my main problem is I want to display (rollnum,Name,Fathername,SubCode,SubTitle) in a gridview.
Output of the gridview has to look like this when user select dept=branch=Computer Science and sem = 1

HTML

rollnum     |Name    |Fathername   |SubCode   |SubTitle 
01           stud1    father1        C1        C Programming
01           stud1    father1        J1        Java Programming

The number of subcode differs to each student based on the dept,branch and sem they select. I tot of using dataset where I will 1st enter rollnum,name,fathername and then add column subcode and subtitle column wise. But as the number of subcode differs for each student I not getting how to achieve this. I will be glad to know if there is any other way other then dataset which is more convenient in using. Please help. Thank you.

Posted 5-Jun-15 20:43pm

partha143

Updated 5-Jun-15 20:52pm

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Shrikesh_kale · Answer 1 · 2015-06-05T20:57:00

C#

static DataSet ds_input = new DataSet();
static DataSet ds_output = new DataSet();

private static void InitializeMyDataSet()
{
    ds_output.Tables.Add(new DataTable() );
    ds_output.Tables[0].Columns.Add("column_1", typeof(string));
    ds_output.Tables[0].Columns.Add("column_2", typeof(string));
    ds_output.Tables[0].Columns.Add("column_4", typeof(string));
    ds_output.Tables[0].Columns.Add("column_3", typeof(string));
}