|
I have one last line of code to write then this project is complete. I have spent 2 weeks on this "Last Line" .... 
Trying to read the contents of a datagrid to Excel:
This works if the column is simply a bound column:
For i = 0 To StatusGrid.Items.Count - 1
worksheet.Cells(i + 2, 1) = StatusGrid.Items(i).Cells(1).Text()
Next
However, for Template columns, the following SHOULD work, but does not:
For i = 0 To StatusGrid.Items.Count - 1
worksheet.Cells(i + 2, 2) = CType(StatusGrid.Items(i).Cells(2).Controls(0), DataBoundLiteralControl).Text()
Next
I get the following error:
Unable to cast object of type 'System.Web.UI.LiteralControl' to type 'System.Web.UI.DataBoundLiteralControl'.
I am at my wit's end on this one... Can anyone help?
|
|
|
|
|
I want to send email out through my application.
I found a way using System.Web.Mail but when I make a reference to it I get the blue jagged under line. I think its because I'm missing the proper dll? I have Windows XP Home edition and Visual Basic Standard edition. How can I get this to work or are there other options?
Thanks again.
|
|
|
|
|
Did you set a reference to the System.Web.dll? If not, right-click the References folder of your project, then click Add Reference. Find the System.Web.dll file, then double-click it, then click OK.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I have an Combobox at the right bottom edge of the form
I want that the combo box should not drop down
means when I click on combo box it displays the content only within the form not outside the form
So that if there is no space at Right bottom edge of the form it opens the items at above the combo box
Thax in advance
|
|
|
|
|
I assume when you are saying combobox you are refering to windows forms and not webforms. This is what you need to do.
change the the combobox MaxDropItems property to your needs.
Mandar Patankar
Microsoft Certified professional
|
|
|
|
|
I assume when you are saying combobox you are refering to windows forms and not webforms. This is what you need to do.
change the the combobox MaxDropItems property to your needs.
Mandar Patankar
Microsoft Certified professional
|
|
|
|
|
No i want if there is no space for combo/DropDown List to open at down
it should drop the List in upward direction
I hope u understand & reply
Thanx
hema_chaudhry
|
|
|
|
|
that means i want to drop combo box Up
hema chaudhry
|
|
|
|
|
I am encountering ExecutionEngineException and Null ReferenceException errors when opening a new form immediately after closing another form. The new form appears not to have enough memory to open. I have tried using Dispose on the closing form, but it has not helped. Anyone have any suggestions?
|
|
|
|
|
This shouldn't be a problem with just a form object. I would think that it is because of a component or some other code behind that form. Forms themselves really don't take that much memory.
Are you using ShowDialog to show forms? Are you calling Dispose on anny form that you use ShowDialog to show? If not, you're actually not releasing these forms and they are taking up memory and, more importantly, handles. If you run the system handle pool into the ground, you can get memory errors.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi,
I have a VB6 application which can raise events in other Windows app's via an ActiveX exe (Similiar to the coffeewatch components in VB6).
I have a requirement to link the application to a Unix based application. Is there a way of raising events in Unix based applications from Windows?
Thanks,
Lee.
|
|
|
|
|
There's no direct way of raising events on the Unix side from Windows. You'll have to write a component on the Unix side that listens to an IP port to receive events from the windows side, kind of client-server setup. How you integrate this into your project is up to you.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Is it possible to make a checkbox property read only?
There is no property for read only for a checkbox.
|
|
|
|
|
What is the purpose is making it read only?
You can make it disabled - Checkbox.Enabled = False.
You might want to consider using a different control in order to get the control that you desire or create your own custom checkbox but that is another story entirely.
Cleako
-- modified at 15:49 Tuesday 4th October, 2005
|
|
|
|
|
I actually came across a problem just like this in my Advanced Programming using visual Basic Class. The problem required us to use check box's as a form of displaying information. (I.E. Does this room have a fireplace [x]checked) So there is use for a read only check box in this sense.
|
|
|
|
|
I am using a checked list box having some values.
Now i want to get all the values from the checkedlistbox
indexChecked = chkAlertCode.Items.Count
For intq = 0 To indexChecked - 1
MsgBox(chkAlertCode.GetItemText(intq))
Next
but i am not getting the text instead i am getting the index. how can i get the text.
|
|
|
|
|
use the following code instead.
Dim i As Integer<br />
For i = 0 To ckList.Items.Count - 1<br />
MsgBox(ckList.Items(i))<br />
Next
_mubashir
|
|
|
|
|
it give me error
System.InvalidCastException: Cast from type 'DataRowView' to type 'String' is not valid.
|
|
|
|
|
plz list the code u r using
_mubashir
|
|
|
|
|
hay all,
i currently have the problem while assigning a dataview with a filled table the first time. ok, in short:
in a winform a have a dataview, a typed dataset and a combobox. the combobox's datsource is the dataview. the dataview's table is a table of the dataset. on startup of the application an other dataset of the same type will be filled with data. after showing the form i assign the dataview's table with a table of the preloaded dataset. doing this the first time this takes about 30 seconds !!! if i do it a second time it works fine. i tryed to set the "dataview.table = nothing" before assiging it with the filled table but no changes happend. if i run the command in the commandview of vs it works also fine. it's the same behaviour if the code runs the normal way or i run it by single step.
any idea?
tnx, bernd
if you need code snippes, let me know
|
|
|
|
|
I am writing a software to be installed on the client computer and listens to a port number then by setting the proper config in IE , all the requests from the browser will be redirected to this application and after that the application will redirect the request to a proxy server. Please sont ask "why the browser doesn't directly conect to the proxy server?" because I have my reasons.
I am using TcpListener,Socket and TCPClient objects.
the Socket object is responsible to exchange data between the browser and application using the TcpListener and will be closed after the complete proccess.
the TCPClient object is responsible to transfer the Socket requests to proxy server and to redirect the proxy server responses to the Socket. It is so easy.
But some bad things happends and I dont know why 
running the application and debuging the application will represent different way of doing the job. for example in following code :
<br />
.<br />
.<br />
.<br />
1 Dim Counter2 As Integer<br />
2 Do<br />
3 Dim hBuffer As Byte() = New Byte(tcpc.ReceiveBufferSize - 1) {}<br />
4 <br />
5 'Get response of previously sent data from the proxy server<br />
6 'I also used tcpc.getstream and got the same result<br />
7 'tcpc as TCPClient<br />
8 'ofcourse TCPClient doesnt have Socket object for public I used my own<br />
9 'class witch was drived from TCPClient<br />
10<br />
11 Counter2 = tcpc.theSocket.Receive(hBuffer, 0, hBuffer.Length, SocketFlags.None)<br />
12<br />
13 'Trim the buffer to omit the null area<br />
14 TrimBuffer(hBuffer, Counter2)<br />
15<br />
16 'If there is some data then send it to the browser<br />
17 If Counter2 > 0 Then<br />
18 'Sending the data got from proxy server to browser<br />
19 S.Send(hBuffer, 0, hBuffer.Length, SocketFlags.None)<br />
20 End If<br />
21<br />
22 'If the was some data go get more<br />
23 Loop While Counter2 > 0<br />
.<br />
.<br />
.
at line 11 some times it will stop responsing and the expected thing is responsing 0 for terminating the proccess.
also at line 10 some times it says that the TCPClient connection is lost and I never asked to close the cnnection also it is not good to open a TCPClient for each request.
please help me and give some tips if possible.
My mind is gona be dead soooooooon !
Aboo
|
|
|
|
|
could you help me to create a grid like excel?
it should paste the value from clipboard/excel and paste it in grid (like pasting in excel).
i tried flexcell grid but its a demo version.
|
|
|
|
|
I cudnt understand your question properly........wat I understood is that you want to put the Excel sheet data into a control that looks like excel in .Net.
Use datagrid control provided by the Visula Studio.Net.......
And bind dataset with it or Read excel file in dataset and bind it with the grid.
_mubashir
Why it is called "BUILDING" when it is already Built.
|
|
|
|
|
binding is easy.
the hard part is copying the values of an excel data and pasting(not linking) it to grid in vb.(this is the behaivior im looking for)
i need this for multiple data entry.
i need to copy the values of a grid from SAP and pasting it to my grid. the problem is when im trying to paste it,it only paste in one cell and not in multiple cells like excel does.
|
|
|
|
|
ok Lets play a little gamble.......
try out the following code to copy the excel data to the Datagrid in VS.Net
<br />
Dim ds as new Dataset<br />
ds.ReadXml("strFilename+Path") 'Xls File path<br />
'Now bind the dataset with Grid........<br />
Done...?
_mubashir
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
