yog_23's Q&A profile

• SQL Server Date format - Parameter/Field

  Hi, I have some difficulties to format a Date value in my reporting service. As you know you can use this kind of expression: =DateTime.Parse(Parameters!ReportingDate.Value).ToString("dd/MM/yyyy") But it does not work, and when I just want to use the format property of the textbox content such as " dd/MM/yyyy ", it displays "dd/MM/yyyy", not the real formatted data, this property works for " =Today() " but not for parameters and fields. What is the diffrence Have you an idea to format a Parameter/Field of Date type such as dd/MM/yyyy Many thanks! Vin, You can make your parameter of data type DateTime, this would eliminate the need to parse ...Show All

• Visual C# ErrorProvider makes default language loosing properties...

  Ok, I have a very weird problem. I have a windows forms with some basic controls in it, textboxes, buttons, labels. with only one tab (very basic). My problem is when I'm switching language, i'm loosing control properties in my default language. Here's the behavious when the errorProvider is in my form. 1- I drop a combobox in my form (in the default language), change the dropdownstyle value to dropdownlist. 2- In the initializecomponent, I can see myComboBox.dropdownstyle = dropdownlist; If i switch to another language (IE: Spanish), I can see the myComboBox.dropdownstyle = dropdownlist again in the initilizecomponent. The problem is when i'm switching back to default language, it is adding the dropdownstyle in the sp ...Show All

• .NET Development How to close a TCP connection?

  I used netstat /a and found the socket port I need is already used by a trivial application. How do I write a C# program to programmingatically close down the socket port Any idea is greatly welcome. I will grade your answer. Please help. THanks Well , i haven’t done that, but it sounds interesting, so i looked for it on the internet, and found this: http://www.csharphelp.com/archives3/archive486.html i didn't read all the article, but has a lot about sockets connections, i hope it helps you ...by the way, if you find the solution you are looking for, reply the message so we can all learn ...Show All

• Visual Studio 2008 (Pre-release) Does this model look "feasible"?

  I want to setup a "chain" for a business application model and this is what I envision: Database > TCPchannel or named pipe > DataLayer Service > TCP channel or named pipe > Business Object Service (Using Business Object library) > TCP Channel or named pipe > Business Presentation Service (Using Presentation Library & Business Object Library) > wsHttpBinding with two channels > Certificates only (intranet/ VPN) & server certificate with UserName (typical web access) > Web Hosted Client and Winforms Client (Using presentation library) Essentially, I have a third-party ORM that works very nicely to create the data la ...Show All

• SQL Server print a reportingservices report from c#

  hi all. in my server i have a reportingservice report. how can i print it from c# code How about an approach as demonstrated in: http://blogs.msdn.com/bryanke/articles/71491.aspx ...Show All

• .NET Development Exporting to excell and access

  Hi, I would like to export some information I am storing in some lists to an excell and access database.  I have included Microsoft.Oddice.Interop.Excell and .Access in my references and put the proper using statements, but to tell you the truth I have no idea how to use them.  Can anyone point me to where there is documentation on how to do this and an example would be very very helpful for me to learn a lot faster.  Also is it necessary to do this in COM   I was hoping not but if so then is there a place I could go to learn more about COM in c# Any help here would be great thanks. Matt Ok I have installed it and have played around with it, but I still don't know how to use it. Is ...Show All

• SQL Server date range in DRILLTHROUGH Statement

  Hi, I am trying to implement date range with following MDX query in my report but giving error. Can you please tell me how to filter date range in DRILLTHROUGH Statement ********************************************************************************************************************************* DRILLTHROUGH SELECT ([Measures].[Total Test Count]) ON columns FROM [OLAP Test Cube] WHERE ([Station Name].&[1ST CHOICE EMISSIONS & INSPECTIONS], [Overall Result].&[Fail] ,[Test Date].[Test Date].&[02-01-2006]:[Test Date].[Test Date].&[02-02-2006] ) RETURN KEY ([$Dim Station].[Dim Tests],0) , KEY ([$Dim Station].[Dim Tests],1), ...Show All

• Windows Forms C++ Drag and Drop

  I know there have been lots of questions asked about this, but I can't see any that answer my particular one. I have pictureboxes that I want to be able to move round a panel freely - they contain bmps. I have implemented the dragdrop events of the panel like so: private: System::Void pnlDragDrop_DragDrop(System::Object^ sender, System::Windows::Forms::DragEventArgs^ e) { PictureBox^ picPole = safe_cast <PictureBox^> (sender); picPole->SetBounds(posx, posy, picPole->Width, picPole->Height); } private: System::Void pnlDragDrop_DragEnter(System::Object^ sender, System::Windows::Forms::DragEventArgs^ e) { e->Effect = DragDropEffects::Move; } private: System::Void pnlDragDrop_DragOver(System::Object^ sender, System: ...Show All

• SQL Server help with query syntax

  Hi all, I have been fighting with this query and would like some advice. Please consider the following tables; prod_table widget_number shift date production_time (in minutes) down_table rec_id (ident key) down_shift down_date down_minutes Prod_table (data) widget_number shift date production_time 0001 1 08/02/06 5.00 0002 1 08/02/06 10.00 0003 1 08/02/06 7.00 0004 2 08/02/06 5.00 0005 2 07/31/06 3.00 Down_table (data) rec_id down_shift down_date down_minutes 1 1 08/02/06 3.00 2 1 08/02/06 20.00 3 2 07/31/06 10.00 I would like to combine ...Show All

• Visual Basic need help in making a bingo program.

  i am making a bingo program. yeah, it is easy to randomize 75 numbers, but my problem is that i wanted to randomize 75 numbers so that so that if a number has already been popped up or already been shown will not show anymore. because that's the idea of bingo right if a number is already called, like for example B-10. it will not be called anymore because it has already been drawn. please help me, thanks!~ Use a shuffle sort.  Here it is in a Console application.  Adapt it to your own needs.         Dim temp, mix As Integer         Dim rndarray(75) As Integer         Dim randnum As Random = New Random()    ...Show All

• SQL Server USE MULTIPLE ROLES IN CUBE BROWSING

  Hi, I'm developing a cube browsing aspx application using the OWC11 controls, both Pivot and Chart, associated with Analysis Service on SQL2005. I did quite a bunch of that but now I'm having some troubles to solve the following problem. Using the SSAS IDE, I defined two Roles in a Cube and I defined a filtering function on the dimension in both of them. When I choose each one of them and I check the functionality they works because I can see what I expect to see, only one result from a dimension where the filter is acting in the role definition . But, if I choose both of the roles, and I can do that because it let me select the two checkbox instead of all (having more than two Roles), the filter doesn't work anymore, showing a ...Show All

• Visual C# Centering a button in a form

  I have a simple form that has two buttons that need to be centered in the form. does anybody know how to do it I can't find a resource. I am a newbit to C#. thanks. Hi, You will have to center them manually to start with. Then you can keep them centered if the user resizes the form by anchoring it to all the sides. ...Show All

• SQL Server Attribute relation error

  Hi! I have changed some attribut relations in a time dimension user hierarchy(SSAS2005 SP1), from flexible to rigid. When I try to deploy this change to the server the whole process stops with these strange error messages: "Error 1 File system error: Error opening file; \\ \D:\MSSQL\MSSQL.2\OLAP\Data\SalesStatistics.0.db\Sales Statistics 2.0.cub\Sales Master Cube.0.det\Sales Master Cube.0.prt\35.agg.rigid.data is not a disk file or file is not accessible." The next error repeats several times for all named sets I have built for the time dimension: "Error 2 MdxScript(Sales Statistics Facilities) (174, 6) The dimension '[RecentMonth]' was not found in the cube when the string, [RecentMonth], was parsed. 0 0 " ...Show All

• .NET Development XML

  How to make the page well formated using XML Your post is cryptic. What is "the page" Do you mean "file" or "document" instead of "page" XML is always well formed. If you try to process file that is not well formed with XML tools they should give you an error. Fixing this errors one by one you can format your files according to XML rules. You can open XML files in the VS XML Editor. It should all errors and helps you navigate to the position in the file where you can fix the error. ...Show All

• Visual Basic ActiveX components

  Are ActiveX controls lost and gone forever I have a project where I need to access client side system data and I would LOVE to have them simply access a web site with an ActiveX control to do this, but Im wondering if I'll need to lean on a Windows Form App instead... You can use activex controls in .NET asp or winforms....see if this helps: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dndotnet/html/actxctrlswinforms.asp ...Show All