KimberlyL's Q&A profile

• SQL Server Using Variables for file locations

  Hi, I am trying to write a procedure to create a certificate and back it up to a file location that is passed in as a variable but i keep getting syntax errors. My TSQL is the following: ALTER PROCEDURE [dbo].[LoadCertificate] ( @certLocation nvarchar(MAX) ) AS SET NOCOUNT OFF; PRINT @certLocation CREATE MASTER KEY ENCRYPTION BY PASSWORD = 'password' CREATE CERTIFICATE Cert01 FROM FILE = @certLocation Any ideas on how to do this would be appreciated. Thanks, Ewen Try using dynamic sql like this: ALTER PROCEDURE [dbo] . [LoadCertificate] ( @certLocation nvarchar ( MAX ) ) AS BEGIN SET NOCOUNT OFF ; PRINT @certLocation DECLARE @certStmt nvarchar ( 1000 ) SELEC ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Xact to get soudn data

  I was wondering if any one could tel me how to get at the currently playing sound data in XACT, I want to try my hand at writing a simple spectral analyzer to learn XNA, with the hope of throwing together a couple simple visualizers that can run on both platforms. My goal is to either play a wav/mp3 file in the ap and display it in real time, or better yet, play it in a different applicaiton and display the results in real time. Thanks, E- ...Show All

• Visual C++ Running a program from code

  Hi, How do I call another external program within the code For example, at the GUI, the user just need to key in program exe plus the commandline arguments. I wish to code this using managed VC++ .NET 2.0 Thanks in advance! Use the System.Diagnostics.Process class. ...Show All

• Windows Forms How to insert, update, delete using DataGrid ?

  Hi I am develoing a C# and MS Access application in which I have to display table rows and columns in a DataGrid AND in the same form I have to perform insert, update, delete operations. Displaying the table's contents is not a problem but I need help in implementing insert, update and delete operations. Thanx. Hi, Defaultly you can edit the values in the datagrid unless you disable the grid. So the problem here lies on the delete and add. In the add button you can directly add a newrow to your datasource and it will be reflected on your datagrid. Same also with delete: // On your AddButton_Click event    DataRow dr = dt.NewRow();    dt.Rows.Add(dr);    dataGr ...Show All

• Visual Studio How to catch .net 2003/5 solution tree drag and drop event

  I am using EnvDTE to build an addin for .net 2003/2005. I am trying to catch the drag and drop event of the solution tree for both file items and folders. From the EnvDTE module, I can't find anything which is really useful to do this. Also, found that IVsHierarchyDropDataTarget and IVsHierarchyDropDataSource interfaces in the VSIP provide support for drag and drop, but I have no idea to hook them up with the IDE's solution tree so that we could catch the event. Please help on this. Thanks very much. Ivan Hi Ivan, IVsUIHierarchy is not a service, it's an interface implemented by the Solution Explorer and Server Explorer toolwindows. In order to retrieve the IVsUIHierarchyWindow interface, you ...Show All

• Visual C# System.IO.IOException with shared network drive and NLB

  We have a situation where we get random IOException errors for a shared drive. We have a MS NLB cluster of 3 accessing a failover cluster for file servers. We randomly keep getting IOExceptions for no reason we can find. The path it complains about when checked manually is valid. Its as if the cluster is "asleep" then slowly wakes up and is "visible" again after a bunch of attempts. There is no appearent pattern to this we can identify - except it usually occurs after prolonged periods of inactivity. But, again, this isn't always the case. Curiously when we reduce the NLB to a cluster of 1 no exceptions are thrown regardless of the machine. Combinations of two or more machines cause trouble. The only other way to pre ...Show All

• Visual Studio 2008 (Pre-release) Where is System.serviceModel

  I install .Net Framework 3.0 RC1 but I cannot find System.serviceModel for Windows Communication Foundation. Do I need to install some other components Please post WCF questions here (moved thread). You have to reference the System.ServiceModel assembly located in %ProgramFiles%\Reference Assemblies\Microsoft\Framework\v3.0. ...Show All

• SQL Server Ignoring NULL values in LOOKUP transformation.

  Hi, Can you please tell me the way to configure the LOOK UP transformation so that it will ignore all the null values I want to configure a Look up component for the column "Col1" as follows All the NULL values of Col1 should not be considered for look-up process. They should be passed to the downstream component as valid rows. All NOT NULL values of Col1 should be processed by the Look up component. If there is no matching value present for any NOT NULL value of Col1 then it should be directed to error output. Regards, Gopi If you pass the NULL Col1 records to the lookup, you would need an entry in the lookup table to handle the NULL. otherwise, it will fail the l ...Show All

• Visual Studio Team System Some users cannot acces version control

  Hi! We have a problem with some users not being able to access version controlled files. They can see all projects and they can work with Work Items and run reports. They can also see the folder structure in the Source Control Explorer but when they right-click on a folder they get a menu with the only text being "No commands availiable". Has anyone seen this or has any idea what the cause can be We are running TFS with SP1. Some of the users have upgraded to SP1 for VS2005 and some have not. The problem seems to exist regardless of client version of VS2005. I have of course checked that the users in questions belong to the group Contributors or Project Administrator and should have permissions to change (or at least see) the sou ...Show All

• Visual Studio Team System how do i point fxcop at my asp.net code-behind assemblies ?

  I want to run fxcop on my compiled code-behind assemblies for an asp.net 2.0 web application. Ive configured fxcop as an external tool in VS 2005. What do i specify for an initial directory - item directory target directory project directory solution directory Hi David Can you please elaborate bit more about running fxcop code analysis on web applications. We are trying to run fxcopcmd.exe on the web applications in our project in the team build script.The projects doesn't have the code analysis enabled.So I am making <RunCodeAnalysis> as Never in the script as we don't want some of the projects to go through code analysis and using fxcopcmd.exe to run the code analysis on individual projects in the AfterComp ...Show All

• Visual Studio Team System Proxy reports "Service unavailable"

  When performing a forced get of a complete folder, using the proxy on a remote site, the following error occurs. " The source control proxy 'pgx206' is not responding, so the request will be sent to the main server ... HTTP code 503: Service Unavailable" According to VS's output window, some files were get successfully because the error is listed only after some files were replaced. Replacing W:\Main\TestFiles\foo.cs The source control proxy 'pgx206' is not responding, so the request will be sent to the main server. Please verify your settings. Additional information: Please contact your administrator. There was an error contacting the server. Technical information (for administrator): HTTP code 503: Service Unavailable ...Show All

• Windows Forms opening exe through link in an email

  I do not know whether this is possible or not but We have a requirement to open an exe (My VB 2005 windows application on a local user's machine) through heyperlink in an email passing a parameter to that exe) I can create an HTML email with a link to my exe but not sure how can you pass a parameter to that exe <a href=" file://C:/Myapppath/myexe.exe parameter1">Click to open this application</a> Honestly, I was trying to explore whether that could be possible or not. You are right it can be a huge security problem. I apologize for such question. ...Show All

• Visual Basic how can i get more refactorings and learn it

  hi i want to know more refactorings inorder to get my code structured well can i find any website explain more refactorings for my vb.net code for example can i extract an interface from my class or more advanced refactorings i need more and more thanks in advance This is a good starting point. http://www.refactoring.com/catalog/ Also see Martin Fowler's book. If you want to create your own automatic refactorings then you'll need to fork out $99 to buy Refactor! Pro. I assume you're already using the free Refactor! plug-in for VB ...Show All

• Windows Forms Error adding a data source - Connecting to a UDB DB2 database on an iSeries Computer i810 V5R4

  I am unable to successfully add a new data source to a Visual Studio 2005 project using the "Data Source Configuration Wizard" being a ODBC datasource defined on the client using the iSeries Access ODBC Driver . On the "Choose Your Database Objects" window I get the following error message : An error occurred while retrieving the information from the database: Column ‘PROCEDURE_CAT’ does not belong to table Procedures Does anyone have a resolution for this Hi Chris, I dont have a fix for you, more of a suggestion, PROCEDURE_CAT is a part of the database schemea, it is possible that the driver is not returning the schema in a way that Visual Studio wou ...Show All

• .NET Development faster way of accessing CSV files

  hi, I am handling CSV files as database. each CSV got 40,000 - 60,000 lines. I have to do the joining, subquery and other complex tasks here. the problem is, my query execution time too high, 2-3 mins. how can I reduce the time I saw there is no way of declaring keys for CSV files in Schema.ini. I am using OleDb. another thing, can anyone tell me what should I use to this heavy task is there any good replacement of OleDb please let me know. I should have added an example. Say you have linked server in SQL 2000/2005 named TEXTFILES... You can read the data into a temp table in TSQL, then create index on it like so: select * into #temp1 from textfiles . pubs . dbo . authors -- say you have text file with authors tabl ...Show All