borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (String Function needed)Next Topic (migrate MS Access to Oracle) New Topic New Poll Post Reply
AndreaVB Forum : Database : generate reports using VB.Net
Poster Message
Aya
Level: Protégé

Registered: 31-01-2006
Posts: 8

icon generate reports using VB.Net

using VB5 or VB6, we generate reports using crystal report, then what about VB.Net?
help me...........plz...

____________________________
i love learning new things.....

02-02-2006 at 08:09 AM
View Profile Send Email to User Show All Posts | Quote Reply
GeoffS
Level: VB Lord


Registered: 29-09-2004
Posts: 536
icon Re: generate reports using VB.Net

Hi,
Crystal Reports is supported in VB.NET - infact it is included in the Pro Version.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

02-02-2006 at 08:46 AM
View Profile Send Email to User Show All Posts | Quote Reply
Aya
Level: Protégé

Registered: 31-01-2006
Posts: 8
icon Re: generate reports using VB.Net

ok, thanks. besides crystal report, is there another way to display the data from database?

____________________________
i love learning new things.....

04-02-2006 at 08:42 AM
View Profile Send Email to User Show All Posts | Quote Reply
Goran
Level: Moderator

Registered: 16-05-2002
Posts: 1681
icon Re: generate reports using VB.Net

For displaying data, you can use any grid control.

____________________________
If you find the answer helpful, please mark this topic as solved.

04-02-2006 at 08:37 PM
View Profile Send Email to User Show All Posts | Quote Reply
GeoffS
Level: VB Lord


Registered: 29-09-2004
Posts: 536
icon Re: generate reports using VB.Net

You can also use SQL-Server Reporting Services which is very powerful. I know it can convert existing MS Access Reports quite well, so I would guess that you might be able to do the same with Crystal Reports. But if you want something for fairly simple data reports then Gorans idea is best as you can create a Dataset in code, manipulate the data, add rows for SubTotals, Totals, or even blank lines, then bind the Datagrid control to display it.


____________________________
multi-tasking - the ability to hang more than one app. at the same time.

06-02-2006 at 08:46 AM
View Profile Send Email to User Show All Posts | Quote Reply
Aya
Level: Protégé

Registered: 31-01-2006
Posts: 8
icon SQL Server vs MySQL

Geoffs, you seem very familiar with SQL Server. actually i never use SQL Server, but i always hear it. when develop web based system, i used to work with MySQL. can you tell me the difference betw them...and how to use SQL Server. it sounds so interested.

____________________________
i love learning new things.....

09-02-2006 at 06:29 AM
View Profile Send Email to User Show All Posts | Quote Reply
GeoffS
Level: VB Lord


Registered: 29-09-2004
Posts: 536
icon Re: generate reports using VB.Net

Hi Aya,
The main differences between MySQL and Microsofts SQL-Server used to be MONEY and Operating Systems.
OS-wise MySQL runs on Unix (and similar) whilst SQL-Server needs a Microsoft OS. This may be a consideration if your ISP does not provide MS on their servers.
MySQL is available as shareware, but I believe that for the full enterprise level version you still have to pay something - I'm not sure. But with the introduction of SQL-Server 2005 in November last year Microsoft have made a freely available cut-down version which they call SQL-ServerExpress. Prior to this the cut down version of SQL-Server 2000 was called MSDE (MicroSoft Desktop Engine) which was really quite limited, but the new SQL-ServerExpress is very powerful and can be used not just as a desktop database engine but also in a Server/Client setup, there are obviously some restrictions (such as a maximum 2Gb. Database size) but it is now a very powerful DB Engine and it is freely available for re-distribution with your apps. It goes without saying that you can easily move up to the full SQL-Server (which now includes the ability to write code in VB.NET as well as T-SQL) if you need to - which you will to run Reporting Services. (RS is dead easy as the Wizard will help you create fairly comprehensive reports which can then be viewed by anyone on your LAN using Internet Explorer.) The great thing about Microsofts SQL-Server is that if you are writing in DotNET then everything is aimed at making it easy to use that DB for data access - (you can use others of course) - to such an extent that it is possible to create a simple data centric application connecting to SQL-Server without writing a single line of code.
As far as giving you an unbiased opinion as to which is best, I am afraid I can't do that. I do all my programming with Microsoft products, - they work for me, - but I would suggest that if you are using VB.NET then Microsofts SQL-Server is the best way to go. I have already given you the links for the free downloads in your thread on the DotNET Forum, so I would suggest you download them and have a play - you've nothing to lose, the're free!!
I hope that helps a bit.




____________________________
multi-tasking - the ability to hang more than one app. at the same time.

09-02-2006 at 08:40 AM
View Profile Send Email to User Show All Posts | Quote Reply
Aya
Level: Protégé

Registered: 31-01-2006
Posts: 8
icon Re: generate reports using VB.Net

Thanks a lot for your advices Geoffs. i'll do my best. of course ur suggestions are benefit to me. i'm very appreciate your advices.
l'll try as far as i can....


____________________________
i love learning new things.....

12-02-2006 at 05:16 AM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : Database : generate reports using VB.Net
Previous Topic (String Function needed)Next Topic (migrate MS Access to Oracle) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
Partners: Download Actual Software | Free Software Download
borderAndreaVB free resources for Visual Basic developersborder

borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2007 Andrea Tincaniborder