Chris Foley's Q&A profile

• SQL Server Using SQL Function in a sql Schema

  Hi ... I am bulk loading data into a table using a sql schema. I need to change a data from local time to GMT. I would like to use the SQL Function DateAdd(Hour, 5, dtData). Is it possible to access these function from the schema file .... I sort of douht it The other solution is to post process the data after the bulk insert ... Thanks, Chris I don't think user-defined functions are supported. You will have to load into a staging area and do some postprocessing, I am afraid. Best regards Michael ...Show All

• Visual Studio Team System 1.32 Custom Rules not working in 1.35

  We've created some custom rules for 1.32, and they worked fine. But when we try to open the rule dll in 1.35, it tells us the assembly contains no fxcop rules. This happens if we download a working sample rule for 1.32 also..... Anyone have any advice Thanks! David David, As FxCop 1.35 is now compiled under .NET 2.0, you will need to recompile your rules assembly under .NET 2.0. Also make sure that you update your project's references to point to the FxCop 1.35 version of the FxCopSdk and Microsoft.Cci assemblies. Regards David ...Show All

• Windows Forms Radiobutton event handler

  Does anyone know why my radiobutton click event handler is running when I start my program Hi I think you need to set Checked to false in the radiobutton properties window. Hope this helps ...Show All

• Visual Studio Team System PublishRun: Server was unable to process request

  Hi everyone, I get the following errors when the Test Run completes... it seems that permissions may be incorrectly set for this account (against the build server), but everything in the drop phase works fine for other build output, which I find somewhat confusing. Has anyone seen this before MSBUILD : warning : Test Run Failed. MSBUILD : warning : PublishRun: Server was unable to process request. ---> Access to the path '\\90dsdev001\Builds\Kerrisdale\Stable\Compile\Stable_Nightly_20051128.1\TestResults' is denied. MSBUILD : warning : Test Run Failed. MSBUILD : warning : PublishRun: Server was unable to process request. ---> Acc ...Show All

• Windows Forms DataGridView Detail Row Saving

  Code snip: Me .BindingSourceDrivers.DataSource = MyDataSet.Tables( "Drivers" ) Me .BindingNavigatorDrivers.BindingSource = Me .BindingSourceDrivers Me .DataGridViewDrivers.DataSource = Me .BindingSourceDrivers MyDataSet.Relations.Add( "DriverToCars" , MyDataSet.Tables( "Drivers" ).Columns( "ID" ), MyDataSet.Tables( "DriverCars" ).Columns( "DriverID" ), True ) Me .DataGridViewDriverCars.DataSource = Me .BindingSourceDrivers Me .DataGridViewDriverCars.DataMember = "DriverToCars" Chris, Did you get an answer to this I'm having a very similar problem ...Show All

• Visual Basic databindings to datagrid

  How do I bind a datarow array (mydatarow()) to a datagrid (mydatagrid) at run time. Something like: mydatagrid.databinding ... HI Atin I think Better you can create a datatable, Put all the Rows in the DataTable. Then you Can Assaign DataTable to DataGrid as usual. ...Show All

• Windows Forms Why in my setup project is my shortcut underlined in error?

  Hi I have created a shortcut in my desktop folder on my target machine. For some unknown reason it is underlined in blue and my setup project fails to compile.  What is wrong   Thanks  I have placed an Icon in there and yes it exists.  This whole problem is annoying. Something so simple but its not working.  ...Show All

• Smart Device Development formatting a datagrid

  Ok - I have a datagrid bound to a SqlCeDataAdapter grid.DataSource = myDataSet.Tables(0) I want to apply a dataGridTableStyle to format the grid nicely ts.MappingName = "procedureHistory" Dim procedureDate As New DataGridTextBoxColumn procedureDate.MappingName = "procedureDate" procedureDate.HeaderText = "Date" ts.GridColumnStyles.Add(procedureDate) etc etc for the other colums grid.TableStyles.Add(ts) But it doesn't work - the grid still has the default formatting -  I guess it's cause the datasource.tables property just references an index, and this doesn't correspond to the ts.mappingName perhaps To go back a st ...Show All

• Visual FoxPro Bulky package

  My app takes up less than 0.5 MB and the required ressoucefiles (vfp8t.dll & vfp8renu.dll) take up 4.8 MB and yet the setup.exe created by Installshield Xpress is more tha 10.5 MB large. Any suggestions to how I can reduce the size of my distribution setup file The setup is larger than just the runtime, because the runtime itself has dependencies, too. For instance, it uses the MSVCRT70.DLL or MSVCRT71.DLL libraries, might require the XML4 parser, and so forth. What I'd probably do is provide one setup that contains your application and the VFP runtime and one setup that contains just the application. Th ...Show All

• Visual Studio Team System permission problem ..

  When i create a Team Project the following error comes up. Even though i have a adminconfiguration permission ... " Error Access Denied: User ODESSAPDC01\chandrasekharan.k needs the AdminConfiguration global permission(s). Explanation Access Denied: User ODESSAPDC01\chandrasekharan.k needs the AdminConfiguration global permission(s). " The following permission list for my user on the TFServer shows that i have the permission ... but still ... i could not create the project ..... and also I have explicitly used the tf utility to give adminconfig permission ... C:\Program Files\Micr ...Show All

• SQL Server How to create a new SINGLE file .mdf in SSMS?

  It is easy to create a new .mdf in VS "add new items" or via the connection GUI. How do I do that in the full version of SSMS(connecting to the SSE instance of course) What about if there was no SSE, only a full version server instance. I know I can attach an existing .mdf, but what about creating a new one   Right click on the databases folder in Object Explorer and select New Database... The default in the UI is to create a database using a single .mdf data file and a single .ldf log file. It isn't possible to create a database without a log. If you want to do this outside the UI, ...Show All

• Visual Basic Visual Basic 2005 MenuStrip RadioCheck Properties

  I can't seem to find the radiocheck properties for menustrip menu's it is in earlier visual studios version. does anyone here know anything about that I would surely appreciate the help. ...Show All

• SQL Server Strange behavior with Calculated Members

  After creating a Calculated Member like this: CREATE MEMBER CURRENTCUBE.[Product].[Family Line Product].[Line].&[PCs].[XPC] AS AGGREGATE({ [Product].[Family Line Product].[Family].&[Business PCs], [Product].[Family Line Product].[Family].&[Home PCs] }), FORMAT_STRING = "#,#.0", VISIBLE = 1; I would expect to find this Member only in the [Product].[Family Line Product].[Line].&[PCs] Member Identifier. But this Calculated Member is shown in every Member Identifier of the [Product].[Family Line Product].[Line] Levels when using the Dimension Browser of SSAS. Hi Christian, ...Show All

• Windows Forms ContextMenuStrip for treenode

  Hello, I'm using a contextmenustrip for a treenode; how do I figure out which tree node currently has the context menu strip for it I'm trying to use the contextmenustrip location, but it references the wrong tree node. Thanks. Hey Jason, Just add the following event handler to your TreeView (the control which holds all your nodes) control (switch the code to C# language): Private Sub YourTreeView_NodeMouseClick( ByVal sender As Object , ByVal e As System.Windows.Forms.TreeNodeMouseClickEventArgs) Handles MyTreeView.NodeMouseClick YourTreeView.SelectedNode = e.Node // this en ...Show All

• Windows Forms All Users and Admin Rights

  I published a .Net Windows application to our company's intranet. I see that it is installed for a particular user. Is there a way for ClickOnce to install for All Users If not, does a user have to have Admin rights in order to install a ClickOnce app ClickOnce apps are meant to be isolated and low impact hence they're installed on a per-user basis only. There is no provision for machine-wide application install with this release of ClickOnce. A user does *not* require admin rights to install a ClickOnce app. Users with limited privilege can install and update ClickOnce apps. I would actually go a ...Show All