Visual Basic

Re: who i can bulid this query

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

Re: who i can bulid this query

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

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

Re: vb.net-To save a file

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

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

13-Jul-07 7:00

This happened because the original poster deleted his question, thereby orphaning the replys he got. It's a known issue and won't be fixed until the next release of the CodeProject web site.

A guide to posting questions on CodeProject[^]

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

Paul Conrad15-Jul-07 5:47

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

15-Jul-07 5:47

Yikes this is a mess. I am trying to follow through the Changing color of text... thread. Almost there Laugh | :laugh:

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

Rupesh Kumar Swami13-Jul-07 6:54

Rupesh Kumar Swami

13-Jul-07 6:54

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

Please note this bug

Also note that i reply christian but this reply add to Dave Note this thing

-- modified at 12:59 Friday 13th July, 2007

-- modified at 13:00 Friday 13th July, 2007

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

Help! Read Unicode Text File to VB program

jackie83sg200513-Jul-07 2:58

jackie83sg2005

13-Jul-07 2:58

Hi,

I am using Visual Studio 2005's Visual Basic developer. I have a problem that i need to extract the unicode from a text file to my progam. And normal character have not a problem but when come to a certain extent of the unicode set, it prompt a error saying that it is invaild.

Here is my code:

OpenFileDialog1.ShowDialog()
Dim direct As String
direct = OpenFileDialog1.FileName
Dim fs As FileStream
fs = New FileStream(direct, FileMode.Open)
Dim sr As StreamReader
sr = New StreamReader(fs)
Dim n1 As Integer
Dim s1(100) As Char
Dim n2 As Integer
n2 = 0
While sr.Peek >= -1
n1 = sr.Read()
s1(n2) = Chr(n1)
n2 += 1
End While

my input is this unicode, §. So when it read from file to here, it prompt the error. So please help me...!

Thanks and Regards,
A person who don't whether he is a newbie or novice. Smile | :)

Christian Graus13-Jul-07 3:29

Christian Graus

13-Jul-07 3:29

jackie83sg2005 wrote:
Dim s1(100) As Char
Dim n2 As Integer
n2 = 0
While sr.Peek >= -1
n1 = sr.Read()
s1(n2) = Chr(n1)
n2 += 1
End While

Wow - what a mess.

1 - why do you limit yourself to 100 characters, instead of using a List or something ?
2 - why do you read one character at a time ?

File.ReadAllText will read an entire file in one line of code.

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 )

Paul Conrad13-Jul-07 4:29

13-Jul-07 4:29

Christian Graus wrote:
Wow - what a mess.

Just imagine maintaining it in the future :->

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

jackie83sg200513-Jul-07 4:50

jackie83sg2005

13-Jul-07 4:50

Hi,

thanks for commenting my previous program. I know that it is really in a WOW mess.

I try you method but I still have the unicode conversion problem that I posted in the first thread.

I appreciate your help. I have shorten the whole program as follows:

OpenFileDialog1.ShowDialog()
Dim direct As String
direct = OpenFileDialog1.FileName
Dim str As String
Dim adder As Integer
Dim reader As Integer
reader = 0
adder = 0
str = File.ReadAllText(direct)
reader = str.Length
Do While (adder <> reader)
Try
ComboBox1.Items.Add(str.Chars(adder))
adder += 1
Catch ex As Exception

End Try
Loop

So please help mi from the unicode's ASCII index is 167 after conversion. It is simple when you type in the unicode in to the windows form but I try to retrieve from file. WoW, it is very different and difficult, so need you people out that who is experted in it to help me out...

Thanks and Regards,
A person who do not know whether he is a newbie or novice.

Dave Kreskowiak13-Jul-07 4:54

13-Jul-07 4:54

What does the code look like that wrote the file?? Maybe it's not really Unicode where you think it is.

Or, there's another possilibity. Change the ReadAllText line to:

Imports System.Io
Imports System.Text

.
.
.
 
    str = File.ReadAllText(direct, Encoding.Unicode)

A guide to posting questions on CodeProject[^]

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