siavoshkc's Q&A profile
SQL Server HowTo RoundDown
I need to have some calculations for business rules with ROUNDDOWN. There is no Rounddown or Floor function in MDX - are there any possibilities to create some function. Excel is not available on the server and VBA!ROUNDDOWN or VBAMDX!ROUNDDOWN does not work to Its Analysis Services 2005 SP1 Enterprise on Windows 2003 - 64 Bit Editions. Thanks HANNES You can create stored procedure using .NET which will do the required operation. For examples of how sprocs can be done for AS - you can check this project: http://www.codeplex.com/Wiki/View.aspx ProjectName=ASStoredProcedures HTH, Mosha ( http://www.mosha.com/msolap ) ...Show All
.NET Development XML in Excel and the Spreadsheet Component
Hi Trying to use Excel XML schema to export the data. Giving below the section of my generated code........... <HTML xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet"> <HEAD> <META HTTP-EQUIV="CONTENT-TYPE" CONTENT="application/vnd.ms-excel; charset=ISO-2022-JP"> </HEAD> <BODY> <ss:Workbook> <ss:Worksheet> <ss:Table> <ss:Column c:Caption> <ss:Row> <ss:Cell> <ss:Data ss:Type="String">D22</ss:Data> </ss:Cell> <ss:Cell> <ss:Data ss:Type="String">NAME</ss:Data> </ss:Cell> ...Show All
Smart Device Development can vb.net 2005 support visual fox pro database & tables????
i had symbol mc50 pocket pc. And i m using vb.net 2005. Can it support visual fox pro database & tables. Can giv me some sample code that manage add, delete, update, dataset, connection string. Thanz Sort answer: no, you can not as there's no NETCF compatible ADO.Net provider for VFP. Longer answer: go through Web Service as proxy to connect to VFP (or any other desktop compatible database), please search for details. ...Show All
Smart Device Development extending smartphone sdk form designer
HI, I am trying to extend visual studio 2005 and I want to create a project type related to smartphones and pocketpc. I was looking into the form designer being used by the smartphone, pocket pc and if you hide the skin (by using the option in context menu) , the form looks the same with different size. so could anyone tell me how can i use this form to create a new type of project using this flat form designer. Also the controls when dragged onto this surface also appear flat (as they appear on a smartphone and pocket pc). So can anyone tell me how this form can be extended so that i can use it in my project which will be a generic project for all types of smartphones and pocket pc. Moving to Smart Dev ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Difference between Update() and Draw()?
This may sound a little basic. Fundamentally, I'd like to know why there are two methods and not just one What would happen if you put all your logic code into the Draw() method for example, or all your drawing code into the Update() method Don't do this, if you want the built-in timing system to work correctly. If Draw doesn't complete within its time, Update will be called multiple times without Draw being called to allow your gameworld to catch up. ...Show All
Software Development for Windows Vista Problem creating com instance when not running as admin
I have an application which is using a com object written in c#. When i run my application as admin, everything works as intended. However, when I run my app without admin privileges, it seems that the application cannot create an instance of my com object. Does anyone have an idea why this is happening ...Show All
Visual Basic createing a text file
Hi...i used to play around with vb 6 and now i have 2005 and i gt say...i can learn chinese faster then i can learn it... can someone show me how to create a simple text file in the programs folder and can you explain the code so i can learn how it workts..thanks! ok good i got it. Does this mean when i make a exe of it and send it to people, that the file will be made where ever the exe is and can you show me how to print to the file and read from the file (it will be one word per line which iam going to use as array) eg: bob fred cow chicken so first i want to read it to EOF and save them as array then later print again. print as output with the same data or new data (not append i want to erase it all). ...Show All
Visual Studio Drilldown feature only for Remote mode?
Hello, I was just wondering if the drilldown (expand/collapse node) feature can be enabled when using the ReportViewer in Local Mode (No ReportServer) I was able to easily setup a report with drilldown when designing it on the SQL Server BI Studio for Reporting Services but I could not do the same when creating a report within VS 2005 using the ReportViewer. Can the drilldown feature be enabled for local mode Yes, drilldown in local mode should work. Did you look at http://gotreportviewer.com/MasterDetailDrilldown.zip -Albert ...Show All
Visual Studio 2008 (Pre-release) Trigger on value changed
Lets say I have the following TextBlock < TextBlock x:Name = " countText " Text = " {Binding Path=Count} " FontSize = " 12px " FontWeight = " Bold " > </ TextBlock > I’ve spent all night trying to figure out how to use a Trigger on this TextBlock so that when the Text changes, a storyboard will begin. Can someone push me in the right direction Many thanks -Steven do you mean textblock or textbox here I am pretty new to this but thought that textblock was just static text and did not receive input I may well be wrong. anyhow with textbox you can create an event and in the xaml include TextChanged="the ...Show All
Visual Basic Problem in VB Designer
Hello all. Hope you can help me with this, i've been searching the forums for the past hour with something the same, however haven't found anything. I know lots of you have had problems with the form designer giving errors and refusing to show the actual form, mostly because of some transition in software i take it (i aren't a Full time programmer, its just a hobby.) My problem is similar, vb refuses to show me my form and now i have even more problems. the last thing i did before this happened was try to add an imagebox to the form. Heres a few errors i get: every label i have is no longer declared event 'load' cannot be found - My other problem is, i managed to close the designer window during this problem and i cant remember how to get ...Show All
.NET Development Did I understand Impersonation correctly:
Impersonation is only important to access resources outside the application like files and directories on the network and external assemblies and business logic that implements security policies. So Impersonation has no importance in terms of accessing and using the application itself. thank you Both of your scenarios can use WindowsIdentity (and the group membership). Impersonation is the act of changing the effective userId to something else, so impersonation can affect (but is not normally used for) both of those situations: ...Show All
Visual Studio Tools for Office Filtering programatically an existing PivotTable
Hello experts. I have an Excel worksheet that has a Pivot Table, what I need is to use VSTO 2005 to filter the data. Is there any way to acomplish this Thanks! Hi, The following shows the basic way to filter an existing PT: Friend Sub Filter_PT() Dim p_wbBook As Excel.Workbook = Globals.ThisAddIn.Application.ActiveWorkbook Dim p_wsSheet As Excel.Worksheet = p_wbBook.Worksheets( "PT" ) Dim p_ptTable As Excel.PivotTable = p_wsSheet.PivotTables( "PTTest" ) With p_ptTable .PivotFields( "CategoryName" ).CurrentPage = "(All)" With .PivotFields( "CategoryName" ) .PivotItems( "Condiments" ).Visible = False ...Show All
Visual Studio Express Editions Use button to change selected Textboxes to Readonly
I have successfully (with heaps of help from this forum) coded a button to toggle the readonly property on/off on one of my forms using the code below Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click For Each c As Control In Me.Controls If TypeOf (c) Is TextBox Then Dim currentcontrol As TextBox currentcontrol = c currentcontrol.ReadOnly = Not currentcontrol.ReadOnly '//Toggle readonly '//Change Formatting If currentcontrol.ReadOnly Then currentcontrol.BorderStyle = BorderStyle.None Else currentcontrol.BorderStyle = BorderStyle.FixedSingle End If End If Next End Sub ...Show All
Visual Studio Team System CTP5 - Import Schema Problem
I am testing CTP5 against a database with approximately 50 tables. About 5 of these tables have a schema prefaced in their name. For example, I have table names like: ClientBilling.TransactionMaster ClientBilling.TransactionDetail None of these 5 tables were imported into my project when I did an Import Schema. The 45 or so tables that do not have a schema prefaced in their name (they are dbo) imported successfully. Is this a known limitation with CTP5 or is there something else I need to do Amos. Hi Amos, Was the ClientBilling schema successfully imported into the project You should be able to find it under the Security\Schemas folder in the Schema View. Thanks! -Jon ...Show All
Visual Basic How do i use ASCII code to display characters?
Hi! I want to use ASCII to display characters I.E the letter "T" has the ASCII codes: HEX = 54 DEC = 84 OCT = 124 . So i wonder how i can use this information to display the character T in a string. Like get T in a message box. Thnx Hi You can use the chr function in the Microsoft.VisualBasic namespace and pass the decimal value to retrieve the string "T": MessageBox.Show(Chr(84)) HTH ...Show All