Belliez's Q&A profile

• Visual Basic How to insert data into Excel sheet from VB.NET

  How to insert data into Excel sheet from VB.NET For Each f In folder.GetFiles() Try ' ObjWSheet = New Worksheet ObjWSheet.Range("A" & cellCount).Value = f.Name cellCount += 1 Catch exc As Exception MsgBox(exc.Message) End Try Next this code contain errors "object refrence not set to an instance of an object" ...Show All

• SQL Server The name of DataSource in URL of report.

  Hello : Can we make to cross the name of the DataSource in URL of the report Thank you very mutch. Are you asking if you can use the url to have the report use a different datasource then the one that is configured If so, then the answer is no, that is not supported. If you are asking for something else, can you please clarify. -Daniel ...Show All

• Visual Studio Tools for Office VSTO deployment close to solution

  Hi all, I'm backing down to make sure I find a way to deliver to my customer the next few days: I have developed an Excel template with some .NET code behind using VSTO 2005. Not the SE, the first version. My solution uses another .NET assembly (helper.dll) besides the code assembly data.dll "behind" the document (data.xlt). I added a setup project to the solution. Which isn't enough of course. I created to separate install classes, one to install a policy code group thats gives Full trust to data.dll and one to bind the data.dll path to the data.xlt document (via ServerDocument). I added the custom Action to Install the CustomSetup.dll with these installer classes. Now to my questions: Are there any walkthroughs to t ...Show All

• Windows Forms How to adjust MDI forms size according to screen size...?

  Hi... In my MDI application , Before loading my parent form i want to check my screen size & according to that i want to adjust my MDI parent & child form size. In my application, I have a child form which is always active & which is covering the parent forms area. For that I want to adjust my parent form & that child forms area according to the screen size. How I can do this in C#... Thanks & regards, Vinay There is no documented way to get the MDI client rectangle that I'm aware of. But there is an undocumented way. I'm not sure if you should use it, but here's code for an MDI child form that positions itself inside the parent as large as it fill f ...Show All

• SQL Server Problem installing SQL 2k 32bit on Windows 2003 64bit x86 SP1

  I've been having no luck trying to install SQL 2k 32bit on Windows 2003 64bit x86 SP1 - I've found several articles regarding needing to put SP4 on the 64bit OS, but my problem is the SQL 2k 32bit ",,\x86\setup\setupsql" won't run. I consistantly receive a "...(localuserdir)\Local.ins. Unable to load installaion instructions. Error 703." And of course, the SP4 setup won't run because there is not an existing SQL Service to upgrade. Anyone come up against a similar problem Thanks! ...Show All

• Visual C++ independent volume control

  Im coding the simplest of wav players. I need to modify the volume (ie through a slider) of the played wav file independently, without affecting the windows main volume control. I'm using Playsound(...) to play the wav files. Can someone please point me in the right direction. thanks. Hello Re: independent volume control Such questions are outside the scope of this forum - for the scope of the VC General forum please look at: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=19445&SiteID=1 For such issues please use the newsgroups at http://msdn.microsoft.com/newsgroups . OTP Thanks Damien ...Show All

• Windows Forms Microsoft SQL Server (SqlClient) connection for Visual basic

  why when i try to add a datasource in visual basic 2005 the option for Microsoft SQL Server (SqlClient) is no show...only for Microsoft SQL databasefile Help please In VB Express you can only add a datasource to an mdf or access database. The feature which allows you to connect to an existing sql server database is not available. You can still bind to the database with code. ...Show All

• Visual Basic MDI Creation

  I know this should be a simple thing but I can't find information on it at all. I am creating a program that needs a dynamic MDI. The user will be able to begin at the main page(frmMain) and advance through 7-8 pages with the last updating a database. They can also scrap the project midway through and restart, or jump to the end and load a finished project from the database. I have tried to find examples on how to do this, but have had no luck. I also want to be able to advance through the forms using the menustrip and buttons on the form, but I beleive the code behind both will be similar. Can anyone point me to an example of this. ps. This is my first major attempt at a program outside of .php ...Show All

• SQL Server Log Shipping between SQL 2005 and SQL 2000

  We have an environment where 3 SQL 2000 servers exist; one production servers and two standby servers that receive logs via log shipping. Everything works fine and it is stable. My client wants to get a new 64 bit server and run SQL 2005 64 bit version for the production box. Can we still do log shipping with the two remaining SQL 2000 boxes or do they all have to be on the same version and bit version Thanks Bill Hey Paul, When applying a transaction log built from a SQL2000 (version 80) instance to SQL 2005 instance but the database is in a (version 80) configuration I still get the following error: This backup cannot be restored using WITH STANDBY because a database upgrade is needed. ...Show All

• .NET Development excluding an xml node from loading in datagridview

  Hi, When i load an xml file into a datagridview, it loads a few nodes which i rather not load in the datagridview. This is the content of the xml file: <root> <book> <price>20</price> <title>whatever</title> <timeProduced>60958234643051454<timeProduced> </book> </root> And it loads all 3 nodes (price, title and timeProduced); And i dont want to load the timeProduced node. This is how i load the xml file into my datagridview: DataSet xmlDoc = new DataSet(); xmlDoc.ReadXml(path); this.grdSmsHistory.DataSource = xmlDoc; this.grdSmsHistory.DataMember = "book"; How can i prevent that Thanks in advance! Once you have a data set and the gr ...Show All

• Visual Studio Team System IWorkItemControl.SetSite question

  The SetSite method seems to be invoked when a work item custom control is instantiated. Which services are specifically available using the IServiceProvider.GetService method and what are some sample usage scenarios .. Thanks in advance. In SetSite, a pointer to IServiceProvider is given. IServiceProvider.GetService can be used to access any VS service. For example, something can be printed in status bar when using your control. Common intented use for it is to get DocumentService and then use its methods. Example usages of DocumentService are to show a workitemform for existing or new workitem, show a query, doing validation and showing error on Save event of workitemform etc. See http://blogs.msdn.co ...Show All

• Software Development for Windows Vista Enabling aero glass?

  Is there something in particular that has to be done to enable this I've installed Avalon and the other pieces with it, updated my gfx driver the the latest version from nvidia, but I'm still getting the plain aero, and I don't see anywhere to enable aero glass. My system is far above the requirements needed for it: Athlon64x2 4400, GF7800GTX, 2GB RAM...   That is incorrect, and I am shocked that anyone would tell you that.  There are card from Nvidia that do glass today. Nvidia Alpha Driver http://www.nvidia.com/object/winvista_75.03.html Products Covered http://www.nvidia.com/object/winvista_32_supported.html Josh http://Windowsconnected.com ...Show All

• Visual Basic Hide/Show form causes form to reload

  Using VS 2005. Creating windows forms application. I have a search form that the user can enter their search criteria and then find records. The records found populate a grid. The user selects a record in the grid and then clicks open record button. The click event of the open record button does the following: Dim frm As New frmRS_ModMenu frm.Show() Me .Hide() 'This is frmSearchForm This works great. The user can enter data for the selected record and then close the form. When the data entry form is closed I do the following: frmSearchForm.Show() Me .Close() However, when I close the data entry form and call show on the search form the form load event fires only on the initial hide/show. This causes the sea ...Show All

• .NET Development Windows Service gives "5: Access is denied" on startup.

  I am writing a Windows service I intend to host a TCP server and communicate with TCP client equipped applications. I used the Windows Service template to start, and wrote some code I knew I'd need to get started. I added the server installation components as described in the help, and set it to run in the LocalService account. I compiled the code as an .exe and used the installutil <servicename.exe> to install it for testing. When I attempted to start it through the service manager, it came back with 5: Access is denied. I originally attempted to start it under the LocalService account, then retried it under the NetworkService account. Same issue. Just as a sanity check, I created a bare Windows Service with no code other than ...Show All

• Smart Device Development Is compact framework 2.0 not already installed on Windows Mobile 5 devices?

  Hi, My experience with Windows Mobile 2003 was that the compact framework version 1 was already installed. This made deployment quite easy for my Framework 1.1 applications. I am now preparing to release a Framework 2.0 application and was hoping to be able to similarly expect the runtime to be already installed on today's devices. To test this out, I purchased a brand new Dell Axim 51V, copied a HelloWorld program to it and received the error that "This application requires a newer version of the Microsoft Compact Framework than the version installed on this device". My device has Windows Mobile Version 5.0 OS 5.1.195 (Build 14957.2.3.1). Does this version of the OS not include the .Net Compact Framework 2.0 Tha ...Show All