SparkyCH's Q&A profile

• SQL Server Customising toolbar in the browser of RS HTML viewer

      Dear friends, please help me by commenting on my query. Query:: I want to know  how to customise the tool bar in RS HTML viewer, we can hide or show the toolbar using rc:toolbar= false/true, But i want to customise the tool bar. ie, There is a combo for export formats to export the displaying reports. I want to customise that combo. I can clear the items by removing the extension element in the config of RS, but i want to do it in run time . ie, My different reports should show different export formats simulteniously       You can customize the individual items on the toolbar with the information below: http://blogs.msdn.com/bimusings/arch ...Show All

• Visual Studio Tools for Office How to access "Compress Images" function with VSTO

  Hi there, I'm sure everybody knows the functionaltity to compress Images within Office Documents. With the contextmenu of any image you can access the properties of the image an there is a button "compress". (I've never used the english version of office so I home my translation is correct). Then you can select some options for the compression (crop image, resolution,...) What I'd like to do is, access this functionality with VB.NET in VSTO I've already tried to find it within the Interop.Word Classes but didn't find anything. Does anybody know how to do this Thx in Advance Steve Hi Cindy, I already wondered why the calls generated with the Macro Recorder didn't work. So if this doesn' ...Show All

• Silverlight (formerly WPF/E) Whats the difference of xbap and wpfe?

  When should I use one or the other!! For what kind of applications To add to the mystery I have had this off-the-wall hypothesis, is it true Is XBAP related to ABAP (logic below) Organization seeming to drive policy ( http://www.dmtf.org/home ) Their Visio CIM diagrams explain more than any article I have found Microsoft uses SAP internally to handle their HR Comparing the diagrams over a period of time one notices more SAP components .Net has been moving to the user level for sometime now If someone was going to implement a user management system they would most likely use something similar to their own implementation Oh, not to mention ABAP is the SAP language (notice the similarity xbap v ...Show All

• Visual C++ list boxes and data sources...

  Here is what i am trying to do: listBox1 displays information from a database. when I click on an item in listBox1, listBox2 displays information from another table. However, i try putting this code in: private : System::Void listBox1_SelectedIndexChanged(System::Object^ sender, System::EventArgs^ e) { if (listBox1->SelectedIndex.Equals( "Elves" )) { listBox2->DataSource = "gamestaBindingSource2" ; } else { listBox2->DataSource = "gamestaBindingSource3" ; } } The program runs, but when you get to this section, the following error appears: "An unhandled exception of type 'System.ArgumentException' occurred in System.Windows.Forms.dll Additional ...Show All

• SQL Server import from Access to SQL, not knowing the table format

  I need to import few tables from MS Access to MS SQL but the table structure in Access is always different, as I would like the destination table in SQL to be. Therefore I would like that a table would be created in SQL at runtime, according to the structure the Access table accessed has. i'm not sure about this, but i think you can use the script task to determine the access table schema.  then, you could use this schema information to dynamically create the sql server table. ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Putting a hole in a sprite

  Hi all I am currently wondering how I could put a hole through a sprite "on the fly" during gameplay, such that the background behind will show through Some sort of blending, or combination in the spritebatch class I suppose, but I havn't yet worked out how. Any suggestions Chris J.   The ZMan wrote: If you modify the sprite by setting some of the pixels to have an alpha component then your sprite will draw with the 'hole' This would only work if he had no transparent parts of the sprite except the hole.  If you do have tranparency in another part of the sprite, it can be done by switching between two different sprites (one with a hole one without) or by using&n ...Show All

• SQL Server Help with script and variables

  Hi If I try to run the code below I get the following errors Server: Msg 156, Level 15, State 1, Line 36 Incorrect syntax near the keyword 'view'. Server: Msg 170, Level 15, State 1, Line 51 Line 51: Incorrect syntax near '@month1' . I am not sure why it does not like the keyword view also I am trying to use the variables in the column name of the create table but again it does not like this. -- declare all variables! DECLARE @startdate datetime, @enddate datetime, @enddate1 datetime, @month1 char, @month2 char, @month3 char -- declare the cursor DECLARE call_data CURSOR FOR SELECT dbo.removetime(DATEADD(month, -3, getdate())) as startdate, dbo.removetime( ...Show All

• Visual Basic Is a ColorMatrix the fastest way to edit bitmaps? (LockBits)

  I've made a function that makes bitmaps transparent via a ColorMatrix but now I'm wondering if that is truly the fastest way, because I can see that it takes a while (not that much, but enough to notice) to update the picture when I use a slider to adjust the transparency. Is there perhaps an imageformat that takes an alpha-value for the whole picture instead of per pixel, so that I don't have to use a colormatrix to go through every pixel to update the transparency Edit1: for example, setting the opacity of a form updates instantly, so how can I change a bitmap's transparency that fast in managed code - or is that just asking too much of VB Edit2: LockBits seems to promise better speeds - examples are welcome :) Edit3: okay, I tried b ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Crashing Xbox360 (Transport Issue)

  It seems when I try and load all my assets in at once, the Xbox360 hangs and the PC gets an error stating the 'XNA Transport has encountered a problem and needs to shut down'. Although my game is only 20MB, could this be a memory issue I believe it all stems around this incredibly strange build issue where I have several textures which are exactly the same size but one of the textures builds to double the size of the other textures.  Xbox360 hangs when it tries to load this texture into memory. 1024x576 BMP using (Model, DXT, mipmap) Ah man, I see now, but why would that cause a crash ...Show All

• .NET Development SourceTable and SourceField

  Hi I'm upgrading my code based on DAO to ADO.NET in VB2005 and got stuck looking for SourceTable and SourceField properties of DataTable fields. DAO.Recordset.Fields have .SourceTable and .SourceField properties which tell you the original table/field which provides the data in that particular field of the recordset. This is useful in my application where I am filtering users' queries to the database to see whether I want to allow them access to that particular bit of data.  Although I can imagine that there are maybe other solutions to security issues, I've already built a whole system around this method, and would like for simplicity's sake just upgrade it without changing the methodology. Can anyone advise where to g ...Show All

• Visual Basic converting datagrid control to html table

  I have several datagrid controls in an application i am finishing up on, i need to output the contents to an html file, so i need to convert the datagrid control into a html table, their wouldn't happen to be any easy way of doing this rather then going though cell by cell, extracting the contents and adding it on to a string along with the html code to make it a table is their well from the sounds of it your idea is harder to impliment, i think i'll stick with my idea, i just need some help doing so. Here is my Pseudo Code: - Create a string, start off with the <table> tag - Go though each cell one-by-one - Extract the contents - Wrap the contents in the necessary HTML tags - Append the result to ...Show All

• Windows Forms MessageBox doesn't do anything on Application Exit

  i'm not sure why this is, maybe some of you guys can help me out. i have an MDI application. i have a MDI child inside the parent. i click the "X" of the MDI window to shut down the application. i have a call to MessageBox.Show in the Dispose(bool) method of the child. nothing shows. i put a break point, and i can actually step through it and it hits the line where i show a message box, but it passes through it and nothing comes up. i need this functionality because when the application closes i need to ask a question for each MDI child. it works fine if i close the child inside the MDI parent. is there some event i can listen to or something like that the ApplicationExit event occurs too late. thanks! ...Show All

• SQL Server Nonemptycrossjoin alternative

  Hi, Trying to filter out measure group rows for various conditions of different dimensions to do a sum of a measure This is to be used in a cube calculation (mdx expression), not a mdx select statement. The conditions for the date dimension is <>certain date and <=certain date, and hence the filter returns all member except the matching ones, which is a large set. sum( nonemptycrossjoin( (filter(descendants([Purchase Date].[Fiscal Hierarchy].Members, , leaves), ([Purchase Date].[Fiscal Hierarchy].CurrentMember.Name <> "yyyy-dd-dd" and [Purchase Date].[Fiscal Hierarchy].CurrentMember.Name <= "yyyy-dd-dd"))) , (filter(descendants([Ship Date].[Fiscal Hierarchy].Members, , leaves), ...Show All

• Visual Basic Windows Service - Out of Memory Exception

  I have created a windows service using vb.net which uses a filesystemwatcher to monitoe files in a specifc directory, if images are added to the directory they are resized and saved in a remote directory. The original file is then backed up and deleted from the image directory. The code is as follows Friend Shared Sub ResizeImage(ByVal path As String, ByVal filename As String) Dim asr As AppSettingsReader = New AppSettingsReader Dim sRemoteDirectory As String = CType(asr.GetValue("RemoteDirectory", GetType(String)), String) Dim sBackupDirectory As String = CType(asr.GetValue("BackupDirectory", GetType(String)), String) ' Dim img As Image = ImageFromFile(path) (This was put in as an alternative but p ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Vectors

  Hello, I'm new to vectors and I need to find a way to have the Vector X/Y postions more like a pixel X/Y. Would anyone be able to help me or point me in the right direction What I'm mean is when you well a SpriteBatch to draw at 20, 20 it will draw the texture 20 pixels down and to the right from the top left corner of the game window. I'm hoping to be able to do the same using Vectors. ...Show All