473,387 Members | 1,892 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Generate a Table

Hi all,
I have to generate this table with the following structure in vb.net 2k5

col1 col2 col3
********************** 1
a ********** x******* 2
********** ******* 3
********** y ******* 4
********** ******* 5
b ********** p******* 6
********** ******* 7
c ********** z ******* 8

The data comes from the database from different tables and could write a query which gets data like this

a ******* x******* 1
a ******* x******* 2
a ******* x ******* 3
a******* y******* 4
a ******* y******* 5
b ******* p******* 6
b******* p******* 7
c******* z ******* 8

But i have to display in the above format. Can anybody give me idea to approach this.The data is dynamic in DB.
Mar 6 '08 #1
1 900
Frinavale
9,735 Expert Mod 8TB
Hi all,
I have to generate this table with the following structure in vb.net 2k5

col1 col2 col3
********************** 1
a ********** x******* 2
********** ******* 3
********** y ******* 4
********** ******* 5
b ********** p******* 6
********** ******* 7
c ********** z ******* 8

The data comes from the database from different tables and could write a query which gets data like this

a ******* x******* 1
a ******* x******* 2
a ******* x ******* 3
a******* y******* 4
a ******* y******* 5
b ******* p******* 6
b******* p******* 7
c******* z ******* 8

But i have to display in the above format. Can anybody give me idea to approach this.The data is dynamic in DB.
Could you please post what you have tried so far?
The table data that you have given in the above example is rather ambiguous and I'm not clear on what control you are using to display the data.

-Frinny
Mar 8 '08 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Terri | last post by:
I'd I have a problem I'd like to post CREATE TABLE and INSERT statements that will create my table and insert data into the table. I can use the scripting feature in Enterprise Manager to...
1
by: muesliflakes | last post by:
I'm trying to generate a normalized XML document out of SQL server that reflects the data structure of a table. Eg. This is what I would like to get <table name='MtFeedback'> <field...
6
by: Sebastien | last post by:
Hi, I am building a products database, linking sales and production. Each part has a unique sales Stock Code and Production Number. The sales stock code is a combination of letters and numbers...
2
by: Keith A. Rowe | last post by:
I have developed apps on scores of platforms for 25 years. Each of these platforms have supported a "quick, but not so dirty" utility for code table maintenance. For example, I have a States...
1
by: ASP.Net programmer | last post by:
I have a few SQLDataAdapters which select a MAX() value from a few different tables. Here is a sample of the SQL statement: SELECT MAX(startdate) AS startdate FROM some_table1 WHERE (startdate...
5
by: pete | last post by:
Help, I can not find this data wizard in my toolbox under data. To generate a dataset 1.. From the Data menu, choose Generate DataSet. Tip If you do not see the Data menu, click in the...
5
by: Hunter Hillegas | last post by:
I have a CSV file with 400,000 lines of email mailing list information that I need to migrate to a new PostgreSQL database. Each line has all the info I need except a PK (I usually use an int4...
0
by: ward | last post by:
Greetings. Ok, I admit it, I bit off a bit more than I can chew. I need to complete this "Generate Report" page for my employer and I'm a little over my head. I could use some additional...
15
by: Orchid | last post by:
Hello, I am looking to generate a unique ID field on MS. Access. The ID is with 10 digits with the combination of 5 Letters from the 26 letters and 5 Numbers from 1 to 9. The letters and numbers...
11
by: Alan Mailer | last post by:
A project I'm working on is going to use VB6 as a front end. The back end is going to be pre-existing MS Access 2002 database tables which already have records in them *but do not have any...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.