Visual Basic

FirstPrevNext

Excel Automation VB.Net (SQL Server) Question JZion11-Jan-05 5:57 JZion 11-Jan-05 5:57  I need to automate Excel on my Intranet Server to do the following. In Excel I need to produce a report (in worksheet one) and in worksheet two I need to produce a Pivot Table of information (stored in worksheet one). The report needs to be generated from tables in SQL Server Version 5.1, I am familiar with .asp and a little asp.net, but have now purchased Visual Studio Pro 2003 and Visual Studio Tools for the Microsoft Office System (not opened the boxes yet). I think that it would be best to code an application in VB.NET that can be executed from .ASP (which the intranet is programmed in), however I don't have any resources available to me on automating Excel in such a way or know if a console type application (as in C++) can be compiled using VB.NET. My main questions however are, is there any such resources (available online) to help me out with excel automation? Also is the now familiar process of creating a DSN connection with SQL Server the way to connect with VB.NET? A guide to this would be helpful. If C# or C++ is the way to go, then is there any resources that could help? With thanks Jason copy & paste in VB6 Britnt711-Jan-05 4:32 Britnt7 11-Jan-05 4:32  I am trying to copy one sheet out of an excel document and paste or create that sheet into another excel document. How in vb6 is this coded? Thanks Beginner in VB.Net How to integrate reporting service with vb.net Mekong River11-Jan-05 4:29 Mekong River 11-Jan-05 4:29  Hi, my computer have sql server 2000 and vb.net. Now I successfully install sql server 2000 reporting service on the machine. I could create the project about making the report, BUT......... Now I have a windows application and I want to create report. I have designed the report in reporting service but I don't know how to integrate it with my application. I try to find it item in Add new component... But I just found only crystal report, not reporting services. Is it possible to integrate reporting service in windows application? If it is possible, how could I do it??? Please there is any information about using reporting service and vb.net for the beginner, it would be greate. A thousand mile of journey, begin with the first step. APO-CEDC Save Children Norway-Cambodia Office Re: How to integrate reporting service with vb.net Member 56585711-Jan-05 6:41 Member 565857 11-Jan-05 6:41  A good place to start would be with the samples included in reporting services. Personally I figured out most of what I need to know by looking at the RSExplorer example. Assuming you installed reporting services in the default path you can find it here: C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Applications\RSExplorer\vb Beyond that there is a lot of good information in the Books Online for reporting services. Hope that helps, Daryl Morgans Easy Questions for CPians Sebastien Lachance11-Jan-05 4:17 Sebastien Lachance 11-Jan-05 4:17  Wich is better : Dim myAdapter as oledbDataAdapter = new oledbDataAdapter("bla bla") or Dim myAdapter as new oledbDataAdapter("Bla bla") . Re: Easy Questions for CPians Dave Kreskowiak11-Jan-05 6:09 Dave Kreskowiak 11-Jan-05 6:09  Neither. They produce exactly the same IL code. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Easy Questions for CPians Sebastien Lachance11-Jan-05 6:38 Sebastien Lachance 11-Jan-05 6:38  And Integer.Parse or CINT OR CTYPE ? Re: Easy Questions for CPians Dave Kreskowiak11-Jan-05 9:18 Dave Kreskowiak 11-Jan-05 9:18  These three functions don't do the same things, so your trying to compare apples to oranges to banana's. Integer.Parse attempts to create an 32-bit signed integer out of a text string. CInt attempts to convert the value of a numeric datatype into a signed 32-bit integer value. CType attempts to convert one datatype into another datatype. This works with numeric types, objects, structures, classes, interfaces, ... RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Easy Questions for CPians Sebastien Lachance12-Jan-05 2:34 Sebastien Lachance 12-Jan-05 2:34  ok thanks a lot You really are a very helpfull resources Now for the last question : Dim ocls as Classname or Private (public etc..) ocls as Classname in the Code-Behind (not in methods). I'm sorry for all those question, it's just thing i havent paid attention, in my learning process. Re: Easy Questions for CPians Dave Kreskowiak12-Jan-05 8:13 Dave Kreskowiak 12-Jan-05 8:13  At this level, both of your statements generate the exact same code. If Public or Private is specified, the Dim keyword becomes optional. If there is no access modifier specified, Dim must be used and the variable is Private by default. These three statements do the exact smae thing: Class myClass Private Dim mstrLine1 As String Private mstrLine2 As String Dim mstrLine3 As String End Class RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Easy Questions for CPians Sebastien Lachance12-Jan-05 8:43 Sebastien Lachance 12-Jan-05 8:43  Great, thank you very much. VBA richtextbox produces error littleGreenDude11-Jan-05 4:12 littleGreenDude 11-Jan-05 4:12  I have a word macro (W97) that reads rich text from a database field assigns it to a rich text box control and pastes it into the word doc. The macro has been tested on four development machines and it runs fine. However, when it is moved to a production PC it produces error 429 can't create object. This error occurs on the rich text assignment line. rtb.TextRTF = strSelection Is there anything special ( a DLL or OCX that should be registered) that should be done to release the macro. What is special about the development machines that allow the macro to run? Re: VBA richtextbox produces error Dave Kreskowiak11-Jan-05 15:56 Dave Kreskowiak 11-Jan-05 15:56  There are a bunch of reasons why this error could come up, but none of them have anything to do with the RichTextBox. It's more likely that it is a problem with the Data Access Components. Try updating the components with MDAC 2.7 SP1 (at least). RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Setting ToolTip for selected ListViewItem kobezt0811-Jan-05 3:58 kobezt08 11-Jan-05 3:58  ---------------------------------------------------------------------------- How do I set different tooltip message for different selected Listviewitems? My ListView is in Detail mode and FullRowSelect = true Re: Setting ToolTip for selected ListViewItem Dave Kreskowiak11-Jan-05 6:06 Dave Kreskowiak 11-Jan-05 6:06  ToolTips are not supported on ListViewItems. What you'll have to do is handle the MouseHover event of the ListView control, then use the ListView .GetItemAt() method to return the ListViewItem that the mouse is over. You can then use whatever you want from that to set the Text of your ToolTip control. Handle the MouseHover event of the ListView to display the ToolTip. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Setting ToolTip for selected ListViewItem kobezt0811-Jan-05 16:08 kobezt08 11-Jan-05 16:08  thankz for the reply & tips, but im having abit problem. My program's listview display a report in such way as it will identify the row where there are error in any of it's colume and highlight it in pink. I'm suppose to display a tooltip on selecting of the "error" row and display a message stating the column that are incorrect. How should i do it? Re: Setting ToolTip for selected ListViewItem Dave Kreskowiak12-Jan-05 0:48 Dave Kreskowiak 12-Jan-05 0:48  If your code highlights a ListViewItem in Pink because of an error, then you can also set that ListViewItems Tag property to some value to signify the same. You can then check that Tag property when you go to set the ToolTip Text. If the Tag signifies an error, setup the ToolTip. If not, clear it. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Deleting file from HD Jodd11-Jan-05 3:25 Jodd 11-Jan-05 3:25  Hi, After loading an image file in a picturebox with picturebox.Image = Image.FromFile(Foto.Path) i want the file deleted from the hard disk. First I dispose the image in the picturebox (picturebox.Image.Dispose()) an then I delete teh file (System.IO.File.Delete(Foto.Path)) I recieve the message acces denied Can anybody help me Thnks Jo De Decker Re: Deleting file from HD Dave Kreskowiak11-Jan-05 5:50 Dave Kreskowiak 11-Jan-05 5:50  The Image object that you originally used to load the image from the file still has the file open. You called .Dispose() on the Image object in the picturebox, not on the Image object that loaded the file. To work around this little "feature", see this[^] article on MSDN. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Deleting file from HD Jodd19-Jan-05 15:02 Jodd 19-Jan-05 15:02  Thanks, it works Security Question on a Windows Service KreativeKai11-Jan-05 2:25 KreativeKai 11-Jan-05 2:25  While testing a service we've setup in Visual Studio / VB.NET we've found that the service will start without a problem if the files that it is monitoring are local to the machine the service is running on. As soon as we try to monitor a file on our network, and start the service, the following security message is thrown: Service cannot be started. System.UnauthorizedAccessException: Access to the path "\\TheServer\D Drive\FTP Files\OpenActions.csv" is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String str) at System.IO.File.GetLastWriteTimeUtc(String path) at System.IO.File.GetLastWriteTime(String path) at FileChangeMonitor.ChangeMonitor.CheckFileChanged(String FileName, DateTime& LastChangeDate) in E:\_MyFiles\Vb.NetProjects\Development\FileChangeMonitor\FileChangeMonitor\ChangeMonitor.vb:line 171 Any suggestions on what needs to be changed via security is appreciated. Lost in the vast sea of .NET Re: Security Question on a Windows Service Robert Rohde11-Jan-05 2:54 Robert Rohde 11-Jan-05 2:54  By default services run under the SYSTEM account. That wont have any rights to access files on the network. Each service can be configured seperatly. This can be done under Control Panel->Administration->Services->Right Click->Properties->LogOn (Im not sure about the names because Im using a german windows version). Re: Security Question on a Windows Service KreativeKai11-Jan-05 6:22 KreativeKai 11-Jan-05 6:22  That worked... Thanks!! Lost in the vast sea of .NET Re: Security Question on a Windows Service Dave Kreskowiak11-Jan-05 5:40 Dave Kreskowiak 11-Jan-05 5:40  A second problem your going to run into is that the FTP server will not lock the file that is being uploaded to it. Your service has to take into account that it cannot know when the file is completely written to the disk by the FTP server. The FileWatcher will notify you when the file is created, not when it is closed by the FTP Server. RageInTheMachine9532 "...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome Re: Security Question on a Windows Service KreativeKai11-Jan-05 5:57 KreativeKai 11-Jan-05 5:57  You brought up a very good question. How do we know if a file that we're looking for with the service is closed by the FTP process? I'm not sure what the answer is? Any suggestions? Lost in the vast sea of .NET

Last Visit: 31-Dec-99 18:00     Last Update: 17-Jun-24 9:14 Refresh ᐊ Prev1...4243424442454246424742484249425042514252 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.