Jerry Eldridge's Q&A profile

• SQL Server How can I detect which version of sqlServer I am connected to using smo?

  Hi, I have a quick app to do few scripts and generate sps.However some stuff which is new to sql 2005 dont work in sql 2000 as not supported. Basically. I choose a server from a combobox and connect to the database. now at this point i need to know if I am running a sql 2005 server or 2000 . Is there a call I can make is SMO to achieve this thanks a lot in advance Hi, try this one here: Microsoft.SqlServer.Management.Smo. Server _server = new Server ( new ServerConnection ( new SqlConnection ( "Data Source={0};Integrated Security=True" ))); //_server.Information.V ...Show All

• Visual C++ trying to start an app

  Ok I tried searching, but can't seem to put this together... I have some buttons set up and I'm trying to add code to get it to open another *.exe I'm trying to open notepad. And I'm using the forms designer to create the buttons. Here is what I've tried (from searching) private: System::Void button4_Click(System::Object^ sender, System::EventArgs^ e) { CString CommandString = "notepad.exe"; system(CommandString); }; ...when compiling this gives me: error C2065: 'CString' : undeclared identifier error C2146: syntax error : missing ';' before identifier 'CommandString' error C2065: 'CommandString' : undeclared identifier ...Show All

• SQL Server Package could not be loaded

  Hello, I'm having an issue with executing a package using SQL Server Agent.  I have 7 packages that I've got 7 separate jobs for.  I also have 7 separate stored procedures that each call the appropriate job using sp_start_job.  We are using BizTalk to execute these 7 stored procedures, which in turn start a job, which in turn will call an SSIS Package to run.  When we execute the 7 jobs spaced apart, i.e. 2 or 3 seconds apart, they all run fine.  When we BizTalk executes them all at the same time, within milliseconds of each other, sometimes they all run fine, sometimes a few of the SSIS Packages end up with the erro ...Show All

• Visual Studio 2008 (Pre-release) Avalon Beta with Current Visual Studio Release

  Hello,           Can I use Avalon with current Visual Studio Release (Express or Professional). Thanks, Mustafa ELBanna Hi Arik, On a related note... I'm having a problem with the Nov CTP on VS2005 whereby when I run a very basic application all I get is a black screen in a browser window.  It seems to work on a fresh reboot (sometimes) and will not work again.  I'm noticing others having the same problem... http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.windows.developer.winfx.avalon&lang=en&cr=US Any clues ...Show All

• Visual C++ retrieving commandline arguments

  Hallo, I am invoking a programm developed using visual c++ from another program which is also developed using vc++. i call from Prog A using the function STARTUPINFO si; PROCESS_INFORMATION pi; ZeroMemory( &si, sizeof(si) ); si.cb = sizeof(si); ZeroMemory( &pi, sizeof(pi) ); ::CreateProcess("B.exe"," /mod", NULL, NULL, FALSE, 0, NULL, NULL, &si, &pi)==0) Now my question is how to retrieve or using which function i can get the commandline argument "mod" in Prog B thanks for any help swingme Thank u Martin for ur reply..I wil try it out.... regards swingme ...Show All

• Visual Studio Team System Strange checkin policy error

  I have setup a code analysis checkin policy on a Team project, I have a solution where I have migrated code analysis settings so I know they are as stringent as the checkin policy and a build of that solution has succeeded. However when I make a change to one of the projects in my solution and try and checkin after a successful build I get the following policy error: TF10139:The following policies have not been satisfied Internal error in Ensures that code analysis is run with a predefined set of rules This project that is having problems is one where I have significantly changed the contents of the .csproj file as it is in msbuild ...Show All

• .NET Development Windows Services (!Web Services), ASP.NET and RPC

  Hi I am creating a system that allows users to log into a web site and record video from a web cam. As part of its functionality it should allow recordings to be scheduled so they start at a certain time and date. The system should be asynchronous and not require a user to be logged into the web site. My proposed solution was to use a Windows Service and and ASP.NET web site. All the proposed system components will be on the same machine. The website should remotely call a function in the windows service to schedule a time and date(i.e. add the time and date to some sort of queue). 1. Is the solution I propose logical ...Show All

• SQL Server Strange performance problem or bug in SQL 2005.

  Hi, I execute a stored procedure in my database from code using DataReader or DataTable from my ASP.NET 2.0 application. No matter what object data are put into it take about 12 s! Performance is very slow even terrible, because before using SQL 2000 database it was 200-300 ms. I fought it is a bad execution plan, but when I execute the same procedure usinf Management Studio it takes 100 ms! I have tried many times to execute it in these 2 different ways and results are always the same. When I look into profiler it shows: for execution from my code: Batch, CPU about 12000, Read 602975 for execution from Management Studio: Batc ...Show All

• Visual C# How can I call a static function for a generic class?

  I have a class SwatchPanel which takes Swatch as a parameter type. How can I call a static function within the Swatch class For example the code below fails on TSwatch.Exists. How can I get the call to work Suggestions would be very welcome. Thanks, Steve public class SwatchPanel <TSwatch> : System.Windows.Forms. Panel where TSwatch : Swatch {     protected virtual bool SetOkButtonState()     {        if ( TSwatch.Exists (ColorDescription))          do something     } } ...Show All

• Smart Device Development Screenshot / signature capture no longer working

    I am running Windows CE 4.2 and I am upgrading my devices to Windows CE 5.0 .  I am also using .net 1.0 .  I have a program that captures a signature on a control and sends the captured data to a receipt printer.  The program works just fine in Windows CE 4.2.  However, the signature bitmap data is not being stripped from DIBSection in Windows.  The funny part is that BITMAPINFOHEADER is is coming through fine.  I can see the file size, width/height and offset, but the data isn't there.  None of the handles are returning null. Did something change between Windows CE 4.2 and 5.0   I ...Show All

• Visual C++ \CLR Compilation woes!

  Iv compiled my current C++ project as \clr as i want to start putting in some specific C++\CLI code to serialize my MFC objects to .NET equivalents. The program crashes on startup, something to do with the stack frame being corrupted. My first concern is the program has ballooned in terms of the size of the executable image. When it attempts to run it fails and some report about stack frame corruption. Iv noticed any C files have to be converted to C++. The program links to a DLL and Libs that have been compiled as C. Is this a problem when compiling a program as /CLR that then links with C libs etc and on startup loads C Dlls How can ...Show All

• Visual Studio Express Editions Read line listbox to variable

  Hello I have a listbox and i need some of the lines But how can i write them best to an variable,array() I am looking but doesn't found the right code (instruction) Thanks The listbox has an items collection. Just iterate over it, or use the indexes if you know them, and copy them to a list. The list should have a ToArray method when you're done, at least I know ArrayList did. ...Show All

• Visual Studio Team System doubt in custom rule to check "does filename and class name match".

  hi, i need to write a custom rule to check " Does the file-name for the C#.NET code under review match the class-name ". But i dont know how to get the file name. Could anyone tell me how to get the file name. Thanks in advance. Hi Guns, FxCop is only able to retrieve source & line information for executable code. One heuristic you could use is to look for methods in the type and look for source information on there (on one of the instructions of the method). Be aware that in .NET 2.0 there now is the notion of partial types where one type can span multiple source files. Regards, ...Show All

• Windows Forms Adding a creature to my local Terrarium

  Any time i try to add a creature to my Terrarium i keep getting this error. "A simpleplant777 was destroyed because it is blacklisted due to past bad behavior and won't be loaded" I've tried the following things to correct but to no avail: 1. changing the code to make it as simple as possible 2. changing the assembly name to something generic 3. c ...Show All

• Windows Forms DateTimePicker in datagrid's cell

  Hi. Is it possible to add a DateTimePicker control in a datagrid's cell  I need to display the dtpicker when the user clicks on the cell. Thanks, Rinaldo yes very much, if you intend to do on your own then this <a href="http://msdn.microsoft.com/msdnmag/issues/03/08/DataGrids/default.aspx">MSDN Mag article</a> is a good intro ...Show All