Visual Basic

15-Jul-07 6:33

Christian Graus wrote:
The people with good marks say things like 'I want a challenging project where I will learn new things and impress my teachers'. They're the people I would hire, also.

I agree. If some interviewer asks to see previous work done, I feel the interviewee should show a project that has a good degree of challenge to it. It would then show how skilled the interviewee is, and open up the interview to a potentially meaningful dialogue.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Export to excel

ravichand0413-Jul-07 21:50

ravichand04

13-Jul-07 21:50

I am using vb.net 2003. In my project the code is developed for netherlands using invariant culture. But at last they are exporting the data to excel using the culture info in default then the results in excel sheet is varying.

Please any can help

Ravichand.B

Re: Export to excel

Paul Conrad29-Jul-07 6:11

who i can bulid this query

29-Jul-07 6:11

I didn't see a question. What is the issue?

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

meromake13-Jul-07 7:57

meromake

13-Jul-07 7:57

Question onehttp://www.geocities.com/meromake/Advancedsql2.GIF[^]

Question two
http://www.geocities.com/meromake/advancedsql1.gif[^]

Dave Kreskowiak13-Jul-07 8:04

13-Jul-07 8:04

I'm not clicking on any Geocities links. Retype the questions in the forums here so there's at least some kind of trail to search on here at CP.

A guide to posting questions on CodeProject[^]

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

Paul Conrad13-Jul-07 9:07

13-Jul-07 9:07

Dave Kreskowiak wrote:

I'm not clicking on any Geocities links

Only thing there was the gif file...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Dave Kreskowiak13-Jul-07 9:14

13-Jul-07 9:14

Yep. Geocities used to be the 2nd biggest purveyor of filth, next to every other porn site on the planet. Now, not so much. But, that's why Geocities is blocked where I work! Wink | ;)

A guide to posting questions on CodeProject[^]

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

Paul Conrad13-Jul-07 9:21

13-Jul-07 9:21

Dave Kreskowiak wrote:
Geocities used to be the 2nd biggest purveyor of filth

I remember the days when I worked at a company called Log On Data Corp during the .com boom, and my job was to hunt down the filth and put it in their parental control database. Seemed like geocities was a kink gold mine so to speak...

To boost our QA productivity, we would just do a yahoo search with any "good" keywords and include geocities in it, then viola, we QA guys had our work cut out for the day (erm, sometimes the week Big Grin | :-D

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Dave Kreskowiak13-Jul-07 9:32

13-Jul-07 9:32

Wow! And I thought there were aspects of MY (current) job that sucked! Laugh | :laugh:

A guide to posting questions on CodeProject[^]

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

Paul Conrad13-Jul-07 9:42

13-Jul-07 9:42

Yeah, I stopped working there back in 1998 Big Grin | :-D

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Paul Conrad13-Jul-07 9:03

13-Jul-07 9:03

Like David said, type it in the forum. You can type out your three tables and the data.

---modified

Hints since I am not going to do it for you:

The first link, do a join on the dis_id, the second link, you have to do a sum on the field you want to total grouping by the Dis_id in the second table...

"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus

Re: vb.net-To save a file

Christian Graus15-Jul-07 5:59

Christian Graus

15-Jul-07 5:59

You want to do an inner join. Read up on some basic SQL ( probably buy a book ) and you'll find it's pretty easy.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

vb.net-To save a file

aswinanu13-Jul-07 7:30

aswinanu

13-Jul-07 7:30

hi,
i am doing a project in that with the help of the path a file should be saved
problem:

the path is given in the text box by clicking a button the file respected to the path should be saved in the particular place

Guffa13-Jul-07 7:34

Guffa

13-Jul-07 7:34

Why is that a problem? What is it that you need help with, exactly?

---
single minded; short sighted; long gone;

[Message Deleted]

Cory Kimble13-Jul-07 6:03

Cory Kimble

13-Jul-07 6:03

[Message Deleted]

Re: Changing color of text of one cell in DataGrid

Rupesh Kumar Swami13-Jul-07 6:49

Rupesh Kumar Swami

13-Jul-07 6:49

hi,
use following statement for change backcolor of cell
Dataqgridview1.Rows(1).Cells(2).Style.BackColor = Color.Aqua
and for fore color use following statement
Dataqgridview1.Rows(1).Cells(2).Style.forecolor = Color.Aqua

hope this helps

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

Re: Changing color of text of one cell in DataGrid [modified]

DanB198313-Jul-07 21:52

DanB1983

13-Jul-07 21:52

Hi
Assuming you are using the windows control (didnt check the asp.net one as I am lazy)

The syntax would be:

datagrid.Rows[ROW].Cells[CELL].Style.ForeColor = ________________

Hope this is of use

Dan

***Sorry this is for the datagridview control - if you are working on an old application let me know and i will look into this. If you can though I suggest using the datagridview control as it is the .NET2.0 version of a datagrid

-- modified at 3:57 Saturday 14th July, 2007

Access vb program via another program

billiardpro1813-Jul-07 5:04

billiardpro18

13-Jul-07 5:04

I would like to open a vb program I created using another program. The program I created is similar to the one I am currently using just with extra functions I needed that the OEM program did not provide.

I was wondering if there was a way that I could have the OEM program access my program so that I could operate my program from the OEM program.

Re: Access vb program via another program

Dave Kreskowiak13-Jul-07 6:03

Re: Access vb program via another program

13-Jul-07 6:03

Nope. The OEM app has to be rewritten to "access" your app and use the extra functions.

A guide to posting questions on CodeProject[^]

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

swallow4eva16-Jul-07 2:42

swallow4eva

16-Jul-07 2:42

what about this concept.

making one of your vb program executable then when trying to access the vbprogram from another vbprogram. use

'with an onclik event
shell "vbprogram1.exe";

helping someone is actually helping oneselk

Re: Passing parameter to hardcoded SQL statement (non Stored Procedure)

Christian Graus13-Jul-07 3:59

Christian Graus

13-Jul-07 3:59

Well, the main way would be stored procs, if you can't do that, then you can use parameterised querys. Last resort is to do some string mashing to pass in your parameter, but that opens you to SQL injection attacks.

uneasyrider wrote:
Dim strSearch As String
txtSearch.Text = strSearch

This sets your search string to an empty string, of course. It also means your db code is in your presentation layer, which means your app is poorly designed ( well, not designed at all, really ).

I suspect your main problem is that you're not putting '' around your search string.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: Passing parameter to hardcoded SQL statement (non Stored Procedure)

Dave Kreskowiak13-Jul-07 4:50

Re: Passing parameter to hardcoded SQL statement (non Stored Procedure)

13-Jul-07 4:50

I HATE when they delete their questions after getting a reply. I had a nice, and long, addendum to your post of grand wisdom and when I hit Submit, CP barfed and I couldn't go back and retry the post... Frown | :(

A guide to posting questions on CodeProject[^]

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

Paul Conrad15-Jul-07 5:45

Re: Passing parameter to hardcoded SQL statement (non Stored Procedure)

15-Jul-07 5:45

Dave Kreskowiak wrote:
hit Submit, CP barfed

Clean up on aisle six Laugh | :laugh:

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

Rupesh Kumar Swami13-Jul-07 6:53

Rupesh Kumar Swami

13-Jul-07 6:53

i dont understand where r problem in code project forms coding. SInce question is 45 min ago. & your answer is 2 hour ago. Also subject is different

Please note this bug

Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)

Re: Passing parameter to hardcoded SQL statement (non Stored Procedure)

Dave Kreskowiak13-Jul-07 7:00