Alan S's Q&A profile

• .NET Development Conversion failed when converting datetime from character string.Hi Jeff I get this error for each variable

  ms visual studio 2005 sql erver 2005 I originally posted this question at experts-exchange without resolution http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_22069012.html http: / / www. experts- exchange. com/ Programming/ Programming_ Languages/ Dot_ Net/ VB_ DOT_ NET/ Q_ 22068922. html I get the following error when trying to insert into db from web app have tried.... txtrequireddate.Text.ToString("dd-MMM-yyyy ") reqrddate = Convert.ToDateTime(txtrequireddate.Text) reqrddate= CDate(txtrequireddate.Text) Server Error in '/' Application. ---------------------------------------- ---------- ---------- ---------- ---------- Conversion failed when converting datetime from character string. Description: An unhan ...Show All

• SQL Server Using Filter in Calculated Measure MDX Expression

  Hi there, I want to create a calculated measure that uses a filter. And the Filter references a Fact Table. This is just an idea of what my goal is: Filter([FactSession],{[Measures].[LENGTH] > 500}), [Measures].[LENGTH] / [Measures].[Fact Session Count] but of course this doesn't work. Both measures come from the Fact Table "FactSession". I guess a problem is by using in the SET from the Filter Function. Thank you for your help! Greets Claudio [Internet Sales Order Details] dimension has a "fact" relation to the Internet Sales measure group, because it is based on the fact table for that measure group. You could adopt this approach in your scenario, but performance may be poor ... ...Show All

• Visual C# Execute a DLL in Client side from internet

  I have a .net assembly(DLL) in a Linux box. And a html page in it. The Linux box will not know anything about the .net assembly. The client will request this Linux box web server. The html page will be rendered. The client has the CLR. On clicking the button it has to download the .net assembly(DLL) to the client and execute it in the client side. Is that Possible (sounds possible using trusted zone and sites ) Your comments will be highly appreciated executing code on a client's computer via a webpage isnt exactly the safest thing to do. whats wrong with executing the dll on the server why does the dll need to be on the client box ...Show All

• Windows Forms Loading Image (Visual C# 2005)

  Hey, I after these lines of code what should I put to make it load the image into a PictureBox openFileDialog1.DefaultExt = "*.gif" ; openFileDialog1.Filter = "Gif Images (*.gif)|*.gif|JPG Images (*.jpg)|*.jpg|TIF Images (*.tif), (*.tiff)|*.tif|PNG Images (*.png)|*.png|BMP Images (*.bmp)|*.bmp" ; openFileDialog1.InitialDirectory = "MyDocuments" ; openFileDialog1.CheckFileExists = true ; openFileDialog1.CheckPathExists = true ; Thanks :) if openFileDialog1.ShowDialog = DialogResults.OK then   pictureBox1.Image = System.Drawing.Image.FromFile(openFileDialog1.Filename) ...Show All

• Visual Studio 2008 (Pre-release) Create Annotation for XSD

  I have a relatively complex schema that was converted into a DataContract. In doing so, I lost the ability to do somethings like constraints, which I will have to do in Business logic. I would like to convey the constraints to the end consumer through the use of annotation. Is there any way to annotate the XSD that is being generated I would like to do something like the following and have it show in the schema. Thanks, Dave [ DataContract ] public class Person { private string _firstName; private string _lastName; public Person() { } public Person( string first, string last ) { this ._firstName = first; this ._lastName = last; } [ Dat ...Show All

• SQL Server Javascript Error When trying url access

  Hi, i have a problem with the rs 2005, using url access to call a report: --------------------------- Error --------------------------- Error: 'RSClientController' is undefined Calling a report from the reportmanager works. The rs2005 runs on a machine with a parallel installed rs2000. I configured the virtual directory to machinename/reports2005 & machinename/reportserver2005. When i debug the clientscript i see that he requests a "/ReportServer2005/Reserved.ReportViewerWebControl.axd OpType=Resource&Version=9.00.1399.00&Name=Scripts.ReportViewer.js" and it seems that he doesn't get the jscript file. I tried the solution with the axd-mapping, which an user posted here before but it didn't worked for ...Show All

• SQL Server Write back with UPDATE CUBE in SSAS2005

  Hi, I have got the following problem with the write back (via UPDATE CUBE MDX statement) in SQL Server Analysis Services 2005: We want to write the value 12000 for the 4th quarter based on the existing value of the 3th quarter. Existing values for the 3rd quarter: 3rd Quarter 6000 July 3000 August 1000 September 2000 We expect the following values for the 4th quarter (like in SQL Server Analysis Services 2000): 4th Quarter 12000 October 6000 November 2000 December 4000 But the UPDATE CUBE statements writes the following values: 4th Quartal 12000 Octobe ...Show All

• .NET Development Why doesn't System.Array have an indexer?

  I'm probably missing something here, because my all of my searches came up with nothing. It seems only natural for Array to have an indexer. But instead, we have to use Get/Set Value(). Why is that Note how GetValue() peters out beyond 3 dimensions and gets very inefficient after that, requiring passing passing a array of indexes. I can think of only a few reasons why System.Array wasn't declared abstract. CreateInstance() for non-zero lower bounds perhaps... ...Show All

• Visual Basic How do I use a dynamically registered font?

  In VB2005, I am registering an application-specific font when the app starts up, and de-registering it on exit. I'm using this code to register and de-register the font: ' Register the font Dim FntRC As Long = AddFontResource(fontFileName) SendMessage(HWND_BROADCAST, WM_FONTCHANGE, 0, 0) ' De-register the font RemoveFontResource(fontFileName) SendMessage(HWND_BROADCAST, WM_FONTCHANGE, 0, 0) This all works fine.  After registering the font, if I start up Word, the font is available, and after de-registering the font, it's no longer available. The problem I have is that I don't know how to use the font once it's installed. I've tried this trivial example, but it doesn't work: Dim aFont As Font = New Fon ...Show All

• Visual Studio Team System RequestFailed: Context parameter '$HIDDEN1.__LASTFOCUS' not found in test context

  Hi, I am having web application developed in VS 2005 which contains more tabs contains more than one user controls, repeaters(The tab itself a repeater control).When you complete one tab information,the next tab will be visible. I am getting the following error while clicking the continue button(I have disable all the relevent javascript and manually the functionality works fine).<<I have used Webtest for recording purpose>> RequestFailed: Context parameter '$HIDDEN1.__LASTFOCUS' not found in test context The recording was successful but play back results the above error. Please help me in thios regard. Thanks, Madhusudanan The above link gives information about __V ...Show All

• Windows Forms lost disk

  I work for a small business. We sent a server (2003 standard edition) to out Mexico facility and the disk was lost in transit. What are my options We have the CD key but no disk, how do we get a new one ...Show All

• SQL Server MDX query with filter clause

  Hi, I have the following MDX query which is supposed to return the number of records with Actual time > TargetTime for each customer, location and editor. Actual Time and Target Time are measures on the Fact table defined in minutes and represented by integer values. The hierarchy I have created is Customer Name Location Name Editor Name The MDX query I have written is: Count ( filter ( Descendants ([DimCustomer].[Customer_Hierarchy]. CurrentMember ,[DimCustomer].[Customer_Hierarchy].[EditorName]), [Measures].[ActualTime]>[Measures].[TargetTime] )) But this query gives me the number of customers rather than the number of records with ActualTime > TargetTime for each customer, location, edit ...Show All

• Visual Studio Express Editions Question about dataset

  Hello I want to add data to my foreign table being in relationship programatically . How can I do that For primiary table I do like that: ... object [] detailsRecord = new object [] { TextBox1.Text, TextBox2.Text, TextBox3.Text, DateTimePicker1.Text}; this .DataSet.Tables[ "details" ].Rows.Add(detailsRecord); ... detailsBindingSource.DataSource = DataSet.Tables[ "details" ]; Hi, Can't you also do the same for your foriegn table given the fact that both of your foreign and primary tables are located in your database, you can rows in the same way as your example. cheers, Paul June A. Domag ...Show All

• SQL Server Slowly Changing Dimension "Wizard". Is it bobbins?

  On the face of it, the Slowly Changing Wizard seems a great idea, but is it really any good in the longer term After you have selected your Type 1 and/or Type 2 changing columns ... then you have "customised" the generated data flow and carefully saved it ... how do you change the column definitions in the future If I want to add another column and make it Type 2 how do I go about it If I run the "Wizard" doesn't this just destroy all my previous customisation work I have tried looking in the .dtsx xml file ... hmmm. I notice it's not really editable without some inside information. All those magic numbers in there ... I've fallen foul of them in the past with cut/paste or trying to INSERT a data flow task on ...Show All

• Visual C# hide or visible=false do not work

  hi to all; i have created a C# applicaiton Windows Forms app and i dont want it to show the Form itself.. to do this. i used in Form Load method this.Visible=false; it didnt work i used this.Hide(); again it didnt work.. then i used these codes in Initialize component method but unfortunately again didnt work.. how will i prevent my form to be seen.. thank you for the information Soe, i did hide the form with opacity attribute and now trying to create a setup project for my application to be able to put it on startup menu which will let it be launched as son as the PC is turnned on.. Thanks.. ...Show All