|
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
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
Why is that a problem? What is it that you need help with, exactly?
---
single minded; short sighted; long gone;
|
|
|
|
|
|
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)
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Nope. The OEM app has to be rewritten to "access" your app and use the extra functions.
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
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...
|
|
|
|
|
Dave Kreskowiak wrote: hit Submit, CP barfed
Clean up on aisle six
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
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)
|
|
|
|
|
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.
|
|
|
|
|
Yikes this is a mess. I am trying to follow through the Changing color of text... thread. Almost there
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
|
|
|
|
|
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)
|
|
|
|
|
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.
|
|
|
|
|
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 )
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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)
|
|
|
|
|
Thanks alot. It works.. But need to manipulate the working of normal File.ReadAllText(direct) and File.ReadAllText(direct, Encoding.Unicode)...
thanks a lot once again
|
|
|
|
|
how do i make a array and fill the listview1.groups.addrange(arrayname) with the array?
i want to add groups this way so i can sort the array and add the groups name in the right order: A-Z
i dont have a lot experience with arrays.
thanks for your help!
|
|
|
|
|
If you don't know anything about arrays, I highly suggest picking up a book on VB.NET and going through it. Without this basic knowledge, you're going to find most projects impossible to do.
Dim groupNames(2) As String
groupNames(0) = "Group2"
groupNames(1) = "Group3"
groupNames(2) = "Group1"
Array.Sort(groupNames)
For Each groupName As String In groupNames
ListView1.Groups.Add(New ListViewGroup(groupName))
Next
I've kept this example very simple. There's another method for creating a ListViewGroup array, that can be used with AddRange, that uses an Array's ConvertAll method, but you have to supply a Converter delegate and method to do the conversion from String to a ListViewGroup object. But, if you don't know arrays, this litte topic will not make any sense at all...
|
|
|
|