Visual Basic

FirstPrevNext

Re: Changing datagrid properties like column header text,width,alignment at runtime Dave Kreskowiak7-Mar-06 6:11 Dave Kreskowiak 7-Mar-06 6:11  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 Export DataGridView to Excel (xls) format veljkoz7-Mar-06 1:39 veljkoz 7-Mar-06 1:39  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 Re: Export DataGridView to Excel (xls) format Bulbul Bhuwania7-Mar-06 2:23 Bulbul Bhuwania 7-Mar-06 2:23  is this a windows application Bulbul Bhuwania Re: Export DataGridView to Excel (xls) format veljkoz7-Mar-06 3:27 veljkoz 7-Mar-06 3:27  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? Re: Export DataGridView to Excel (xls) format mayhem_rules7-Mar-06 2:31 mayhem_rules 7-Mar-06 2:31  I am having the same problem. Please provide me the solution if you happen to get one. With Best Regards, Mayur Re: Export DataGridView to Excel (xls) format albCode7-Mar-06 4:32 albCode 7-Mar-06 4:32  check this http://gridviewguy.com/ArticleDetails.aspx?articleID=26 Re: Export DataGridView to Excel (xls) format veljkoz7-Mar-06 4:48 veljkoz 7-Mar-06 4:48  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. Re: Export DataGridView to Excel (xls) format albCode7-Mar-06 5:12 albCode 7-Mar-06 5:12  http://www.vbfrance.com/codes/REQUETE-SQL-MULTI-TABLES-CHARGEE-DANS-DATAGRID-EXPORTATION_34985.aspx http://www.readablog.com/feed9160.aspx Set the diabled text field color? cylix20007-Mar-06 0:40 cylix2000 7-Mar-06 0:40  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 Re: Set the diabled text field color? Bulbul Bhuwania7-Mar-06 1:08 Bulbul Bhuwania 7-Mar-06 1:08  first enable the text box... change the forecolor and the back color and then disable it... probably it shud work out Bulbul Bhuwania Re: Set the diabled text field color? Bulbul Bhuwania7-Mar-06 1:10 Bulbul Bhuwania 7-Mar-06 1:10  u can change the backcolor not he forecolor i guess Bulbul Bhuwania Re: Set the diabled text field color? Bulbul Bhuwania7-Mar-06 1:11 Bulbul Bhuwania 7-Mar-06 1:11  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 Re: Set the diabled text field color? sathish s7-Mar-06 1:56 sathish s 7-Mar-06 1:56  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 Re: Set the diabled text field color? jcrussell7-Mar-06 14:42 jcrussell 7-Mar-06 14:42  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 VB dll.......bulbul Paritos7-Mar-06 0:02 Paritos 7-Mar-06 0:02  hi....send me the solution... Paritosh Re: VB dll.......bulbul Vasudevan Deepak Kumar7-Mar-06 0:05 Vasudevan Deepak Kumar 7-Mar-06 0:05  paritosha wrote: ForumVisual Basic / VB.NET Subject:Re: VB dll.......bulbul Sender:paritosha Date:5:02 7 Mar '06 hi....send me the solution... Paritosh What are you intending to clarify? Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://www.dotnetjunkies.com/weblog/deepak/ http://deepakvasudevan.blogspot.com/ http://deepak.blogdrive.com/ Re: VB dll.......bulbul Bulbul Bhuwania7-Mar-06 0:49 Bulbul Bhuwania 7-Mar-06 0:49  wat r u asking??? Bulbul Bhuwania Re: VB dll.......bulbul Paritos7-Mar-06 0:50 Paritos 7-Mar-06 0:50  tumkya kar rahe ho?? Paritosh Re: VB dll.......bulbul Bulbul Bhuwania7-Mar-06 0:57 Bulbul Bhuwania 7-Mar-06 0:57  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 Re: VB dll.......bulbul Paritos7-Mar-06 1:27 Paritos 7-Mar-06 1:27  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 Re: VB dll.......bulbul Bulbul Bhuwania7-Mar-06 1:45 Bulbul Bhuwania 7-Mar-06 1:45  hi.. without the code i wont be able to help u in anyhting... anyways all the best... take care :-> Bulbul Bhuwania Re: VB dll.......bulbul Paritos7-Mar-06 2:03 Paritos 7-Mar-06 2:03  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: :-> Paritosh Serviceprocess credentials, vb.net webservice robbo46-Mar-06 23:53 robbo4 6-Mar-06 23:53  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. Re: Serviceprocess credentials, vb.net webservice Vasudevan Deepak Kumar7-Mar-06 0:16 Vasudevan Deepak Kumar 7-Mar-06 0:16  You can send Credentials with the WebRequest from the Windows Service that you are running. Is'nt it? Vasudevan Deepak Kumar Personal Web: http://www.lavanyadeepak.tk/ I Blog At: http://www.dotnetjunkies.com/weblog/deepak/ http://deepakvasudevan.blogspot.com/ http://deepak.blogdrive.com/ Re: Serviceprocess credentials, vb.net webservice robbo47-Mar-06 0:31 robbo4 7-Mar-06 0:31  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.

Last Visit: 31-Dec-99 19:00     Last Update: 8-Dec-23 22:48 Refresh ᐊ Prev1...3549355035513552355335543555355635573558 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.