Richard Garand's Q&A profile

• Smart Device Development How to get a list of all categories

  Hi, I want to get a list of all Ctegories but cannot find anything about retrieving this infrormation. Has any one an Idea on how to do this in Pocket PC 2003 using POOM Is there a way to get the list of all categories using C#. I want to get all the categories present and thereby present a group like contacts view on the basis of categories. ...Show All

• SQL Server Get Stored Procedures parameter names and types...

  Sorry if I haven't choose appropriate forum for this question. I have MSSQL05 beta. I know how to list all stored procedures in selected database (everything is in localhost). I need to list parameter names and types for selected stored procedure(s). How can I do that or anything that can return parameter names and types It's windows application. I will move to non-beta. Thanks for the reply. This is what I wa ...Show All

• SQL Server Model Designer - ODBC Data Source

  I want to create a Model against an ODBC data source. This is not possible in the June CTP. Will this facility be available in a future release Thanks, Joe Unfortunately the chaps from Partner Tech Support were misinformed. This is a reply from MSAS newsgroup : AS2005 is not going to support ODBC data source. However, you can try to create a data source in SSIS project. Then, add the data source into new AS pro ...Show All

• Visual Basic File Access Denied

  I'm using the following code to look for Access Databases on my computer: For Each foundFile As String In My .Computer.FileSystem.GetFiles( Me .txtSearchDirectory.Text, FileIO.SearchOption.SearchAllSubDirectories, Me .txtSearchText.Text.Trim) lstResults.Items.Add(foundFile) Next I get the following error when I attempt the search: Access to path 'C:\b\sp2' denied.  The part that is confusing me is that I'm an admini ...Show All

• Visual C# How to reference GAC assemblies using VS2005- how funny is this.

  I've just discovered how I add a reference to an assembly in the GAC from a C# solution using VS2005. I find it rather incredible that it is this difficult to do. And I really don't think I've missed anything here. 1. Go into Registry and disable the GAC cache viewer: HKLM\SOFTWARE\Microsoft\Fusion, DisableCacheViewer- set to non zero. You have to do this as the cache viewer prevents you from copying assemblies out fr ...Show All

• Visual Studio Error with DSL Project Setup

  Hi! I've got a simple DSL project up and running and wanted to build the setup project as outlined in 'Walkthrough:Deploying a DSL'. I'm using November 2005 CTP. When I create the setup project, I get the following error: Custom tool error: Running transformation: System.TypeLoadException: Could not load type 'CompanyDesign.meow.DomainModel.PointcutHasAdvice' from assembly 'CompanyDesign.meow.DomainModel, Version=1.0.0.0, Culture=neutral, Publi ...Show All

• Windows Forms set a button in mdi parent form

  Hi I use a MDI parent form in my project and I have some other form (child form)thats open in MDI form. I must use some object in (MDI) parent form but when I set an object in this form (for example a button or textbox) other form go to the back of this object , How can I solve this problem Thanks a lot. Perhaps you could make use of SendToBack() and BringToFront() methods for the controls that you wan ...Show All

• Windows Forms Combo box binding

  Hi, I have 2 forms and a dataset within a test application in VS 2005,  On the first form i have placed a command button.  Clicking this button displays the second form, this contains a combo box. What is the correct/best method of populating the combo box with data from a table in the defined dataset Any help would be appreciated. Thanks combox.DataSource = dataset.DataTable ...Show All

• SQL Server Unable to create SQL Server Mobile Subscription

  I have been following Creating a Mobile Application with SQL Server Mobile: http://msdn2.microsoft.com/en-us/library/ms171908.aspx I have successfully created the snapshot. When performing the following: Configure the publication for Web synchronization In SQL Server Management Studio, in Object Explorer, expand the (local) computer node. Right-click the Replication folder, and then choose Configure Web Sync ...Show All

• Visual Basic Is there a quicker way to get a string of characters out of a string without using split

  I have a collection of file names that appear like this: test.txt.zip.pgp. Is the a better way than using split to get the filename with out the extension.   The "first index of" method is just called IndexOf: Dim filename As String = "test.txt.zip.pgp" Dim filenameWithoutExtension As String = filename.Substring(0, filename.IndexOf("."c))   ...Show All

• SQL Server Left Join Merge problem

  I am having a problem getting the left join merge to work when I attempt to join data that was staged from an Oracle database using the Microsoft OLEDB provider for Oracle with data from an SQL Server 2000 database.  I'm sorting and merging on 2 varchar columns and they never join.  Visually, the data looks like it should join and I can successfully join it in an SQL statement from Query analyzer.  Any ideas ...Show All

• Windows Forms ToolStripTextBox KeyPress Event - Not Getting Enter/Return Keypresses

  Hello, Im processing the KeyPress event of my ToolStripTextBox. I get every character except Enter/Return. How can I add functionality similar to that of the BindingNavigator where you can enter a record number and press Enter to go there Many thanks for your help. Use Click Event trick this will give you same result  " KeyPress Event " , to check Enter/Return Keypresses Private Sub ToolStripTextBo ...Show All

• .NET Development Connection Error

  Hi, I can run my program on some computers, but can not run it on one computer. The error is the following. Could you please help me out Thanks a lot. Error: Error to connect with database : Request for the permission of type 'system.data.sqlclient.sqlclientpermission, system.data, version=2.0.0.0, culture=neutral publickeytoken=b77a5c56193e089' failed. Could you please check the version of .net frame work installed on that machin ...Show All

• Visual C# Class sharing duing the web application running

  Hi, Can I create a class running during the life cycle of web server and share same dataset for all clients Thanks Wilson It depends on what you want to share and what you mean by clients. If you want to share within a single web application (but across multiple users) then static classes and/or instance classes stored in the application object will work. If you want to share data across multiple web ...Show All

• SQL Server Solution: NullProcessing on Dimension keys

  Running in to the following problem Have a dimension (time dimension) with a datetime keyfield. Have a fact table with a date field that is sometimes not filled in. A regular relationship exists in the dimension usage tab between this time dimension and the measure group of the fact table based on the date field. So I set up the time dimension with dimesion property UnknownMember visible, set the NullProcessing property of the keyColumn of ...Show All