Brunili's Q&A profile

• Visual Studio Tools for Office Reading Excel From C#

  You can read data from Excel using the JET OLEDB provider. See the URL below for the necessary connection string, and a link to a KB article with further information ... http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMicrosoftJetExcel -- Brendan Reynolds wrote in message news:9226766e-a1d5-400c-8d3c-8ffc566bec50@discussions.microsoft.com... > Hi > > Can anyone help me how to read values in Excel in C# . So that Once I > read I can send them to DataBase. My excel file Test.xls in ("C:\") > > Thanks > Doss > Hi Can anyone help me how to read values in Excel i ...Show All

• Visual Studio ReportViewer drillthrough in WebForms looking for .rdlc instead of .rdl in Local processing

  I am creating a ASP.NET application for reporting. I have created the reports (.rdl) using the Report designer. I keep all these .rdl files in a folder and this reporting application will list these reports. Clicking on a report will generate the report. I am reading the rdl xml to get the query and query parameters, then retrieve the data and add datasource to the LocalReport. This is working fine. In the drillthrough event I get the original drillthrough parameters and retrieving the data and setting it to the drillthrouh report. But it the report is looking for the .rdlc file. Just for the time being I renamed the .rdl file to have the .r ...Show All

• Windows Forms Problem accessing a windows application with HTTPS

  I am facing a problem with web deployment of a windows application, What i am trying to achieve is I have deployed a smartclient on webserver and trying to use it from a client application and IE. The windows app is a very simple application. Accessing with a client APP: I am loading the exe using Assembly.loadfrom by giving the URL as the input. In the client app if i give the HTTP URL it works fine. If i change it to HTTPS (SSL) it throws up file not found exception for its dependencies. Accessing with IE: When i Access the exe from HTTPS url in IE it throws up the below error IEExec.EXE - Common Language Runtime Debugging Se ...Show All

• Visual Studio Express Editions "DataBindingNavigatorDeleteItem" click event

  I get the following error message when updating [saving] a database after using the "DataBindingNavigatorDeleteItem" click event to delete data: "Update requires a valid DeleteCommand when passed DataRow collection with deleted rows". Can anyone please tell me what this means and how to deal with it newtWales Hi, Can you post the function code where you are using this deletecommand, so that we can help you out. Thank you, Bhanu. ...Show All

• Visual Basic PropertyGrid refresh and expanding.

  I have a property grid. After using the collection editor I call refresh so that any new objects appear in my grid. It works just fine except for any previously expanded properties are now collapsed. IF I call propertygrid1.expand it expands all of the properties. Is there a way to restore it to it's state before the refresh Any Idea's at all or a direction to start It seems that i can't find a decent way to expose each of the properties either. I thought of doing it by setting each sub to expanded and recording clicks when they happen to track the state. ...Show All

• Windows Forms How to get a responsive form?

  Hello, I am new at window forms and I am curious to know how I create a responsive UI. Here is what I am attempting to do. Basicaly I have a datagrid loading huge amounts of information. Depending on the row selected, upon clicking an Edit button, I will load a form with the values of the row selected. Pretty straightforward. My form has sev ...Show All

• .NET Development WsProfileDualHttpBinding

  Hi there, Guys, I am trying to create and run a Indigo service (Duplex contract)  and run with a " WsProfileDualHttpBinding". It compiles OK, but the WsProfileDualHttpBinding element is creating problems. However if I change all the OperationContracts and ServiceContracts to " wsProfileBinding " and change web.config to use the same, it rocks. It looks to me like a version problem with the .NET framework. Let me know if there is a work around for this. IE shows the following error -------------------------------------------------------------------------------   Server Error in '/IndigoService' Application. Actual ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. I cannot use DirectX SDK

  Hello again.I have installed DirectX SDK but I cannot use it.Why I use Microsoft Visual Studio 2005 - Visual C#.I most do somethink alse We really need to have more information, Why can you not use it. One thing that you will have to do when you do create your first application is to make sure that the references are setup correctly. Have a look at this link for a basic run down on adding the references. ...Show All

• Windows Forms Setup

  How to create an setup for dotnet 2003 application so that it can be installed on client PC Well if you mean a VS setup&deployment project, these might help: http://www.simple-talk.com/2005/04/25/getting-started-with-setup-projects/ http://www.simple-talk.com/2005/06/07/visual-studio-setup/ http://www.simple-talk.com/2005/07/18/updates-to-setup-projects/ Clickonce is VS 2005, so I suspect you're not referring to that. ...Show All

• SQL Server roles and rights on hierarchies trees

  Hi everybody! I created a new role. This role has Process Database permission and Read Definition permission. He can Read the Data Source, the Cubes, the Dimensions, the Dimension Data and is allowed to see all cell data. When the user assigned to that role logs in, from the BIDS he can in fact see all the cell values of the cubes (even positioning on the browser all the hierarchies of all the dimensions). But from the dimensions browser, he cannot see the hierarchies of the dimensions and is told that no hierarchies exist, despite he can read the hierarchies definition from the Dimension Structure tab and can ...Show All

• Visual C# C# Equivalent To VB WithEvents?

  I have a form with a tabcontrol, and each tab has a webbrowser control.  I have declared a form variable, curWebBrowser, of type, WebBrowser, that gets set to the current, visible webbrowser control when the user clicks on its tab.  I would like to handle all webbrowser events via curWebBrowser, rather than code event handlers for every webbrowser control.  Is there a way to do this in C# TIA, rca Hi, Yep you quite got it right. Here are some additional docs... http://msdn2.microsoft.com/library/awbftdfh(en-us,vs.80).aspx http://msdn2.microsoft.com/library/ms173171(en-us,vs.80).aspx ...Show All

• Visual Studio Desktop build on build machine

  Rather than constantly checking out my tfsbuild.proj file, making changes, then, to test my changes, checking the file back in and kicking off a team build. I want to change the file directly on the build machine and run a desktop build to prove all my changes before checking the file out of source control... when I run msbuild tfsbuild.proj on the build machine I get the following error: Target CoreCompile:   C:\Program Files\MSBuild\Microsoft\VisualStudio\v8.0\TeamBuild\Microsoft.TeamF oundation.Build.targets(396,5): error MSB4062: The "Microsoft.TeamFoundation.Bui ld.SetEnvironmentVariable" task could not be loaded from the assembly ...Show All

• Visual Studio Converting Windows Applications Projects from VS 2003 to VS2005

  Hi We have many Windows Application project written in C# (VS 2003) I have opened it in VS2005,but it didn't create the .Designer files for Forms or controls I am thinking for a tool that parse all my code and splite the initializeComponents into another code file and give it the <FormName>.Designer.cs   What do you think is it doable and worth the efforts Is creating the Designer files manually will not introduce problems in compilling or runing   This forum is intended for discussions of Visual Studio extensibility, whether thru profiles, macros, add-ins, packages, or other extensibil ...Show All

• Visual Studio Team System Beta 3 Team Foundation Client: "Invalid license data. Must reinstall"

  After much trial and tribulation, got all the server components of TFS installed sucessfully (single machine installation, workgroup authentication). After all that, installing the client should be easy, right Well, install ran OK, but when I try to run it, get message box saying "Invalid license data. Must reinstall". Need I say that reinstalling didn't help Installed and attempted to run using same tfssetup a/c used in server installs. Any suggestions Many thanks, John Rhoads I have posted a blog item about this "invalid license data" error that may be useful here as well.  You can find it at http:/ ...Show All

• Visual Studio Team System Question Before Evaluating VSTS

  All, I'm trying to determine the answer to one very, very important question for us.  Can VSTS source control application run for developers who are in different areas without using VPN to access it   Currently, we are using SourceSafe with SOS for our remote dev's to access it and check in/check out files without using the VPN.  We want to maintain that functionality, but I haven't been able to find anywhere on the VSTS site where it says how VSTS supports geographically diverse locations. Any help is appreciated. Cheers, Yes, all communication between client and server is done using Web services over http, or optionall ...Show All