BenChen's Q&A profile

• Windows Forms TextBox, decimal field and null values

  Hi all, As the username suggests, am new to all this- so appologies for what seems to be a silly question... Working on a small application on VS 2005, I've noticed that when binding a textbox to a table ('price') column of decimal value that accepts null values, whenever I erase the contents of the textbox, it gets 'locked' till I fill it back with a numerical value. In the "price" column's properties in the TableDataSet.xsd I've changed the dataType to string and changed NullValue to (empty), which ends with an FormatException thrown since the attempt to convert an empty string (Nothing or "") to decima ...Show All

• Visual Basic HELP WITH AUTORUN.INF file to start a VB setup

  Hi Friends, I have a installation program that installs MSDE and I need to restart the computer upon successfully installing MSDE.But the problem is the "AUTORUN.INF" file does not start with any program on computer restart. Is there any parameter I need to add in the .INF so that it can detect a restart and appropriately load setup/.exe or entry in registry so that the computer can start a program on restart Thanks in advance. SK The only way you'll be able to tell what program launched another is by the command line arguements passed to it. Atleast, i'm pretty sure. ...Show All

• Visual Studio Express Editions My.Settings Values Read Only

  Hello All, I have a bit of a problem here and I can't seem to figure it out. My project is a Class Library. This Class Library is one project which is part of a larger solution. I have several application settings which are set up as part of the project. Within the Class Library's root class, Application, there are two methods. GetSettings and SaveSettings. GetSettings retreives the My.Settings values and sets them as various property values within the Application class. This part works fine. The SaveSettings method retreives the property values from the class and attempts to place them back into My.Settings and then execute My.Settings.S ...Show All

• Visual Basic File Read Error

  Hello All, I am creating a HTML file on runtime through my VB.Net application, using following code '**************************** Dim filename As String = "new.html" If IO.File.Exists(Application.StartupPath + "\Files\" + filename) Then    IO.File.Delete(Application.StartupPath + "\Files\" + filename) End If Dim HTMLFile As New IO.FileStream(Application.StartupPath + "\Files\" + filename, IO.FileMode.CreateNew, IO.FileAccess.ReadWrite) Dim objWriter As New IO.StreamWriter(HTMLFile, System.Text.Encoding.ASCII) objWriter.BaseStream.Seek(0, IO.SeekOrigin.End) objWriter.Write(objStrbdr) objWriter ...Show All

• .NET Development Publisher Policy is VS2005 and Framework 2.0

  I have been reading up on how to handle versioning of .dlls in the GAC. Publisher Policies seem to be my correct path of action. However, most of the examples make it appear to be a manual compile of the the XML file that contains the details. But most of those examples are pre VS2005 Has anything been added to VS2005 to simplify the process Aka.. so I can add a publisher file to my project, and have it compile during "Build" So then I can auto include it in my Installation Project. Just wanted to ask, before I spend a lot of time on another solution Thanks ...Show All

• Visual Studio Express Editions Error when trying to create new project

  Hey, maybe a strange question, but I couldnt find the answer anywhere. I downloaded the VB 2005 Express Edition beta 2, and registered. I was hoping to be able to use it for the trial periode and then see if I would buy it. After activation, I still get this error when clicking at "new project" The number separator information specified in the NumberFormatInfo is ambiguous for parsing. Now my English isnt very well so I would have no idea what that means. --------------------------------- Also a little extra question, from the videos I have seen of the 2005 Express Edition, it looks very good, can I already order it, because I only see ...Show All

• Visual Basic [VB.NET VS2005] Multicolumn combobox

  Hello, I'm new with VB.net and I've found a code that I use to do a SQL query on ACCESSDB and it return me a datagrid. For Exemple, I do a query on my tbl_person : "SELECT id_person, person_name, person_birthdate FROM tbl_person" After that, I want to show this result in a combox box, but I don't find how to have 3 columns (id, name and birthdate) with the id hidden. Usually, I work with Access forms, but I want learn vb.net. How can I do my combobox with 3 columns and with my first column hidded Thanx for you help // I'm not english, so sorry for my errors You could also do thi ...Show All

• SQL Server what's wrong in the query

  It can run in the sql server select Id,Name from (select Id from TableB) but it cannot run in the sql server mobile HOw do I Thank you！ Thank your replay , Darren. Yes, that query sentence is too simple to show my problem. In fact , I need do this: select Name, sum(case Degree when... else quantity end)， sum(case Degree when... else quantity end)， sum(case Degree when... else quantity end) From (select Name,Degree,count(*) quantity from Table group by Name,Degree) as TB I can create a subset of rows by joining two tables, but like this, I cannot write it well. Please tell me How ...Show All

• Visual Basic AnalogTVTuningSpace and MSVidCtl

  I´m trying to develop a decent tv tuner/capture application (since there are no such apps, nowhere, I say) in Visual Basic 6.0. I´m using the MSVidCtl component together with the AnalogTVTuningSpace and IChannelTuneRequest object to achieve this, as described here:  http://msdn.microsoft.com/library/default.asp url=/library/en-us/directx9_c/directX/htm/hostingthevideocontrolinavisualbasicform.asp  and here:  http://msdn.micro ...Show All

• Visual Studio Tools for Office Code Optimization

  Hey gang!  Hoping that someone can help me out with this.  Here is the scenerio: Using Visual Studio Tools for Office 2003, I have created an application that retrieves data from a web service and spits it out to Excel in a given range from a web form I have created.  This web form will load, get data from the web service based on user input, and when the user presses the 'OK' button, places the information in the appropriate Excel cells.  If the user double clicks in the Excel range, that row number is sent to the windows form, and all the data exported gets placed in that row number.  So for instance, if the user ...Show All

• .NET Development sock.SetSocketOption does not work.

  Trying to execute     sock.SetSocketOption statement I get this error: An unknown, invalid, or unsupported option or level was specified in a getsockopt or setsockopt call This is the actual code: try { // create a socket instance    sock = new Socket ( AddressFamily .InterNetwork,       SocketType .Stream, ProtocolType .Tcp);    // create server IPEndPoint instance. We assume     GetHostEntry returns at least one address    IPEndPoint serverEndPoint = new IPEndPoint ( Dns .GetHostEntry(server).AddressList[0], servPort);   // CONNECT THE S ...Show All

• Software Development for Windows Vista SQLPersistence does not store InstanceState everytime

  I found that SqlStatePersistenceService does not  persist everytime and it is skipped even when RequestPersist is called explicitly, in some cases. I observed, using SQL profiler, that the InsertInstanceState (stored procedure of SQL state persistence) is called everytime the WorkflowPersisted event is raised. And, in the procedure, there is a condition as follows: IF @status = 1 OR @status = 3 BEGIN DELETE FROM [dbo] . [InstanceState] WHERE uidInstanceID = @uidInstanceID DELETE FROM [dbo] . [CompletedScope] WHERE uidInstanceID = @uidInstanceID END Could someone please explain the significan ...Show All

• Windows Forms Richtextbox extended with common formatting buttons

  Hello there! I have searched all day for an article about or a free downloadable component that allows me to edit RTF-text in a winform. I only need the most common formatting options like bold, italic, bullets, fontcolor etc. Someone must have done this by extending the richtextbox Please help... /Minnea I have a control I have developed I will be  ...Show All

• SQL Server SQL Mobile Server Tools install on SQL 2000 SP4

  I am trying to install SQL Mobile Server Tools (beta 1) on my SQL Server 2000 SP4 server.  I have already installed the SP4 Replication Components upgrade and my existing SQL-CE databases replicate ok, however when trying to run the SQL Mobile Server Tools (beta 1) install it fails the System Configuration Check with the following error: "You must first install the Replication Components for SQL Server SP 3a or higher or the SQL Server 2005 Client Connectivity Components" Can anyone assist Stuart Eastland Hi Stuart, I could reproduce your scenario on SQL Server 2000 SP4. Someone will investiga ...Show All

• SQL Server Retrieve XML From sysdtspackages90

  Is there a way to translate the packagedata field data to XML on the sysdtspackages90 table on msdb I want to be able to programmatically analyze and potentially modify the XML of Integration Services packages that reside on the server. Thanks for your help. Modifying the xml directly is not supported. However, you can get the package from the packages table by using the LoadPackageFromSQLServer method on the application object. You can save it to a file and then read the package file however you like to access the xml (xmlreader, dom, etc). Matt ...Show All