how to fill dataset, as column wise instead of row wise in vb.net

Question

0.00/5 (No votes)

See more:

"Here i am filling dataset as a row wise but i want to add as coloumn wise how to do it? "
dim balrow as datarow

VB

balrow = obj.Tables("DB_COM").NewRow()"row wise adding instead of coloumn wise possible?"
                  balrow("ffri1") = Format(fdate, "dd/MM/yyyy")
                  balrow("fmonyear") = monthname + " " + tyear
                  balrow("fpname") = fname
                  balrow("fbankname") = gbankname
                  balrow("fbranchname") = gbranchname
                  balrow("fusername") = Guser
                  balrow("fworkstation") = worknode
                  balrow("fserverdt") = serverdt
                  balrow("fdate") = fdate
                  balrow("fpghead1") = fcsr
                  balrow("fpghead2") = fslr
                  '----------------------
                  Call rupee_con(BAL1)
                  balrow("bal1") = amtval
                  Call rupee_con(BAL2)
                  balrow("bal2") = amtval
                  Call rupee_con(BAL3)
                  balrow("bal3") = amtval
                  Call rupee_con(BAL4)
                  balrow("bal4") = amtval
                  Call rupee_con(BAL5)
                  balrow("bal5") = amtval
                  Call rupee_con(BAL6)
                  balrow("bal6") = amtval
                  Call rupee_con(BAL5)
                  BAL5 = CDbl(Val(amtval))
                  Call rupee_con(BAL6)
                  BAL6 = CDbl(Val(amtval))
                  BAL7 = BAL5 + BAL6
                  Call rupee_con(BAL7)
                  balrow("bal7") = amtval
                  Call rupee_con(BAL8)
                  balrow("bal8") = amtval
                  Call rupee_con(BAL9)
                  balrow("bal9") = amtval
                  Call rupee_con(BAL10)
                  balrow("bal10") = amtval
                  Call rupee_con(BAL11)
                  balrow("bal11") = amtval
                  Call rupee_con(BAL12)
                  balrow("bal12") = amtval
                  Call rupee_con(BAL13)
                  balrow("bal13") = amtval
                  Call rupee_con(BAL14)
                  balrow("bal14") = amtval
                  Call rupee_con(BAL15)
                  balrow("bal15") = amtval
                  Call rupee_con(BAL16)
                  balrow("bal16") = amtval
                  Call rupee_con(BAL17)
                  balrow("bal17") = amtval
                  Call rupee_con(BAL18)
                  balrow("bal18") = amtval
                  Call rupee_con(BAL19)
                  balrow("bal19") = amtval
                  Call rupee_con(BAL20)
                  balrow("bal20") = amtval
                  Call rupee_con(BAL21)
                  balrow("bal21") = amtval
                  Call rupee_con(BAL22)
                  balrow("bal22") = amtval
                  Call rupee_con(BAL23)
                  balrow("bal23") = amtval
                  Call rupee_con(BAL24)
                  balrow("bal24") = amtval
                  Call rupee_con(BAL25)
                  balrow("bal25") = amtval
                  Call rupee_con(BAL26)
                  balrow("bal26") = amtval
                  Call rupee_con(BAL27)
                  balrow("bal27") = amtval
                  Call rupee_con(BAL28)
                  balrow("bal28") = amtval
                  Call rupee_con(BAL29)
                  balrow("bal29") = amtval
                  Call rupee_con(BAL30)
                  balrow("bal30") = amtval
                  obj.Tables("DB_COM").Rows.Add(balrow)

Posted 27-Sep-15 20:29pm

lakshjoshi

Updated 27-Sep-15 20:39pm

v2

Add a Solution

Comments

Thava Rajan 28-Sep-15 3:25am

may i know why you need this?
and also i don't know why you declare this much of variables with 30 suffix
why don't you use it as an array?

lakshjoshi 28-Sep-15 3:37am

i am filling dataset to display separate values in crystal report i want to display values from dataset in coloumn wise like this
01/07/2015 02/07/2015 03/07/2015
0000000 111111111 22222222
0000 11111111 22222

its not showing 2 nd column data becase i am filling dataset by row so its filling other columns with same data so how to fill coloumn wise data in crystall report

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)

Thava Rajan · Accepted Answer · 2015-09-27T21:43:00

Solution 1

hope fully the following link will help to you

Datatable transpose[^]

Posted 27-Sep-15 21:43pm

Thava Rajan

Comments

lakshjoshi 28-Sep-15 3:57am

thank you i'll try....:)