|
I am basically very new to VB.Net and I'm having problems with concerning datagrids.
I am loading a datagrid with information queried from a database. I then want to access that information within the datagrid so I can perform calculations. Can anyone point me in the right direction?
|
|
|
|
|
email me ...nerushanmoodley@yahoo.com. will help you wit code
|
|
|
|
|
I am using a multiline textbox in my application. I write the data from the textbox to a multiline cell within a spreadsheet. Everytime the user hits enter within the textbox to drop to the next line, a square wingding appears at the end of each text within the cell.
I thought this could be an easy fix. So, I did a search to find the wingding within the corresponding column. However, to my surprise, it doesn't seem to be a registered wingding. It is something else.
When I copy the data, not the cell, to another cell, each item is put into its OWN cell. It is registering this geometric shape as the "ENTER" key. Any help would be greatly appreciated. Thanks.
Dizzle
|
|
|
|
|
You're not seeing a wingding. You're seeing a character that Excel doesn't use and the font Excel is using doesn't have any image for that character.
You're also assuming that the NewLine character sequence in VB is the same as Excel's. VB's default NewLine sequence is Carriage Return, move cursor to the beginning of the line, follow by a Line Feed, advance the paper up one line. Excel doesn't use this sequence in its worksheets. You're sending an extra character that Excel doesn't have a use for.
Before you send the textbox data to the Excel sheet, you need to replace either the CR or LF characters in your string with either just CR (vbCr) or just LF (vbLf). I can't remember which one Excel uses. You just have to try it.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This is the only line of code I have to move the data to the appropriate cell:
ws.Cells(iRow, 4).Value = Me.TextBox1.Value
In the TextBox1 properties I have simply set it to multiline and allowed the user to step to each line by hitting "enter."
I understand what you are suggesting. However, I tried it when I was using A listbox. It did not work then either. I had to do what I am "trying" to do with a textbox. The difference is, the textbox "items" are not seperated by "selection." They are seperated by the user hitting "enter" and stepping to the next line. When I use vbNewLine or vbCrLf it displays the same character.
Thanks a lot for your suggestions. However, do you have any other ideas?
Dizzle
|
|
|
|
|
Like I said, you can't use CrLf! You can only use Cr OR Lf between lines. I don't know which one Excel uses off the top of my head.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi
I had recently posted this, but I did not get the answer. Because I DO really need this problem to solve, I repeat it.
In vb6 I have an ImageList that a ListView is bound to it. It works quite fine when dealing with small (up to 1000) number of images. but when the number of images becomes larger, my program suddenly crashes: "This program has performed an illegal operation."
The code I used, is here:
<br />
It's in vb6.<br />
It is in a function that gets FilePath and adds it's icon to the ImageList.<br />
<pre><code><br />
hIcon = ExtractAssociatedIcon(0, LCase(FilePath), 1)<br />
If IsNull(hIcon) Then<br />
'Error <br />
Else<br />
Set Pic.Picture = Nothing<br />
DrawIcon Pic.hdc, 0, 0, hIcon<br />
Pic.Picture = Pic.Image<br />
End If<br />
ImageList1.ListImages.Add , , Pic.Picture<br />
GetImageLisIconIndex = ImageList1.ListImages.Count<br />
It is in a function that gets the FilePath and adds its icon to the ImageList.
Thanks in advance.
|
|
|
|
|
MohammadAmiry wrote:
I had recently posted this, but I did not get the answer.
Perhaps because you have no patience? I just got the email that said you replied to my post today!
Looking at your code, your calling ExtractAssociatedIcon, but I don't see any code that destroys the Icon handle when you're done adding it. DestroyIcon[^]
This COULD be the cause of your problem.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi
Sorry for not being so patient. This is because I am in really shortage of time.
And thanks for the reply. 
I had totally missed to destroy the Icons.:->
I tried what you said but still got my app crashed when the number of files gets a little up 1000!(This time 1032)
Is there anything else I should do?
-- modified at 17:55 Monday 29th August, 2005
|
|
|
|
|
Make sure there's nothing else you missed pairing up elsewhere in the app. I've never put that many items in an ImageList before, so I can't really speak from experience.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi
I tried more. now that I destroy the Icons, an Overflow error occurs when the number gets more than (about 1800) on the ImageList1.Add ... line.
I was interested to see if this problem happens for all applications using an imagelist to lead to an overflow. So i used a windows search with * criteria to check that when there is large number of files in a listview (which is for the case of windows search) and the fact that icons in a listview should be in an imagelist, to see if the oveflow occurs. But it didn't!
I checked my code so many times. I don't think I have missed anything else.
Is it the end and I cannot do anything with the overflow problem?
|
|
|
|
|
MohammadAmiry wrote:
and the fact that icons in a listview should be in an imagelist,
WHOA! Stop right there! This is not a fact! This is an assumption. You're assuming that the images are kept in am Imagelist. I personally hate the ImageList control and avoid using it whenever possible. If I were to keep that many images, I'd write my own class and ownerdraw each line of a ListView to show them.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Oh! I guess I have to write my own class!
But if you'd read my other note here, I checked the ImageList, really why it can't hold that much of items?
Or you want to insist that Listviews used in windows ARE all ownerdrawn?
|
|
|
|
|
I finally used the following code to see if the problem is really with the ImageList control or not:
<br />
Do<br />
ImageList1.ListImages.Add , , LoadPicture("f:\1.ICO")<br />
i = i + 1<br />
Loop<br />
And it raised an overflow error when adding i=2800
WHY is so?
I checked that windows, can have a listview containing more than 5000 items (each icon should exist in an imagelist, shouldn't it?).
So if that is possible, what about my app?
|
|
|
|
|
Hi, I am investigating on how Visual Basic 6 could fully support Farsi Characters. I have heard that there are some characters which are not supported. Although I dont know which ones they are. Could anyone help me?
SDE
|
|
|
|
|
If your OS supports Fasi language, it hase no problem with that. I had used vb6 to write a Farsi Language program. It worked under windows XP quite well and also under windows 98 with right-to-left and Farsi language support.
But you may have a little problem when dealing with some controls that do not support right-to-left.
|
|
|
|
|
Hi. Thanks for the response. MOst of the controls I'm using supports Arabic Right-To-Left. However, I am wondering whether there is a difference with Arabic and Farsi support. I guess there are some characters in Farsi which are not supported by Visual Basic 6. Have you heard of this issue? Thank you.
SDE
|
|
|
|
|
Hi
As you may know, there are only 4 characters in Farsi that are not included in Arabic and the other characters are identical. And as I previously mentioned, VB has got nothing to the characters.
What you have heard may be because of Arabic fonts used. Yes, there are some Arabic fonts (that do not support the characters related to letters گ چ پ ژ)
so it is just related to the fonts you use, and not a matter of VB.
|
|
|
|
|
Hi,
Thanks for the information. How bout Shamsi dates? I have been looking information about it. I wanted an introduction to it on how it would affect my app... Do you have any article you could recommend? Thanks.
SDE
|
|
|
|
|
Is there an easy way to freeze columns in a VB.Net datagrid. If so how is this done or can some one point me in the right direction of any information. Basically I want to freeze the first 2 columns in a datagrid.
Thanks in advance
|
|
|
|
|
Hello!
For freezing the coloumns you can use the READONLY property of datagrids.
For this you have to create a datagrid style, create DataGridTextBoxColumn and then add DataGridTextBoxColumn to the style...
Each DataGridTextBoxColumn can be Readonly or Non Readonly.
Check out the following code snippet..
dsData is the dataset that contains a table.
Dim dgStyle As New DataGridTableStyle
Dim datacol As DataColumn
Dim dgcol As DataGridTextBoxColumn
For Each datacol In dsData.Tables(TableName).Columns
If Condition Then
dgcol = New DataGridTextBoxColumn
dgcol.MappingName = datacol.ColumnName
dgcol.HeaderText = datacol.Caption
dgcol.ReadOnly = True
end if
dgStyle.GridColumnStyles.Add(dgcol)
Next
dgStyle.MappingName = dsData.Tables(TName).TableName
Me.DataGrid.TableStyles.Add(dgStyle)
The above code will make the columns readonly depending on the condition.
You can give the condition dependin on clumn name e.g
CONDITION==>datacol.ColumnName = "Title Of Column"
I hope this will solve ur problem
_mubashir
|
|
|
|
|
easily, you can use janus system grid.
|
|
|
|
|
I have sucessfully deteected the net connection whether it is connected or not but i am not able to popup the dialer if disconnected. How can i bring ip the dialer.
Also i have detected only for modem how can i detect connection through cable or other medium.
|
|
|
|
|
Hey folks, i got a problem...
i got a third party app randomly connecting to 200 different servers.
All servers got a fixed IP that i know.
Now i want that app to only connect to a defined server, lets say server 120.
Is there an possibility to redirect all the other server ips to the ip of server 120?
I don't know if the app has to resolve the ip first but it seems so already tried to manipulate the "hosts" file but the app doesn't care...
If you got any idea pleas let me know... even if its as silly as hell 
thanks
|
|
|
|
|
Randomly connects to servers??? What kind of an app is this? It sounds liek you're trying to trick the software into connecting to a specific server because it's a trial version.
Depending on how the app is getting the server names and resolving them, you may not have any options to solve this. What is this utility and what kind of servers is it used for?
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
