Ling Lo's Q&A profile

• Windows Forms Binding a Combo and adding an empty item...

  I know there are many ways to fill a combo box (in DDList format).  What I'm trying to do, is add the info, with a "-- Select Item --" at the top of the box and in the text section. So, I could add the info using Datasource, after adding the item to a dataset. But how do you sort so the "Select Item" winds u ...Show All

• SQL Server user info in fn_dblog with SQLServer 2005

  Hi, I've notice that in SQLServer 2005 "select * from ::fn_dblog(null, null)" and "DBCC LOG(mydb, -1)" always return -1 or NULL for the column UID which is supposed to return the id of the user. I've been using those statements with previous version of SQLServer with no problem so far. Does anybody know if there is any option to enable SQLServer 2005 to save the user info in the log Thanks. I'm not totally positive but I think that your get -1 when the user is a windows authenticated user and not a SQL Server authenticated user ...Show All

• SQL Server Sql date substract question

  Hi everyone, I need to substract one day from de system date(yesterday). example: execute spGetCustomers GetDate()-1,null,null --system date less one day(yesterday) Can someone tell what is the SQL sintax to do that. Thank's Hey, Your example itself is right !! you can use getdate(). anyways, this is the syntax. dateadd(dd, -1, getdate()) Amarnath ...Show All

• SQL Server sql server agent job execution of a package failed

  Hi, when I try to run a package as Job I receive the following error Executed as user: SITA\sqlserveragent_svc. The package execution failed. The step failed. Has someone an idea how I can get more detailed information about WHY the job failed Tha package was created in BIDS and imported into MSDB. Running the package from the Integration Services context menu works, but starting it as a job from SQL Server Agent fails. Any idea or hint what the reason could be or how I can get more information Thanks in advance Nobsay Are you using the SSIS Job subsystem to run the package You should ...Show All

• Visual Studio Team System Worst product install I've seen yet.

  I've got to say that I think that this is the worst product install I've seen Microsoft release to date.  It doesn't matter if you take a virgin machine, with windows 2003, follow the install guidelines to the letter, including the seemingly 'hard coded' required service names, you still end up with 28100 - Error on the event web service.... 28703 - Unable to connect to the SQL Server.. Then the roleback doesn't remove the application properly, so you end up having to rebuild the machine all over again in order to make it properly function. I can see why this product hasn't been released yet to the GP except with the BETA tag. JB ...Show All

• SQL Server Performance imapct of four columns as logical primary key in Data Source View

  Will setting four columns as logical primary key in Data Source Views cause low performance when generating Reports in Reporting Services 2005 While attempting to build a report model, I found that I cannot autogenerate a report model off Data Source Views that do not have primary keys or logical primary keys. Therefore I have to create logical primary keys. However, due to the complexity of the data my code collects and the data base schema we use, I have had to set four columns as the primary keys. I am curious if anyone has had such complications and if it has impacted performance. Thanks, Sean ...Show All

• Visual Studio 2008 (Pre-release) Avalon Beta and VS2005 - Black screen in browser window

  Hi All, 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 Known bug, reproducible on some CPUs. I answered this elsewhere on the forum. See http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=174784&SiteID=1   ...Show All

• .NET Development ORA-12154 error when connection to Oracle Database from C#

  I'm trying to connect to an Oracle Database 9.0.2 using OracleClient in C#. I get the error "ORA-12154 Could not resolve service name" when trying to connect to the database. I've checked the TNSNAMES.ora file an it seems ok. The project where I get this error was previously a .VS 2003 project which I converted to a VS 2005 project. As a test I created a small project in VS 2005 where I connected to the same Oracle database with the same connection parameters, and it worked fine. Does anyone have a clue on what might be the problem Do you have multiple Oracle installations on your machines like Oracle client ...Show All

• Visual Studio VSS 2005 - Install - Missing Menu Items in VS 2005

  I installed VSS 2005 in my VS 2005 enviroment and I am missing the "Open Project from Source Control" menu item. Does anyone know how to correct this You are exactly right. Many Thanks. ...Show All

• Visual Basic Some Questions

  how on earth do you make a color transparent   I'm not tlaking about a button color, not a 'textbox color', but a color on Paint.   I painted a picture on Paint. I loaded it on VB, now there's a big black area behind it. i want the black area to go away. I want to make the color 'black' transparent, so that when you move it over something, the black area is transparent.  Tu comprende Not comin' to ya   How about, how do you make a certain color on paint transparent   like, i put a graphic on paint (a 'character') and want him to appear on a terrain ('grass') without having an enomrous, squa ...Show All

• Visual Studio Tools for Office VSTO v3 and Outlook

  Is there a way to add information in the top of an email like the text that say "You replied on ..." (just below the title). I'm developing a Outlook 2007 application where emails can be exported to another system and I would like to inform the user if the items has already been exported. /Lars Lars, I am glad you are working with our tools. Regarding your post: I am a bit confused by your subject and question. Currently, we are at work on VSTO v3 CTP, but, to my knowledge, we are not fielding forum questions in this regard. We currently have no supported VSTO version on Outlook 2007, and I am not sure what you ...Show All

• Windows Forms Images Reference

  I am trying to deploy a simple vb .net windows form. I have referenced each of my images like so... Me .PictureBox1.Image = Image.FromFile(Application.StartupPath & "\images\mc6v.jpg") It works fine locally but not once I release it. Which project should I add the folder into  The folder never seems to be included in the setup. Thanks, Todd Thank you both. I had placed the images folder into solution explorer assuming the images were also. I had to manually place the images into the folder for it to work. Problem Resolved! ...Show All

• Windows Forms shared SQLconnection accross all forms.

  okay.  I decided that making a connection to the database eachtime each forms opens up is a bad idea.... bad idea in the sense its slow....  is possible to share a sqlconnection from form to from by using a class. like this ---------------------------------------------- Public Class myFormlib     Public Shared my_con As SqlClient.SqlConnection End Class then in any form m ...Show All

• Visual Studio 2008 (Pre-release) Error when subclassing controls in a WBA

  Hi, I have a custom control (derived from ContentControl) and a couple of custom panels (derived from Panel) in a WBA. When I try to run this app, I get "Request for UIPermission failed". Is it because of the subclassing I have thought only Hyperlink has an inheritance demand. Thank you, Valentin Iliescu OK, I have found by trial and error that it's O nPropertyInvalidated with the inheritance demand. It was not a vital method in my code so I can live without it. Thank you for your support, Valentin ...Show All

• Visual Studio Team System How to respond to work item control events

  Hi, How can I listen to events fired by controls within a work item For example if a button within a work item is clicked then how can I capture the click event and then fire some of my own custom code. Do I have to subscribe to event notifications Any response would be much appreciated. Thanks. Is this task not possible I'm hoping someone must know the answer. I would be very grateful for a response. Thanks is advance. ...Show All