mandar17367's Q&A profile

• Visual Basic exporting to a document

  ok....here's the thing...is it possible to export the contents of a datagrid to a document in word or export the contents of a sql query to a word document for instance i want to do query a table with something like "select * from tablename" and the output to be exported to a document any help would be appreciated thanks in advance Word has it's own, complex file format. You can control ...Show All

• Windows Forms AppUpdater Not Working

  Anybody else had any troubles getting it working   I've got the folder in IIS set to allow directory browsing, but after AppUpdater.DownloadUpdate() is called, I get this error... 5/10/2004 6:02:47 PM:  UPDATE FAILED with the following error message: System.Net.W ...Show All

• Visual Studio 2008 (Pre-release) Joining Tables and List

  I tried the following out of curiosity to see if it would be possible to filter a table sql style against a list of values.    Rather then where c.City == "London" || c.City == "Paris" I wanted: var cities = new[]{ "London", "Paris" }; var q =   from c in db.Customers, cy in cities   where c.City == cy   select c; The error I get is System.InvalidCastException: Object must implement IConvertibl ...Show All

• Smart Device Development Win CE Emulator missing from Beta?

  Hi, It appears that the VS 2005 Beta2 install does not include any WinCE Emulation or WinCE device attachment options.  Is it necessary to have Platform Builder 5.0 installed as well Sean There is no plan to have built-in emulator of WinCE for Whidbey.  You will find a WinCE device attachment entry under the Windows CE 5.0 platform.  Options are available in the Tools->Options menu, under de ...Show All

• Windows Forms Object datasource with no list - best practice?

  Hi, I want to create an object datasource that I can bind to any of the winforms/webforms controls using standard methods. The only caveat is that the object will be singular. ie: there will never be more than one item of data (the equivilant of one row) in the object. What's the best practice for achieving this Thanks. Adam. Why would you bind a single row to, say, a combo box or a data grid The ...Show All

• Visual Studio Express Editions Opening excel files in vb 2005

  How to I write the code for a button to open an excel document from a vb 2005 express edition form ms-help://MS.VSCC.v80/MS.MSDN.v80/MS.VisualStudio.v80.en/dv_vbalr/html/ec11fd03-b420-412f-b25a-057f877cefbc.htm The following example uses the CreateObject function to create a Microsoft Excel worksheet and saves the worksheet to a file. To use this example, Excel must be installed on the computer where this progra ...Show All

• Microsoft ISV Community Center Forums VBA Collection Object

  Is it possible to use the key of a collection object to scroll through items in the order of the key I know that either I can work through from 1 to Collection.count or by using For .. Each .. Next, but a method to work through in key order would be very useful. Hello ADG, Looking at the collection object it doesn't look like it's possible, there is no property to get the keys used by the collection. The way ...Show All

• Visual Studio Subreport, linked parameters, logon info and VS2005

  I've a report with use a stored procedure as a data source, and I assign logon info and parameter values to report at runtime, the report has another subreport with stored procedure, the parameters are linked to the main reports. When I preview the report, it throws " missing parameter values" exception, I trace all paramters with debugger, only parameters in subreport are null, those parameters are linked to main report, and I think i ...Show All

• Visual FoxPro Excel validation

  Dear experts, For example I export customer.dbf to excel and let user do maintaince in excel then import back to db. However I wanted to add validation in "CustomerType" column to avoid any incorrect type being imported. My program like this : autoExcel = createobject("excel.application") autoExcel.visible = .t. autoWorkbook = autoExcel.Workbooks.Open("c:\customer.xls") autoSheet= autoWorkbook.Worksheets[1 ...Show All

• Windows Forms How to get the correct value for DataGrid.Select(index) after DataView.Sort

  I've read a lot of postings, but still don't seem to get this right. Hopefully someone out there can help. This is in C#, using Winforms: I have a datagrid, a combobox, and a textbox all on the same form. I would like the user to be able to use the combobox to 'select' one of the columns in the datagrid and then enter a search value for that column in the textbox. When the user has entered enough text to match a value in the selected co ...Show All

• .NET Development DoEvents()

  at beginning i want to say sorry for next DoEvents topic, i searched forum but i didn't find answers... i have some simple mouse click event: private: System::Void button1_MouseClick(System::Object^ sender, System::Windows::Forms::MouseEventArgs^ e) { for(int u=0; u<2000;u++){ ...long loop Application::DoEvents(); } } thing is that after clicking button application response (for eg. clicking another button...) at seco ...Show All

• SQL Server SQLConnect to SQL Server fails when connection intialized from a service

  I have an issue where SQL Server is refusing a connection that is initiated from within a Windows service. The connection is attempted using the SQLConnect ODBC function (yes I know there are newer and better things out there but I'm stuck with ODBC for now ). SQLConnect returns SQL_ERROR and the error code that is returned is: 28000 Invalid authorization specification The value specified for the argument UserName or the value specified ...Show All

• Visual Studio Tools for Office Problem deploying Shared COM-AddIn application

  Greetings, I've been developing this program in VS.NET using VB.NET at work to synchronize Microsoft Project with data from our databases.  To describe the program, it simply creates and adds a new menu with a few options to the existing main menu. I feel it is ready for my fellow employees to use, but I am having issues in getting it to deploy correctly.  The situation is as follows. During the process of development, I have been a ...Show All

• Visual Basic Microsoft Excel Bug -Data Population in drop down box

  hi , In VBA we have a string whose length is greater then 253 (by len() function in vb) when I am trying to add this String Value in excel cell as drop down as   With Sheet1      .Range(.Cells(inserDatatRowNo, loc), .Cells(inserDatatRowNo, loc)).Select          With Selection.Validation       .Delete       .Add Type:=xlVali ...Show All

• SQL Server 2005 keeps telling me the dababase is restoring

  Hello all, I have been seeing problems in restoring database to SQL Server 2005. The source is a .bak file backuped from SQL 2000. Everything in the process went well and at last the restore window told me the resotre has been successfully complete. But in management studio, it keeps telling me the database is restoring, I can not access it or open the property page.  I tried the process many times already. This occured several times ...Show All