Re: Reports In VB.Net 2005 Express - Visual Basic Discussion Boards

Message Closed

23-Mar-09 6:02

vijay2482

23-Mar-09 6:02

Message Closed

Re: Compare Text File and Fetch from Database

scottgp23-Mar-09 6:37

scottgp

23-Mar-09 6:37

The fact remains that you did not ask any specific questions, so it's not clear what answer you are expecting.

For reading the text file, you may want something like System.IO.File.ReadAllLines.
That gives you an array of strings. It should be easy to move through the array, and parse out each string to obtain the first 'column', although you didn't specify how they are delimited.
Then you'll need some ado.net to query the database, and again some System.IO.File related classes to write out to the text files.

You didn't provide much detail, so I can't provide anything more specific.
Scott

Re: Compare Text File and Fetch from Database

dan!sh 23-Mar-09 6:28

dan!sh

23-Mar-09 6:28

There are several ways to read and write the data to file. Search web and you will find lots of samples.

जय हिंद

Re: Compare Text File and Fetch from Database

Jon_Boy23-Mar-09 6:31

Jon_Boy

23-Mar-09 6:31

Honestly, 2 - 4 don't make sense to me. Maybe it's a lack of caffeine today on my part.

Post your code so we can see what you're attempting to do.

Any suggestions, ideas, or 'constructive criticism' are always welcome.

"There's no such thing as a stupid question, only stupid people." - Mr. Garrison

Reports In VB.Net 2005 Express

nishkarsh_k23-Mar-09 4:15

nishkarsh_k

23-Mar-09 4:15

Hello every one,

I am using VB.net 2005 Express to make a application.

My client keeps me asking some or the other new report. We are code each report and display in grid. After this again print each line as per client's desire.

I want to find a better way to manage reports (Like a report builder). I did a bit of googling around and got really confused.

Can any one plz help me out with some link of something in the above direction

Regards
Nishkarsh

Re: Reports In VB.Net 2005 Express

Dave Kreskowiak23-Mar-09 9:13

Dave Kreskowiak

23-Mar-09 9:13

Try Crystal Reports. The Express Editions of Visual Studio don't come with the reporting goodies that the full versions do.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: Reports In VB.Net 2005 Express

nishkarsh_k23-Mar-09 18:11

nishkarsh_k

23-Mar-09 18:11

Thanks for the input. Do i need t get (buy) Crystal Reports?
I had tried using a report utility available in Sharp Develop 2.2, any idea what is that all about? I tried googeling for it did not get almost any thing on it...

Regards
Nishkarsh

Re: Reports In VB.Net 2005 Express

Dave Kreskowiak24-Mar-09 1:44

Dave Kreskowiak

24-Mar-09 1:44

nishkarsh_k wrote:
Do i need t get (buy) Crystal Reports?

Yes.

nishkarsh_k wrote:
I had tried using a report utility available in Sharp Develop 2.2, any idea what is that all about?

I've never used SharpDevelop.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

TextBox value with Table value

vijay248223-Mar-09 0:12

vijay2482

23-Mar-09 0:12

modified 28-Nov-12 9:04am.

Re: TextBox value with Table value

Eddy Vluggen23-Mar-09 0:19

Eddy Vluggen

23-Mar-09 0:19

I'm sure that this is just a typo;

cmd = New OleDbCommand("select ITEM_NBR,NPR_DC_NBR,NPR_NBR from E_Ensemb where ITEM_NBR =" + a, cn)

Are you getting an error? If not, does the query return results if you run it manually?

I are troll Smile | :)

Message Closed

23-Mar-09 0:46

vijay2482

23-Mar-09 0:46

Message Closed

Re: TextBox value with Table value

Eddy Vluggen23-Mar-09 0:49

Eddy Vluggen

23-Mar-09 0:49

Does the code say

ITEM_NBR" = a,

ITEM_NBR =" + a,

I are troll Smile | :)

Message Closed

23-Mar-09 0:53

vijay2482

23-Mar-09 0:53

Message Closed

Re: TextBox value with Table value

Eddy Vluggen23-Mar-09 1:05

Eddy Vluggen

23-Mar-09 1:05

I do hope that you are executing the entire SQL-statement, and not just the piece that I pasted in the previous post Smile | :)

cmd = New OleDbCommand("select * from E_Ensemb where ITEM_NBR = '" + a + "'", cn)

How does the SQL statement look if you do it manual? Something like this?

select * from E_Ensemb where ITEM_NBR = '1856977M3'

I are troll Smile | :)

Message Closed

23-Mar-09 1:21

vijay2482

23-Mar-09 1:21

Message Closed

Re: TextBox value with Table value

Eddy Vluggen23-Mar-09 3:57

Eddy Vluggen

23-Mar-09 3:57

You're welcome. This is a new question actually, and a lot people won't read it, since it looks like the original question has been answered. New question -> new post Smile | :)

The UNION can be used to combine result-sets, but only if they have the same amount and type of columns. This is allowed:

SELECT 1, 'hello'
 UNION
SELECT 2, 'world'

results in:

1, 'hello'
2, 'world'

This isn't allowed:

SELECT 1, 'hello'
 UNION
SELECT 2

results in:

1, 'hello'
2, ???

In the latter version SQL server can't "add" the rows into a single set, as they're two different things.

My guess is that you're looking for a JOIN type statement. Do the tables have a corresponding field? Iow, do the tables have a field in common?

I are troll Smile | :)

project on college management system.

p_m_kanthi22-Mar-09 23:20

p_m_kanthi

22-Mar-09 23:20

i need a project with source code on "college management system" which is used by principal,office staff and librarian..
i need it as early as possible...

Re: project on college management system.

Eddy Vluggen23-Mar-09 0:06

Eddy Vluggen

23-Mar-09 0:06

p_m_kanthi wrote:
i need a project with source code on "college management system" which is used by principal,office staff and librarian..

Is this..
..homework?
..a job-assignment?

Do you want..
..an application that does these things?
..sourcecode to do these things?

p_m_kanthi wrote:
i need it as early as possible...

In that case you better start searching as soon as possible Smile | :)

I are troll Smile | :)

Re: project on college management system.

Dave Kreskowiak23-Mar-09 3:45

Dave Kreskowiak

23-Mar-09 3:45

So, when you get out into the real world and get saddled with programming projects, or other projects for that matter, you're just going to go to a website and ask for someone elses work and turn it in as your own?? How much money do you expect to make in a position like that?? Better yet, how long do you think you're going to be employed?

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Re: project on college management system.

0x3c023-Mar-09 5:49

0x3c0

23-Mar-09 5:49

Of course. Post your email address and I'll email it to you. In fact, if you post your principle's and teacher's email addresses, I can even email it to them as well! That way, you can save time distributing your application