|
TableStyles is the best way to do it. I've found this[^] FAQ pretty handy when it comes to DataGrid stuff like this.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Hi!
I need to export data contained in the DataGridView control to Excel. The code provided here does the work, but not fully - when Excel opens the file, it recognises it like a "Tab delimited values" and import wizard appears. This is too complicated for (my) end users, so I need a way to write "real" xls file, without the need of end user action. Do you know how can I do this?
The code is:
'(tab is DataGridView control containing data)
Dim fileText As System.Text.StringBuilder = New System.Text.StringBuilder()
'exporting column names
For Each col As DataGridViewColumn In tab.Columns
If col.Visible = True Then
fileText.Append(col.Name)
fileText.Append(vbTab)
End If
Next
fileText.Append(vbCrLf)
'export cell values
For Each row As DataGridViewRow In tab.Rows
For Each theCell As DataGridViewCell In row.Cells
If theCell.Visible = True Then
fileText.Append(theCell.Value.ToString())
fileText.Append(vbTab)
End If
Next
fileText.Append(vbCrLf) 'moving to the next row
Next
My.Computer.FileSystem.WriteAllText("Test.xls", fileText.ToString(), False)
Any help would be appreciated!
Thank you in advance!
Veljko
|
|
|
|
|
is this a windows application
Bulbul Bhuwania
|
|
|
|
|
Yes, this is a windows application (there are many solutions on the net for asp / web, but I've found none for windows app).
Can you help me?
|
|
|
|
|
I am having the same problem. Please provide me the solution if you happen to get one.
With Best Regards,
Mayur
|
|
|
|
|
check this
http://gridviewguy.com/ArticleDetails.aspx?articleID=26
|
|
|
|
|
albCode, thank you for the reply, but I have allready found many sources for converting in ASP using web pages..
What I need has to be done using Windows application.
|
|
|
|
|
http://www.vbfrance.com/codes/REQUETE-SQL-MULTI-TABLES-CHARGEE-DANS-DATAGRID-EXPORTATION_34985.aspx
http://www.readablog.com/feed9160.aspx
|
|
|
|
|
I have a text box which is always disabled.
Is it possible to change the fore color and the background?
I tried to default the color to bule,
but the color of the text box still in gray.
Any suggestion? Thank you
|
|
|
|
|
first enable the text box...
change the forecolor and the back color and then disable it...
probably it shud work out
Bulbul Bhuwania
|
|
|
|
|
u can change the backcolor not he forecolor i guess
Bulbul Bhuwania
|
|
|
|
|
u can change the backcolor not he forecolor i guess
u can make the text box read only instead of disabling it to keep the forecolor as blue
Bulbul Bhuwania
|
|
|
|
|
Is this a winform app
If so there is no direct way of doing this...
Workarounds
1. You can set readonly to true instead of enaled=flase
2. You may a create textbox control and override onPaint Event
|
|
|
|
|
if the textbox is always disabled then don't use a textbox. Use a Label instead, then you can set the forecolor or the backcolor to anything you want 
/jason
|
|
|
|
|
hi....send me the solution...
Paritosh
|
|
|
|
|
|
wat r u asking???
Bulbul Bhuwania
|
|
|
|
|
tumkya kar rahe ho??
Paritosh
|
|
|
|
|
hum kuch anhi bas..icalms mein javascript padh rahe the..
woh bhi work anhi kara raha hai..
subah se chatting kar rahe the
tumko prob kya hai woh toh tum post anhi kiye
Bulbul Bhuwania
|
|
|
|
|
na...problem...is...that dll is opening a session with mainframe....then opening a login form(vb)...takes the User information(UN,PASS,etc) pass to the mainframe system...checks for authentication...if correct....then pulls some data and shown to user.....previously it as working fine....but they have upgrated one of their S/W...which makes that dll not working...
me...just going through the code....really good code...some new features are there....new syntax....etc..tum madat karsakti ho but ....without proper environment samjhna muskil hai....like....mainframe....JAVA script...etc..
mein try kar raha hun....lets see...
aur tum batao
Paritosh
|
|
|
|
|
hi..
without the code i wont be able to help u in anyhting...
anyways all the best...
take care
:->
Bulbul Bhuwania
|
|
|
|
|
YA...I CAN SEND YOU THE CODE....YOU NEED TO SEE THE MAINFRAME WINDOW...THE SESSIONS....ETC...
JUST HAVE A LOOK...THE CODE....CHECK MAIL.
  ;);P  sigh:   :->         ![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
Paritosh
|
|
|
|
|
I have written a windows service that needs to be controlled and queried remotely. The Windows Service has an accompanying Web Service that I have implemented adequate security on and wish to be able to run the web service as Local System.
I am not able to change the settings on IIS as it is against our company's security policy and therefore I need to set the access credentials to the Serviceprocess via the object in the web service.
I can't, as yet, seem to find an adequate technote that will cover this and will be looking some more.
Any help will be grateful.
Server environment is Win 2000 Server, running IIS5, .net Framework 1.1.4322.
|
|
|
|
|
|
I want the credentials to be hardcoded into a different object that will be instantiated after the Session authentication has been completed.
It is the actual process, within the web service, of saying, service process run these actions as the local system please.
But the eternal question is How?
Thanks for the reply.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
