Monitor's Q&A profile
SQL Server Database Diagram in VS 2005 for SQL Express 2005
I have installed VS 2005 (Beta 2.050215-4400) and SQL Server 2005 CTP (File Version 9.00.1187.07). I can connect to the SQLEXPRESS database and created tables from the VS 2005. But when I try to click the + to expand the database diagram folder I get the following window: --------------------------- Microsoft Visual Studio --------------------------- This server does not have one or more of the database objects required to use database diagramming. Do you wish to create them --------------------------- Yes No Help --------------------------- After I select yes, I get the following error ...Show All
Visual Studio Team System Can not receive notification
Hi, I am trying to register and receive notification. I tried to register for email notification through Visual Studio IDE, I tried also to create Web Service and register it for SOAP notification. Registration went fine, I can see registration entry in tbl_subscription. Subscription is for CheckinEvent, I am checking files in and out, but nothing happens. No notification at all. There are no entries in bislog.txt. There is nothing interesting in server Event Log. There are no hits in Web Service IIS Log. What am I missing How can I check notification service Thanks in advance, Leon Check your web.config file under bisiisdir in yo ...Show All
Visual Studio 2008 (Pre-release) database support
Hi! Will LINQ support database providers other than sql server LINQ is actually a C# and VB.NET feature. DLinq is an extension on ADO.NET that will support at least SQL Server and maybe more, I don't know, I would expect OleDb support, but it is not in the preview. As I understand it the whole mechanisme is extensible so you should be able to write your own providers. ...Show All
Smart Device Development How to make your application appear in the Start Menu?
I'd like to make my application available to the Start Menu. How can i do so Do i have to program it somewhere Is it related to the MSI package Really clueless here ... :( Thanks, No, it's not related to MSI unless you want something in start menu on desktop. To make your application appear in a start menu on device, simply create shortcut to your application and put it to the start menu folder. You can do so in the CAB file project. ...Show All
Windows Forms update TextBox bound to DataView
Good morning, I have some TextBoxes bound to a DataView. If the user makes any changes in the TextBoxes, I prompt to save or cancel before moving to another record. Here is the code if the user chooses cancel: else if (this.bolChangedAcct == true) { //Drop bindings this.tabAcctMstrMaint_txtShortAccount.DataBindings.Clear(); this.tabAcctMstrMaint_txtAcctGroup.DataBindings.Clear(); this.tabAcctMstrMaint_cmbBalance.DataBindings.Cle ...Show All
SQL Server SSIS: varchar(max) or nvarchar(max) help
Please I know this is fustrating but I really need help with this issue: I am getting data conversion error when I tried to load data from one SQl table to another SQL table using SSIS. The source table has a column with data type nvarchar(max). Also the destination table has the same data type nvarchar(max) but I keep getting conversion error when I use SCD transformation. Error: " Input column "des" (116) has a long object data type of DT_TEXT, DT_NTEXT or DT_IMAGE which is not supported" I am fine when I use OLEDB destination but I want to do an incremental load. Is there a quick fix for this ...Show All
Visual C# List all SQL Server Database engine in an intranet?
hi every body I need a help here. I want to list all SQL Server/MSDE Database engine that running on every computer in my company's intranet. I have found out some example that send message to the default port of msde and waiting for reply, but if does work when that computer turn on it firewall. My need is likely the functional of : MS SQL ServerManagement Studio/object Explorer/connect/Database engine/browse in network Server. thanks and regard I have write a simple SqlLocator class: public class SqlLocator { [DllImport( "odbc32.dll" )] private static extern sho ...Show All
.NET Development Showing form postback progress in a new window
I have a form that creates and updates a pound table during a postback, and right before I submit the form I do a window.open to launch another page that reads from the pound table which stores where the postback is (Step 1, Step 2, etc) auto refreshing every 5 seconds. The problem I have is right after it spawns and loads originally, when it refreshes, it waits for the original form to complete its postback before it runs its own postback. I believe this is because IIS see the single connection and therefore waits till the first postback completes before running the spawned window's refresh. Any ideas how I can accomplish this async'd or in ...Show All
Windows Forms Dynamically loading MDIchild forms at runtime
Hi all, I would like to create an application where i can easily add / update components (e.g. inventory component, customers component) to the application without modifying the main project. I tried to design the architecture based on a MDI-application where I define the components in MDIchilds. The MDI-parent is then the main project. Each MDI-child has to be registered in a database and subsequently based on a user's credentials, this MDI-child can be loaded. Also based on these credentials, the user menu is dynamically created. I am actually looking for a project similar to DotNetNuke, but then developed in Windows Forms... But th ...Show All
Visual C# Casting to nullable generics
Hi. I have this method: public static TVal DoIT<TVal>( object value) { return (TVal) Convert .ChangeType(value, typeof (TVal)); } But it fails in case of DoIt< DateTime >( DateTime .Now) . (Invalid cast from 'System.DateTime' to 'System.Nullable`1[[System.DateTime, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]'.) How can I make it working I was trying to catch that case myself (happy with typeof (TVal).IsNullable ), but I'm not able to create required nullable type because no constructor I found takes a System. Type (which I can get using Nullable .GetUnderlyingType ...Show All
Windows Forms How do I stop new rows
I want a datagrid with 4 rows only and one column editable. I've loaded the data, and figured out how to allow one column only to be editable (by setting other columns to readonly. Problem is, how do I stop the user from inserting new rows Setting grid to readonly stops editing of column You do not necessarily need to change the Data ...Show All
Visual Studio Why is PrintLayout crippled?
There is a SetPrintLayout method but no GetPrintLayout Why is there not a PrintLayout property with a getter and a setter Why is there no ShowPrintLayoutButton property SetDisplayMode is a method because setting it may cause the report to rerender, a potentially expensive operation. Having that happen as a result of a property set is unusual. The missing get operation is a bug that we hope to fix with the next update. The button can be hidden with the ShowPrintButton property. ...Show All
Windows Forms Bevel, Shadow, Glow
Hi, Does anyone know where I might find resources on developing my own Bevel, Shadow and Glow effects I can't seem to find info on those algorithms anywhere. Any help would really be appreciated! Thank you, Jaco There is an open source program called Paint.NET , its a .NET application that has the algo you're looking for. Download Paint.NET and read through the source-code, maybe you can find algo for bevel, shadow and glow effects in there. Regards, -chris ...Show All
Visual C# key press help
How can i know if SHIFT+L keys are pressed i know how to capture just 1 key but how do i capture combinations Thanks What do you mean by L+r Are you asking about Left or Righ arrow keys Or just plaing L and R characters You can look at the Keys enum for Left/Right for arrow keys, and you can look at any letter also in the Keys enum. Keys.Left Keys.Right Keys.L Keys.R etc. Regards, -chris ...Show All
SQL Server Audit Transformation error
Hello all, I am getting an error that I am stuck on. I dragged the Audit Transformation for error handling (Flat File Source); however, the Audit Transformation is returning an error for one of the standard column "User name". I tried to change the length or take out this column, but the error does not go away. Below is the error message. Your help is much appreciated! -Lawrence "The length for "output column "User name" (195)" is not valid for the specified lineage item." "component "Audit" (180)" failed validation and returned validation status "VS_ISBROKEN" ...Show All
