Giorgio Agrifoglio's Q&A profile

• Visual Studio Express Editions MSAccess Database coding, OpenDatabase

  Hi, I use to be quite good using recordsets and so to get to my databases. Any samples somewhere how to do the following it in vb2005: dim dbPictures As Database dim rsPictures As Recordset Set dbPictures = Workspaces(0).OpenDatabase(dbTxt) Sql2 = "Select * from Pictures order by id" Set rsPictures = dbPictures.OpenRecordset(Sql2, dbOpenDynaset) with rsPictures while not .eof .movenext wend end with rspictures.close dbPictures.close Thanx Andrew You must have a connection object to the database, a data adapter to fill the DataSet and a DataSet to fill. Here is a l ...Show All

• Visual Studio Express Editions "An exception occurred during a Ping request." - This error message whenever I try to ping a site that is not available.

  I am simply trying to ping a website address to see if the website is available or not. Whenever I ping a site that doesn't respond it gives me that error message in the title of this message and throws a program exception. The simple code I am using is below. Dim siteAvailable As Boolean siteAvailable = My .Computer.Network.Ping( "http://www.somesitetotest.com" ) MsgBox(siteAvailable.ToString)   Maybe I am completely overlooking something Whenever the site is available and does respond it returns "True" as it should. But whenever it isn't available it throws a exception instead of just simply returning "False" as ...Show All

• Visual Studio AddIn problem

  Hi all, I am experiencing some problems with Addins in the VS2005 environment. I have been researching the problem for a few hours, and haven't found anything useful. The problem is that addins simply refuse to show up. Tools -> Addin Manager... results in an empty window, and installed addins are nowhere to be seen in the Tools menu. I've checked the Addins folder under My Documents\Visual Studio 2005\Addins , and the .addin file is there. I've set an explicit path to the folder in Add-in File Paths under Tools->Options - Add-in/Macro Security and checked the 'Allow Add-in Components to Load' option. I've also tried to ...Show All

• SQL Server Authentication Issues

  Current Setup: Windows 2003 Server SQL Server 2000 w/ SP3 Windows Sharepoint Servics Problem: I have created a group on our Domain (INT) called Domain Users. Inside this group I have added individual users that need to be there. On the SQL Server when I try to add INT\Domain Users I get an error stateing that the user does not exist. Next I tried typing in INT and selecting the browse button. The window opens up listing all Domain users and groups including the one I added 'Domain Users'. I select Domain users from the Drop down list and hit OK. I then hit OK at the bottom of the Add User window and get the error User does not exist. Any hel ...Show All

• Windows Forms how to expand and collapse rows in DataGrid to create parent/child relationships using a single table!?

  Hello al, I am new to Windows Forms and for the past week or so, I have been pulling my hair out, trying to figure out how I can implement expand/collapse in the DataGrid. I do understand that if I setup relations between two tables in a dataset, and then assign the primary table to the DataGrid, I get the +/- buttons and I can expand&nb ...Show All

• Visual C++ Changed the COM signatures....using ildasm.....

  Hi, I have a .exe COM which I used in .NET but some signatures got changed....so I opened it with ildasm and changed the signatures so that it should return something from the function....This is the error I'm getting now.... The runtime has encountered a fatal error. The address of the error was at 0x79e8aff6, on thread 0xb4. The error code is 0xc0000005. This error may be a bug in the CLR or in the unsafe or non-verifiable portions of user code. Common sources of this bug include user marshaling errors for COM-interop or PInvoke, which may corrupt the stack. Any Ideas.... Thanks, Harsimrat ...Show All

• Visual Basic Visaul Basic 2005 Express Edition

  I have been using VB 2005 Express Edition to learn VB.net. I am ready to venture into the world of custom controls. It doesn't appear to me that writing custom controls is possible in the Express Edition. Does anyone know if it is possible and if so are ther any pointers to how to do it and how to install the custom control in the IDE Thanks, ...Show All

• SQL Server Looping through an excel spreadsheet

  Being new to SSIS I wish to loop through a series of excel spreadsheets and within each workbook loop through each sheet. I am aware of the For Each container but how can the each sheet in the workbook be referenced Steve Thanks Jamie, my problem is for each spreadsheet I loop through how do I reference each sheet / tab within the spreadsheets returned by the For EachLoop. Thanks Steve ...Show All

• Visual Studio Tools for Office Install issue - ServerDocument cannot write to client's Manifest

  First off I know that my VSTO solution works locally and will work with remote assemblies, on my machine and anothers client. But on a third machine (the client), I have run into a situation on a where I am trying the methodology of "Quick Start #3: Deploying a Document to a Local Folder, and an Assembly to a Network Folder" I have created the console application to handle the writing to Excel's manifest using the ServerDocument class. When the process attempts to write to the client's manifest to inform it of the remote dll this exception is thrown: Exception Caught: Could not create a persistence object for the specified fi ...Show All

• Smart Device Development Suggested method to send binary data via webservice?

  Whats the suggested method to send binary data via a webservice Appreciate any feedback/ideas... Thanks! MTOM is the best way to send binary data. Even large files can be sent. You just have todo 2 things 1) Install wse 3.0 2)Right click sol to enable mtom in wse prop after that all byte arrays will be sent via mtom. it uses xop to send binary data within a soap header you can also use dime but is slower and less secure ...Show All

• Visual Studio Tools for Office Can't install Visio 2005 after installing VS2005 Beta 2

  Hi, Can't install Visio 2005 after installing VS2005 Beta 2. The Visio 2005 Beta 2 Installation program will popup with a message " You must first install Visual Studio 2005 Beta ." Visual Studio 2005 Beta Which is already installed. Regards, Abdoessalam This also works if you install VS 2005 RTM as downloaded from MSDN, and then try to install Visio EA 2005. Used Orca to edit the VisVea.msi file, did the trick, install went without a hitch. ...Show All

• Smart Device Development MAPI

  Hello guys, i am using Mail API on Windows Mobile 2003, i'd like to know which function is used to send a mail (when i use MAPISendMail it throws the NotSupportedException i think the parameters are wrong) can anyone help please Thanks in advance ps: isn't there any Logoff function (when i call MAPILogoff i get an error saying there's no entrypoint in cemapidll.dll for Logoff) Does anyone have a C# ( not C++ ) sample that uses cemapi.dll on Windows Mobile 2003 Thanks in advance ...Show All

• SQL Server Error on bcp

  Hi again Sometimes, in some files .dat, thee following error occurs: #@ Row 1, Column 8: Invalid character value for cast specification @# 3877 597 2.0 Manual 1C15H4 <NULL> 24590.0000 1 2 G 2.0 ATIVO US$ 2006 2006 2 <NULL> But the columns are OK. Somebody can help me The error message indicates that the data in column 27 or row 1 exceeds length of the destination column. So check the length of data against your table's column definition. There is a limit to the number of columns in a table in SQL Server but there is really none in the data file. As long as you have to terminators defined prop ...Show All

• SQL Server how to do the same thing in mssql as mysql?

  in MySql: SELECT * FROM table LIMIT 5,10 How to do this in MicroSoftSql *grin* then you should have asked about access to start with :-) I'd expect my first solution to work with Access, but I couldn't be sure, I don't use it. ...Show All

• Visual Studio 2008 (Pre-release) Anyway to force members to be protected instead of internal?

  When you have something like this in Xaml :- <Ellipse Name="mEllipse" Width="100" Height="50" Fill="Blue" /> In the generated IL, mEllipse is marked as assembly (C# internal). Is it possible to get it to generate it as family (C# protected) If you are wondering why, the idea is to have a Xaml based C# control library - no code, just the UI in Xaml. Now, this allows us to derive a class (using C++/CLI which does not currently support Xaml directly) and use it. Of course, we'd then need to access the various fields (which is not possible because they are generated as internal and not as p ...Show All