Cesar.NET's Q&A profile

• SQL Server Decryption Question

  Hi, I am encrypting a column in a table.  When I decrypt, everything is great if the data contained in column is less than 30 chars.  If it has more than 30 chars, I still get 30 chars decrypted.  Not sure what I am doing wrong.  Below are my details: OPEN SYMMETRIC KEY sk_XEncryption  DECRYPTION BY CERTIFICATE cert_sk_X   SELECT  ISNULL(CONVERT(NVARCHAR,DECRYPTBYKEY(columnA)),'')  FROM table1 ...Show All

• SQL Server Command Line connect to SQL Server Database

  I am trying to connect to the SQL Server database from the command line or from a cmd script on Windows - Is there a way to do this I am new to SQL Server and I am trying to create a script that can check to see if the database is up and then send me a message if it is down. Yes, you can connect to the SQL Server from the command line by means of the BCP utility for example. Here is a list of the various CMD utilities for SQL 2000. Haven' ...Show All

• Visual Studio Express Editions Help with databases

  Hi I have a database with about 20 columns one of which is vehicleNumber and one of which is temperature. I have many different vehicleNumbers. When the user types a vehicleNumber into a text box I need to collect all the temperatures for that vehicle and find the average temperature. I am not using SQL, I'm using an access database with the dataset and all that. I found a little information suggesting a dataview. Can anyone help me Just t ...Show All

• Visual C# Compilation error after migration to VS2005

  I have a rather big solution developed in VS2003. Trying to convert it to VS2005 I get compilation error: "Could not load type for namespace_name .Global" for Global.asax page. I don't use App_Code directory in my project. The file Global.asax.cs containing needed class is situated right next to Global.asax file in the same directory. In Global.asax page I have the following directive: <%@ Application Inherits=" namespace_name ...Show All

• Windows Forms Windows Form Transparency Problem

  I have been creating a Skinnable Desktop application, for which I have used Picture Box to load different skins, and the skins are getting loaded from XML files. My development Server is Win 2003, to make my form transparent I am using a blue&n ...Show All

• Visual Studio Team System FxCop 1.35 Feedback

  Hi guys. Almost missed this release, downloaded it yesterday and have been playing around with it. Looks good. Here is a couple of minor things that I found: Documentation: 1. The help provided with FxCop still has version 1.32.0 throughout it. The online documentation has 1.312. Also both don't have any documentation on the new rules (ExceptionsShouldBePublic and AttributeStringLiteralsShouldParseCorrectly). User Interface: ...Show All

• Visual C++ How Design Line(or Function like Sin(x)) in Picture Box??

  Hi! I don't Know that VC++ has a control for design line or... like VB please help me! I just can design line on DialogBox.I want design in Static variable (like PictureBox or StaticText). A picture box hosts a picture. You'd do better just to draw your line in the OnPaint handler of your form. There is no design time support for drawing a line that I know of. ...Show All

• Visual Basic How to transfer parameters between forms?

  Hi, I am using Visual Studio 2005 and VB.net to compile a program. I have two interfaces: interface A and B. On interface A, there is a button, and after I click this button, interface B appears. When interface B appears, a parameter in A will be transfer to B. Then I close B, and another parameter in B will be transferred to A. The second parameter might be a text string or an integer, and after B is closed, this text string will replace ...Show All

• Visual C# Windows Media Player Help

  Is there any way of retreiving Windows Media Player's current playing track i've been looking through all of the classes, interfaces, and everything else in wmp.dll but i cant find anything. Hi, At Hundred Miles Software: http://home.fuse.net/honnert/hundred/ you kan download a library (UltraID3Lib) for reading and writing metadata in mp3-files. ...Show All

• Windows Forms Application.exe.config

  When I select Publish, the Application.exe.config file is not included. When I run the application after it installs, I get the error "Unable to access configuration data". How do I correct this I found the solution, going into the "Settings" tab and selecting the link will create an app.config file. When published, this file will be renamed as myapplication.exe.config and deployed. ...Show All

• Visual Basic Can't Run Inside IDE

  Hi I am an ABSOLUTE beginner with VB 2005 Express edition. My problem is I cannot run even the simplest Hello World application within then IDE when I hit F5 on my XP (SP-2) system. I have even plugged in the correct code supplied by Microsift and no application will run. Generally, the form appears for a very brief second, and then disappears and I am back to design view. I can't get the application to remain on the screen Everything runs ...Show All

• Visual Basic ArrayTypeMismatchException with generic arrays

  In the following example a System.ArrayTypeMismatchException with message "Attempted to access an element as a type incompatible with the array." is raised in the Test2 method when I attempt to get the element of the array (i.e., arr(0)).  Is this a bug   If not, can somebody please explain why Test2 is invalid whereas the equivalent non-generic version (i.e., Test1) is valid Thanks, Lance Public Interface IClass1 End Int ...Show All

• SQL Server CLR and SQL 2005 Compact Edition

  I believe that there is a also a new SQL database for the PDA. Am I right Is it also possible to use (CF) .Net code inside this edition Yes. It's called SQL Server 2005 Mobile Edition. This works on Windows Mobile devices (PocketPC and SmartPhone). You need to install .NETCF 2.0 (compact framework) on the device for using SQL Mobile. You can develop mobile applications using Visual Studio for Devices. SQL Mobil ...Show All

• Visual Studio Customizing "Search Page" in Document Explorer 8

  Hello, if you use the search functionality in Document Explorer, you have the possibility to restrict the search by selecting attributes from three categories: Language, Technology, Content Type. First question: Is it possible to add a fourth category with a number of different attributes Which modifications do I have to make Second question: If first solution is not possible, can i extend one of the existing categories with a new ...Show All

• Visual C# Transforming Word Documents in to XML?

  Hi, I searched in msdn abt how to Transfer word Documents into XML or XSL-FO From that I got this link Transforming Word Documents into the XSL-FO Format , here they given all the procedure how to do that.Its manual one. But i wanted these work to be done by program itself. Can u please help in this. So far i did something like Microsoft.Office.Interop.Word. Application word = new Microsoft.Office.Interop.Word. Application (); Mic ...Show All