Wa-gee's Q&A profile

• SQL Server complex SQL (for me)

  Hello, Lets look at this table : CREATE TABLE [dbo].[TableHisto]( [Id] [int] NOT NULL, [Week] [nvarchar](50) COLLATE French_CI_AS NULL, [Project] [int] NOT NULL ) ON [PRIMARY] GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Identifiant d''enregistrement' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'TableHisto', @level2type=N'COLUMN', @level2name=N'Id' GO EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date de l''enregistrement' ,@level0type=N'SCHEMA', @level0name=N'dbo', @level1type=N'TABLE', @level1name=N'TableHisto', @level2type=N'COLUMN', @level2name=N'W ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Mesh animation with directX (c#)

  Hi, that makes one week that I try to animate tiny.x in a window without result using c#. I looked on many forums and i just found pple who are in the same situation as me...The SimpleAnimation example in the directX SDK is helpless, I get an Direct3DXException when I try to insert the code wich handle what I need from the SimpleAnimation example. i have an Exception somewhere here : // Use ConvertToBlendedMesh to generate a drawable mesh MeshData data = mesh.MeshData; data.Mesh = mesh.SkinInformation.ConvertToIndexedBlendedMesh(data.Mesh, flags, mesh.GetAdjacencyStream(), mesh.NumberPaletteEntries, out influences, ...Show All

• SQL Server Generating XML based on XMLSchema in a SQLSERVER2005 Stored procedure

  Can a stored procedure in SQLSERVER 2005 generate XMLdata based on the schema Are there any features in SQLServer2005 to achieve this Please suggest me in this regard. Thanks vaishu Yes this is possible. Michael Rys' article about FOR XML support and the Xml datatype shows examples of this: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnsql90/html/forxml2k5.asp ...Show All

• Windows Forms DataTableAdapter Update

  Hi, I tried the following. I added a SQLExpress Datafile to my app. Therein a simple table and then I built (with the desinger) a DataSet. After draging one Edit to my form and databinding it I can change the values in the table of the dataset. With EndEdit() it marks the row as modifyed. Till now it works fine. Now to the update. I can iterate through the modifed rows and use the generated Update(Field1, Field2, OriginalKey, NewKey) method. The rows are marke as unchange, the data is changed in the SQL Table. When I try the Update(DataSet) or Update(Table) nothing happens. Only in the sourcefile of my Dataset 2 methods are called (more ...Show All

• Windows Forms Prevent insert in a datagrid

  My first question: Is it possible to hide the '*' insert row in a datagrid    My second question: What's the best way to display an uneditable datagrid of a list of data   I won't need to edit it, but I would need to click on the column headers and sort it in the order of that column.   Kinda new to winforms; I miss my&nbs ...Show All

• Visual Basic VS 2005 and crystal reports

  Hello, trying out CR for the first time and using VS 2005. I have made a basic report with no database information just my name the date and my address. It runs fine but when it opens I want it to default to PDF not to the webform that it does which then allows me to export to PDF, excel etc. This is my first time using CR so if anyone knows of a how to doc or if it is just one line of code I would appreciate the help. Thanks Hi, If you want to display it directly in PDF you should not use crystal reports. Search the web for PDF writting classes. Here's a tutorial on how to do that. How To Generate PDF Fi ...Show All

• SQL Server Encryption By Passphrase

  I am investigating methods of encrypting data in a large number of databases. It seems to me that encrypting by passphrase would be optimum because it would prevent me from having to create all those database and symmetric keys on the various databases (there wil lbe dozens of them). Can anyone give me any advice as whether or not using encryption by passphrase is a good secure method of encrypting sensitive data in a large-scale production environment I would most likely create a unique passphrase for each database and pass it to a stored procedure as an imput parameter. Thanks, Al If you en ...Show All

• Visual FoxPro OWC11.PivotTable

  I've tried to play with MSGraph for some time and after not getting very far yet (although I got some graphs) I downloaded MS Office Pro 2003 enterprise Edition and found out that there seem to be richer controls out there. In particular I am trying to work with OWC11.ChartSpace , OWC11.PivotTable and OWC11.SprreadSheet . I have resigned to the fact that I would have to use MS Excel Spreadsheet as an interim container between my tables and the graphs (Marcia will be thrilled at my defeat:) ). I am finding it difficult to figure out how to populate spreadsheets . There are a number of suggestive properties like OWC11.PivotTable.DataSou ...Show All

• Microsoft ISV Community Center Forums Newsbyte: VSTO "Cypress" Office 2007 add-in for Visual Studio 2005 Announced

  If any of you have been following (or are attending) TechEd this week, you might have already heard about this. "Cypress," a Visual Studio 2005 add-in is designed to enable developers to build applications targeting Office 2007. Since VSTO might be of interest to many of you as an alternative to VBA going forward, I just wanted to let you know about the new Channel9 video on this topic: http://channel9.msdn.com/Showpost.aspx postid=201396 . I've heard that a beta version is due out sometime this summer. You can check out the dedicated VSTO forum at: http://forums.microsoft.com/MSDN/ShowPost.aspx postid=45913 ...Show All

• SQL Server Extracting XML data from SQL 2000 to SQL 2005 database table.

  Hi, We need to extract data from XML that is contained in TEXT columns in Sql Server 2000 database table. Can this be done easily with SSIS (NB we cannot use schemas easily with our data) Please kindly provide us the solution in order to resolve this problem. Thanks   VDeevi wrote: Hi, We need to extract data from XML that is contained in TEXT columns in Sql Server 2000 database table. Can this be done easily with SSIS (NB we cannot use schemas easily with our data) Please kindly provide us the solution in order to resolve this problem. Thanks What methods have you tried so far and why do they fail -Jamie ...Show All

• Microsoft ISV Community Center Forums VBA for Powerpoint

  Hi, I have been asked to modify a powerpoint presentation so that from a series of jpg files, one appears on the screen and then after a specific time period disappears and is replaced by another; this being a continuous loop on one slide only - like a photo tour. I have the following code, but need to get it up and running. Any suggestions: Sub ImportABunch() Dim strTemp As String Dim strFileSpec As String Dim oSld As Slide Dim oPic As Shape strFileSpec = C:\PFS Pictures\beach party *.PNG 'Ex. on a PC: C:\My Pictures\Flowers\*.PNG strTemp = Dir(strFileSpec) Do While strTemp <> Set oSld = ActivePresentation.Slides. Add ppLayout ...Show All

• Visual Studio Uninstall Express (release) to install Standard Edition

  Hi there, I apologize in advance that I'm probably asking a question that has already been answered: do I uninstall VB Express and other components before installing VS Standard Thing is, there are about a thousand posts dealing with uninstalling BETA's but I cannot locate the correct procedure for the final release Express edition. Do I uninstall SQL Server Express, VB Express, .Net 2.0 And in what order Or can I simply uninstall VB Express only, since the Standard edition requires the other two anyway Or do I leave it up to Standard to figure out what to do, without uninstalling anything Again, I am sorry if this question has b ...Show All

• Software Development for Windows Vista SetState - how to create a Role Based one?

  Hi all, For a current project, I'm wanting to create a Role dependant SetState class (ideally). The situation: 2 roles - user + manager 3 states - A -> B ->C   (for a manager A->C is possible) StateA will listen to the same event (e.g. Approve) for both Manager + User. For Manager - we want to go to C For User - we want to go to B So....my thoughts - wouldnt it be great to have a SetShape that had some Role dependant collection of 'TargetState' properties.....object model seems pretty tight around here. Question: Why is the SetState class sealed I need to respond to the same Raised Event, but produce different outc ...Show All

• Visual Studio ReportViewer Drillthrough Problems

  Using VS 2005 B2 and C#. I'm attempting to create a UserControl that includes the ReportViewer.  The UserControl is in a dll. From what I can tell, if you use a dll, the viewer can't find the embedded report resource.  I've overcome this by loading the report resource manually. My problem is that I can't seem to configure a drillthrough to another report embedded in the same dll project.  (I've tried the report name ("Report.rdlc") and the qualified name ("Project.Report.rdlc")).  When I run the report, the report doesn't recognize the drillthrough--I don't see the pointer (no little hand) and whe ...Show All

• SQL Server How to code DateTime-Literal in SQL Server

  Hi, I'm a newbee to SQL Server. I have a very simple question to you experts: How should I code a literal of the "datetime"-Datatype For Example in the VALUES-clause of an SQL-statement. I have tested several "formats" ('20.04.2006 11:15:00' with an 4-digit year enclosed in single apostrophes) but all i earned is an exception! Any help very appreciated! Thanks in advance and best regards Reiner PS.: I'm using a german-localized database (thus the date-format dd.MM.yyyy). I am not familiar with the german localized database, but I have some guesses... You are doing ...Show All