OGData's Q&A profile

• Microsoft ISV Community Center Forums Hyper link Macro

  I am new to this stuff. I want to add hyper links to a series of numbers.eg 100 101 102 103 etc There is a number folder for each hyperlink in excel. So the 100 hpyerlink will open the 100 folder and so on. I can do i Macro to do one folder. How to i get it to do hundreds without repeating myself. Thanks for you help, cheers Boots Below an example First create workbook with one sheet named "100" Run the macro and you have 101 sheets the links are in sheet "100" Suc6 Sub CreateLinks() Dim Max As Long Max = 100 Dim Idx As Long With ThisWorkbook For Idx = 1 ...Show All

• SQL Server Adapters in SSIS?

  Are there adapters available to connect to SSIS for 1. Siebel 2. IBM MQ Please let me know what are the alternatives if they don't exist. I am still struggling to understand the core functionality difference between BizTalk and SSIS Thank you. Yeah, that is another way of stating what I said. By sheer coincidence I've just come across this useful post explaining the difference between SSIS and BizTalk http://blogs.msdn.com/william_zentmayer/archive/2005/10/17/481992.aspx Perhaps googling would help: http://www.google.co.uk/search hl=en&q=biztalk+ssis&meta = -Jamie ...Show All

• Visual Studio 2008 (Pre-release) GridView representation of XML

  Hi, I am trying to display the contents of an Xml Document in a GridView. An example of the the Xml is as follows; <Table> <Column>Name <Cell>Dave</Cell> <Cell>Pete</Cell> </Column> <Column>Age <Cell>32</Cell> <Cell>26</Cell> </Column> </Table> I want the GridView to look as follows; [Name] [Age] Dave 32 Pete 26 That is, in tabular form. My Xaml contains an XmlDataProvider; <XmlDataProvider x:Key="TableModel" /> and the C# XmlDataProvider xml = (XmlDataProvider)FindResource("TableModel"); xml.Document = doc; Each Gr ...Show All

• Visual Studio How to Install VS2005 Beta 2 in Windows Vista Beta 1?

  Is there a version of VS2k5 that will install onto Vista Beta 1 I get an error installing MSXML6.0 when trying the Beta 2 release. Thanks, Matthew A bug reported and workaround was filed here: http://lab.msdn.microsoft.com/ProductFeedback/viewFeedback.aspx FeedbackId=2ed1acbc-0c30-4bd1-99de-3dff389fa885   ...Show All

• Visual Studio Express Editions crystal reports in VC# express

  how to display crystal report in VS C# express... there is no report viewer control. Yes, You can Add Crystal Report in your VB, C# Express. Just Make Crystal Report in any of CR version 8.0 or 8.5 and Drag Crystal Report Viewer Control on form. Try the following code. <C# Code> CRAXDDRT. Application crt = new CRAXDDRT. Application (); CRAXDDRT. Report rpt; rpt = crt.OpenReport( @"<Report File Name with proper Path>" , 0); //Like "C:\CrReport\abc.rpt" rpt.Database.LogOnServer( "p2ssql.dll" , "SQLServerName" , "Database" , "UserId" , "Password ...Show All

• SQL Server Restore MDF problem

  typical "user didn't backup database before performing transactions" case. (note: below I have renamed my mdf file as my_data.mdf for privacy purposes) I'm trying to attach an mdf that I pulled off my server into my local database in SQL 2005 but get this error during the attach process:  TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'BG-PC43'.  (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOper ...Show All

• .NET Development Use Javascript to check if client has added the domain as a Trusted Site

  I need a way to check, using Javascript, if the user has added the domain as a Trusted Site. We sell different kinds of content management tools and similar products to our customers. To be able to guarantee it's functionality, we require, among other things, that the domain that the CMS is installed on, has been added as a trusted site. At the login prompt we need a way to check if it has been added as a trusted site and if not, display a warning. I haven't been able to come up with a good solution to this yet. Anyone know if it can be done Indeed I am having a very similar problem. Upon logi ...Show All

• .NET Development Troubles declaring variables and using variables in modules

  Hi, i'm using vb.net 2003, and i seem to have difficulty decaring and using variables in a module outside a function, or property. I want to declare a StreamReader in the module, and a String object eg. line. and then I want to use the "line" to read the first line of a file. as the program runs, the first form that pops up is a OpenFileDialog, which will be used to browse to the database in use, that value, or filename will be used to write a string to a file which incorporated the connection string. And the module to read that line and be used as the variable to the connection variable I declared in the module, which wil ...Show All

• Visual Studio Express Editions making a cell only numeric

  Hi!!! I’m using the DataGridView control. I add columns manually and I want let the user can enter numeric values only in certain columns. How can I do this Thanks hi, i'm not sure from this but you can try it, datagridview is just a representation of your dataset, you can edit your  datatype for this column in your dataset designer to be integer hopfully it helps ...Show All

• Windows Forms Trapping Form Closing

  Hi, I am trying to ask my program users a Y/N question when they click the close button on any of my Windows Forms. How do I go about this Hi, I used an access database and i datagridview to insert, edit a particular table. how to prompt the user to save any unsaved data when closing the mdi form. thanks to help rd ...Show All

• SQL Server Move stored procs from 2000 to 2005

  It's easy to move the tables, but how do you transfer stored procs and triggers A few ways you can do this. If you want to move a whole database, you can either backup the database from SQL 2000 and restore to 2005, or detach\reattach. If you want to be more selective, you can use SQL Enterprise Manager on 2000 to script out the specific stored procedures\triggers to a script file, then execute the script on SQL 2005 using SQL Management Studio. Jeff. ...Show All

• Software Development for Windows Vista Will there be a new GetOpenFileName API that wraps/calls IFileDialog?

  Similar to the way PrintDlg calls PrintDlgEx behind the scenes in 2000/XP when you don't have a hookproc, is there going to be something similar where you call legacy APIs such as GetOpenFileName and somehow it encapsulates or calls down to IFileDialog (IFileOpenDialog) From what I saw in the PDC video here: http://microsoft.sitestream.com/PDC05/DAT/DAT307.htm#nopreload=1&autostart=1 there is a ton of COM client code that needs to be written and also some knowledge of Shell concepts such as PIDLs, just to bring up an IFileDialog. The presenter mentions that "post-Beta 2" this is going to change By how much Thanks, ...Show All

• Smart Device Development How can i get my application Miscrosoft Signed/Branded

  In Symbian dev applications can be Symbian signed. A quality mark for our custommers. develloping some of of our application for Windows targets. We are searching for a way to say our sustommer look this pplication is Microsoft signed. Any link ou submit website is welcome. Hi, If you have any software of hardware that can run with Microsoft Windows you can get Design for Windows Logo that will be very useful for customer satisfaction aspect. http://www.microsoft.com/winlogo/default.mspx ...Show All

• Visual C# Pending PO's on Great Plains

  Hi   The problem is as follows:   I launches and proceeds with to login with my userid/pass. The moment I clicks on "Pending PO's" a window pop's up as follows:   ============================== Unhandled Exception   Dictionary Not Loaded   EXCEPTION_CLASS_FORM_MISSING   SCRIPT_CMD_FORMDICT ===============================   I am able to successfully login (via my id/pass) via another computer. A new hard-disk and the OS were installed on my computer recently (Great Plains was installed after the OS ...Show All

• SQL Server Is there any way to decrypt the login info?

  Hi all. The new feature of login encryption still tortured me and my company's fellow :( We can't use the server's profile nor server's login audit functionality. The reason is.. they do not want any additional feature to the server even if it's just a small task. So.. I know that self signed certi generated whenever the MSSQL server started. My question is.. 1. Where is that self-signed certification. Is it loaded to memory or physical hard disk. 2. Is there any special 'store' for this self-signed certification I tried to find this certi from all of my store using the certutil.exe but couldn't find this certi. 3. Is th ...Show All