venil's Q&A profile

• .NET Development what "OleDbType" Enum Can be used for DateTimePicker "Short" Format?

  I am trying to create OledbCommand Paremeters. My Code is the following; cmd.Parameters.Add( "@Day" , OleDbType .Date).Value=dateTimePickerDay.Value.Date; cmd.Parameters.Add( "@Start" , OleDbType .DBTime).Value=dateTimePickerStart.Value.TimeOfDay; The 2nd line works but not the 1st. For "dateTimePickerDay" My "Fotmat" property is set to "Short" and for "dateTimePickerStart" It is set to Time. I have already tried with "DBDate" but it also not works. I think it would be better to post the complete code With Error: ...Show All

• SQL Server SQL Server 2005 Service Pack 1 causes machine lock up

  When doing the service pack 1 install on a client side the machine is locking up on a specific file. The tech who tried it out doesn't remember the exact file name but he thinks it ended with an .msb or .msp I checked in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files directory and none of the files have been updated. Thoughts Shane Look under c:\Windows\Hotfix for log files. Your problem should be identified there. Paul ...Show All

• Visual Studio Team System CSV Datasource can't be read after converting to C#

  Hello, When I add a csv datasource to a prerecorded test and use it to populate a form field everything works great. When I convert to C# code I get the following message... RequestFailed: Exception occurred: The given key was not present in the dictionary. at System.ThrowHelper.ThrowKeyNotFoundException() at System.Collections.Generic.Dictionary`2.get_Item(TKey key) at Microsoft.VisualStudio.TestTools.WebTesting.WebTestContext.get_Item(String key) at NonSequential.NonSequentialBuyTicketCoded.<GetRequestEnumerator>d__0.MoveNext() in C:\Documents and Settings\ja9991\My Documents\Visual Studio 2005\Projects\NonSequent ...Show All

• Software Development for Windows Vista !!Custom Sequential activity never changes state!!

  I am developing a custom sequence activity (obviousely dervied from SequenceActivity) to implement a logic of pipe and filter pattern. Each activity represent a filter in this pattern. We had a scenario in which sequence completes and is executed again by parent to simulate reprocessing of this filter again. In this case once child sequence finishes execution of all its children, it calls closeActivitiy on execution context. What I observed this that, the state of sequence activity is never changing, it is remained in "Executing" only. I did make sure that I am not recieving any execptions from closeActivity. Any help is highly app ...Show All

• SQL Server DBCC SHRINKDATABASE

  Has anyone used the "DBCC SHRINKDATABASE " in a VB.NET project to shrink a DB. If YES, Please, if you dont mind, paste the code in this forum. Tnx Just call it from a command object and it will work. This is from memory so double check the syntax, you will need to add exception handling. Imports System.Data.SqlClient Dim conn as New SqlConnection(<connection string goes here>) Dim cmd as New SqlCommand cmd.connection = conn cmd.commandtext = "use master" cmd.executenonquery cmd.commandtext = "shrink database northwind" cmd.executenonquery conn.close( ...Show All

• SQL Server How to add 'ALL' as report parameter in drop down with other parameters

  Hi ALL,    I would like to add 'ALL' to other report parameters.The other report parameters are counties.I would like to add 'all' so that user can select all counties from drop down. I added union select 'ALL' to sub query.  in main query    @county='all' is it right or wrong.After I did this report is running very very slow.performance problem begins. what exactly is the procedure to do. thanks r sankar Hi - You should be able to add an "All Counties" option to your drop down list without a much of a performance hit. For the dataset that is the basis for the parameter list, have something like this: SEL ...Show All

• Visual Studio Express Editions How Do I...Hide the startup form in VB, for system tray applications

  I'm having the same problem, I'm trying to hide the startup form in an application I'm writing that loads quietly when a user logs on and is available via a right click. The only information I can find relates to the application.run thing, however this isn't visible in VB 2005, as far as I can see. I'm aware that VB creates code in the background, but how do you get to see this code, and furthermore, can it be modified Many thanks, -Kevin McAleer // I'm aware that VB creates code in the background Do you mean the partial class that contains all the auto generated code // how do you get to se ...Show All

• Visual C# Handling DVD Images with C#

  Hi, I would like to make some operations on DVD Data images, like substituting files or delete, but I don't know what library to use to do this easily. Do you have a clue about this Thanks Marcello ...Show All

• Visual Studio Custom ToolBox Item UI

  Hi, i am adding toolbox items to the vs.net toolbox window using IToolboxService in a vsip package. Is there a way to change the look and feel (background color..etc) of these custom items Regards, ~ Atul I am not 100% sure of the answer (not tested), but Visual Studio uses a special color such as - Magenta: R=255, G=0, B=255 - Lime green R=0,G=254 (not 255!),B=0 to be used as background color in custom icons in menus, tabs, etc. Maybe it uses the same approach with toolbox pictures. Another approach is that maybe it uses the color of a special location (such x=0, y=0, or x=0, y=15, etc.) as ...Show All

• Visual Basic RTF to HTML conversion Help required

  Hello All, I need to convert RTF text into HTML to send email in HTML format, for my VB.Net desktop application. By using following class, it gives me HTML of given RTF text, retun HTML will Append in a StringBuilder, which generates HTML file. After Append() of return HTML in StringBuilder, it can't append any other string in StringBuilder object. Thats why HTML file created by StringBuilder object can't contain complete text. Problem is in RTFConverter class but I am unable to find out problem. Any help will be highly appreciated. Thanks '****************** RTF to HTML Converter Class ******************** Public Class RT ...Show All

• Visual C++ Has casting to int from double changed completely in VS2005?

  Has casting to int from double changed completely in VS2005 Numbers that are too big are always -1 now. Which has caused me much pain to track down and is not compatible with code we currently use. Here is an example, it used to be that if you cast a big number to an int, you would some value that was related to it in some way: (int)1.0957837e+011 => -2090779696 But now it is always -1 if the value is out of the range of the int: (int)1.0957837e+011 => 0x80000000 Is there anyway to make Visual Studio 2005 use the old style of casting Thanks John Petritis Does anyone know whether this probl ...Show All

• SQL Server Can I use SQL Server Management Studio Express to work with SQL Server Everywhere?

  Can I use SQL Server Management Studio Express to work with this...SQL Server Everywhere I bought VS2005 Pro and installed everything, including the Developers edition of SQL Server 2005. I would love to play with this and try converting old Access desktop applications. Unfortunately I am unsure how to create and modify a new database for SQL Server Everywhere using SSMSE. I have several tables that have a thousand records or so used for ‘Look-Up’ tables and really need a way to import those tables. Working within VS2005 and manually creating tables just isn’t cutting the mustard here… What can I do ...Show All

• SQL Server what is [SQL-DMO]

  in computer management, when i expand the branch of my sql2005 express, i got a error message. it seems i cant register my server, but i cant login in sqlcmd i also installed sql2000, and it works fine... could anybody help really strange This will never work.  You need to use Management Studio (full or Express) to connect to SQL Server 2005.  We have a bug file on our side to determine why the server is being registered.  If we fix the server registration problem, you still will not be able to connect to SQL Server 2005 through this means. Peter ...Show All

• Visual Studio 2008 (Pre-release) Binding sample causes error in VS - workaround doesn't seem to

  Just FYI Steps: Extract and Build - Binding to a Non-Text Property Sample ms-help://MS.MSSDK.1033/MS.WinFXSDK.1033/wpf_samples/html/c08d47f3-610a-4dae-911c-7c201ba1909e.htm Result: Error 1 Assembly '' could not be found. Are you missing an assembly reference C:\Monarch\Sandbox\nball\WinFx\BindNonText\CSharp\Page1.xaml 5 11 BindNonTextProperty Error 2 Type 'c:MyData' could not be found. Are you missing an assembly reference C:\Monarch\Sandbox\nball\WinFx\BindNonText\CSharp\Page1.xaml 8 6 BindNonTextProperty --------------- Note:MyData is part of the project. < DockPanel.Resources > ----------------- Here's t ...Show All

• Visual Basic [vb .net 2005] sending a string through a serial port rs232

  Hi friends ! A workstation is connected, using serial port rs232, to a device. On that workstation my application, when an event (decided by user) occurs, must send a string to the device (through rs232). That's all. Should I use MSCOMM also with VB .net 2005 beta 2 or do I need to use something else If we suppose that my output port on workstation is com1 and that the string that must be sent is "order" and [enter], how should I proceed Can you show some example to me Excuse me if my questions are too simple but I have little experience with VB (and with MSCOMM in particular). Thank you in advance for any tip! Bye! ...Show All