r prasanna vignesh's Q&A profile

• SQL Server Last GASP on "Insert row in table with Identity field, and get new Identity back " ?

  While I have learned a lot from this thread I am still basically confused about the issues involved. .I wanted to INSERT a record in a parent table, get the Identity back and use it in a child table. Seems simple. To my knowledge, mine would be the only process running that would update these tables. I was told that there is no guarantee, because the OLEDB provider could write the second destination row before the first, that the proper parent-child relationship would be generated as expected. It was recommended that I create my own variable in memory to hold the Identity value and use that in my SSIS package. 1. A simple example SSIS .dts example illustrating the approach of using a variable for identity would be helpful. 2. ...Show All

• .NET Development Convert string to int

  Is there anyway to convert a String to Int say if I have String width ="640"; I want it to assign to int dimension=width I don't want some conversion like String char="A" to integer which become 10. Just a straight conversion Is it possible Int.Parse is your friend, other types have similar parse methods for getting them out of strings. ...Show All

• SQL Server "Could not start the SQL Server Integration Services..."

  Running MS SQL 2005 SP1 on Windows 2003 Server SP1 (IA32). Upon rebooting, I get an error that this service failed to start, and when I attempt to start manually, I get the same error: Could not start the SQL Server Integration Services service on the Local Computer. Error 1053: The service did not respond to the start or control request in a timely fashion. Any ideas Have you looed at http://support.microsoft.com/kb/886695/ Thanks, Ovidiu Burlacu ...Show All

• SQL Server How to use a variable from the code on Microsoft Reporting Services 2005

  Hi all. I have a Application developed on VB2005 with the reports (processed local) from Microsoft Reporting Services 2005. I would like to know how can i use the value of a variable to be displayed on a textbox on my report. Thanks for the help. Best regards. dp This is basically what you're looking for: Dim varA As Integer = 123 Dim param As New Microsoft.Reporting.WebForms.ReportParameter Dim paramArr(0) As Microsoft.Reporting.WebForms.ReportParameter param = New Microsoft.Reporting.Webforms.ReportParameter("MyReportParameter", varA) paramArr(0) = param ReportViewer1.ServerReport.SetParameters(paramArr) In your report, you will need to allow it to accep ...Show All

• Windows Forms Adding events tab to a propertyGrid...

  Anybody know how in simple form so even I can understand -Devin I'm not entirely sure, but on the object in question, you have to mark a function as browseable and stuff. See System.ComponentModel. <Browseable>_ Sub DoSomething() ' Enter code here End Sub Cheers, Rick ...Show All

• Visual Studio Tools for Office Outlook 2003 TaskPane ???

  Hello I had a couple of questions to ask. We are using and targetting outlook 2003 using VSTO and C#. Q1. Is there only one built-in task pane in outlook 2003 Q2. Are we allowed to add/display custom task pane in outlook 2003 Q3. Can we add windows form controls into built-in task pane in outlook 2003 Cheers Imran Hi Imran, You can't customize task pane in Outlook 2003, but maybe you can create an windows form that will look like a task pane. Check this post . ...Show All

• .NET Development Interop not working across projects!

  Hi, I am unable to use an Interface defined in one project to extend a COM class in another project. I have used a simplistic example for clarity. To simulate the error create a new solution named COMInterop and use C# Class Library as the type of project. Paste the code below into the class file. using System; using System.Runtime.InteropServices; namespace COMInterop { [ ComImport , ComVisible ( false ), InterfaceType ( ComInterfaceType .InterfaceIsIUnknown), Guid ( "0000010C-0000-0000-C000-000000000046" )] public interface IPersist { [ PreserveSig ] int GetClassID([ Out ] out Guid pClassID); } } No other setting is change ...Show All

• SQL Server still struggling with flat file into multiple tables

  So here's the issue 16 flat files all fixed width. Some over 350 columns. Open flat file 1 extract id and go see if its in table 1, if true update table 1 with first 30 columns otherwise insert into table 1 first 30 columns. goto table 2, lookup id, insert/update next 30 columns...etc..etc..for 10 different tables So I've got my flat file source, I do a derived column to convert the dates, i've got a lookup for table 1, then 2 ole db commands, 1 for update if lookup successful, 1 for insert if lookup fails. How can I pass the id as a param into the update command so it updates where x = 'x' also I need a pointer on doing the next lookup, eg table 2, would I do this as some sort of loop . If you can help great, bu ...Show All

• Visual Studio Tools for Office VSTO 2005 SE Beta, Actions Pane, and Office 2003

  With the release of VSTO 2005 SE Beta, I understand that we get global add-in support for Office 2003. If I use VSTO 2005 SE Beta to create a global Word 2003 add-in, can I create my own custom Actions Pane/Custom Task Panes using managed code Or is this functionality still only supported in 2007 Actions panes are still just document-level, so you can't create them by using a global add-in. They aren't included in the free VSTO 2005 SE beta download--you need the full version of VSTO 2005 to have document-level customizations. Custom task panes are only available in the 2007 release of Microsoft Office. So even though you get tools for them in the VSTO 2005 SE beta download, they won't help with Office 2003. Cheers, Harr ...Show All

• SQL Server Export Database as a sql file

  I am using SQL Server 2005 Express with SQL Server Management Studio Express. I do not find a tool in SQL Server Management Studio Express to convert a database into a sql file. I want a TSQL command to export a database as a sql file. Advance thanks. You can create dynamic SQL to generate the data for the tables.  The SQL would be a SELECT statement that generates INSERT statements as text.  If you use this method, you will need to be careful in order to account for single quotes in the data.  I've always used Generate Scripts for creating the database stucture, but you can look at the sys.objects and sys.columns (SQL 2005) for sysobjects and syscolumns (2000) along with sys.types in order to generate your own ver ...Show All

• Visual Studio Can't locate Web Dev Environment

  For some reason, my VS2005 web development environment has disappeared. I have no options to create a web project whatsoever. I also installed the SharePoint templates so I could build webparts for our MOSS2007 site however, I cannot see those templates either. Does anyone know why this is and how I can fix my IDE so that I can see the web development environment again Thank you for your help. Tim Did you run tools like a registry cleaner that might have corrupted the registry Do you have entries in the Application Log which indicate a corrupted template ...Show All

• SQL Server retrieve AM or PM

  HI Chaps very simple question this time Is there any method availabe to retrieve AM or PM value from date, IN TSQL hoping will get answer shortly regards, Anas you want quick and dirty (filthy dirty)- well here you go SELECT substring(convert(varchar(26),@dtVal,109),25,2) AS AmPm obviously you can use any date format that contains Am Pm and substring appropriately ...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 That is basically true, unless you want to use the WindowsIdentity in your code to determine access to various functionality you have written. Remember however, that many things most applications use can be affected by impersonation: reading/creating a file, querying a database that uses NT authentication, starting/stopping a service - even reading a registry value. So yes, you have it right - but the things your application ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Creating a DirectX Device without a control

  I am building an app to perform offline image processing on the GPU, and was wondering if it is necessary to bind the device to a control. At the moment I have a dummy control used to initilialize the device, which works, but is a bit of a fudge. Passing a null control to the device constructor usually results in problems later on when rendering, even though I am rendering to an off screen texture. Any help would be appreciated. Thanks, Andrew. Some samples in DX SDK use this function (they are command line tools): //-------------------------------------------------------------------------------------- IDirect3DDevice9* CreateNULLRefDevice() { HRESULT hr; IDirect3D9* pD3D = Direct3D ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Advanced shader question

  There is a sample that comes with Nvidia's SDK that produces a texture from a Generate Noise function. The function is not part of any output of any technique for the effect. The sample works within FX Composer. Can anyone point out to me how I can do the same from an XNA project I'm thinking that FX Composer is auto-generating a shader, but I'm hoping the answer isn't as complicated as that. /* Volumetric flame effect based on Yury Uralsky's "Volumetric Fire" http://www.cgshaders.org/shaders/show.php id=39 This revolves a cross section of a flame image around the Y axis to produce a cylindrical volume, and then perturbs the texture coordinates with 4 octaves of animated 3D procedural noise to produce the flame eff ...Show All