Kelly Wilkerson's Q&A profile

• Windows Forms Binding Checkbox to SQL 'Bit' Column?

  I am trying to bind a check box to sql column with type 'bit', like this .. this.myCheckBox.DataBindings.Add(new Binding("Checked", myDataSource, "TableName.Field")); They binding works fine when I move the BindingManagerBase.Position +/-, but when I click on 'Add' button, the form still display the last record and the controls don't reset to empty. My 'Add' button code is ... this.bmBase.EndCurrentEdit(); this.bmBase.AddNew(); idealy when I call the AddNew() method of BindingManagerBase class, all the controls should become empty. but in my case it doesn't. I am not sure if I am missing to set some parameters plzz help me .. You ...Show All

• .NET Development DataSet ForeignKeyConstraint Exception in VS2005 Beta2 CPT June

  Hi, Using the DataSet below to test ForeignKeyConstraint I get an exception "Invalid 'Key' node inside constraint named: FK_CatId."  when read from xml file. IDE: VS2005 Beta2 CPT June Any help Thanks Roberto Juca robjuca@pobox.com DataTable tb1 = new DataTable ("TB1"); tb1.Columns.Add ( new DataColumn ("CatId", typeof (Int32))); tb1.Columns.Add ( new DataColumn ("Name", typeof (String))); tb1.Constraints.Add ( new UniqueConstraint ("PK_tb1", tb1.Columns ["CatId"])); tb1.PrimaryKey = new DataColumn [] { tb1.Columns ["CatId"] }; DataTable tb2 = new DataTable ("TB2"); tb2.Columns.Add ( new DataColumn ("ProId" ...Show All

• Visual Studio Team System Branch with DLL's files

  Hi, How can I branch folder with all the DLL's files Making branch from the IDE does not copy the DLL's file (RC version). Thanks Michael, I'm not sure what you mean. The command-line 'tf branch' command is always recursive. ...Show All

• SQL Server Not able to connect to server from SQL Server Management Studio

  After the latest security updates from Microsoft, a connection I had to a server in my local area network no longer works. I can log onto the machine sql server itself is installed on and use SQL Server Studio with no problem. However, when I try to connect from my desktop machine, as I've been doing for months with no problem, I get the following error An error has occurred while establishing a connection to the server. When connecting to SQL server 2005, this failure may be caused by the fact that under the default settings SQL server does not allow remote connections. Provider: SQL Network interfaces, error: 26 - Error locating Server/ ...Show All

• SQL Server Error generating symmetric key

  Hi, After installing SQL Reporting Services 2005 and starting the Reporting Services Configuration tool the reporting server is reported as uninitialized. The cause seems to be the creation of the symmetric key. Below I attach the relevant part from the log file: ReportingServicesService!crypto!8!1/4/2006-11:20:55:: i INFO: Exporting public key ReportingServicesService!crypto!8!1/4/2006-11:20:55:: i INFO: NT Service self activating ReportingServicesService!library!8!1/4/2006-11:20:56:: Exception caught while starting service. Error: System.Runtime.InteropServices.COMException (0x80090008): Invalid algorithm specified. (Exception ...Show All

• SQL Server Management Studio Express CTP update now available

  There is a new Management Studio Express CTP download available at   http://www.microsoft.com/downloads/details.aspx FamilyId=82AFBD59-57A4-455E-A2D6-1D4C98D40F6E&displaylang=en . This update fixes the defect where installing the full Books Online documentation prevented Management Studio Express from starting.  With the update, Management Studio Express and Books Online no longer interfere with each other. To update Management Studio Express CTP: 1) Uninstall Management Studio Express CTP from your machine. 2) Clear your browser's download cache.  If you are using Internet Explorer 6, you can do this by starting Internet ...Show All

• SQL Server SSIS package execution question in SQL agent

  Hi there, I have been trying to schedule a package I design to run off hour, but unable to do so. Here is a strange issue: 1. I was able to fully run and complete the package through VSS. My package has three steps and I have on complete arrows from one step to the next... When I run it, it does what I expected in SSIS designer. 2. I was able to deploy and run the actual package by double click on the file system and it runs successfully through Execute Package Utility. So my package does loop through a file folder and insert records from within the folder through execute SQL task to a SQL table...etc. Typically it takes a while ...Show All

• .NET Development I/O to PC Keyboard.. How to output to keyboard

  Hi, I wish to send codes back to a PC keyboard (it has an 'new email has arrived' LED that is activated by sending a character sequence to keyboard). Is this possible from existing framework calls (I/O, streams , ports ) or do I need to write a new keyboad driver thanks, You cannot access I/O ports from user mode so you'll need a driver. Maybe the keyboard already has one but the problem then would be to find out how do you access it. If you're lucky it has some documentation but I doubt it. ...Show All

• SQL Server dynamic query

  Hello friends, I want to create a dynamic query based on input of the parameter. If the user passes nothing then all fields should be displayed else use query based on parameter. I had view sample of MSDN ,but I got error [BC30203]. Is there another way to it Please help. I use: = iif(Parameters!SQLQuery.Value<>"",Parameters!SQLQuery.Value,"SELECT somecolumn from sometable") as "select statement" and provide a query in the SQLQuery-Parameter.. You could also use: = iif(Parameters!SomeID.Value<>"","SELECT somecolumn from sometab ...Show All

• Windows Forms BindingsManagerBase.EndCurrentEdit()

  Resently I had trouble with BindingsManagerBase.EndCurrentEdit() Can somebody help me to understand it I created my data class and bound its string field into my textbox text property. also I added TextChanged event to the textbox, where I called EndCurrentEdit()  to save changes to my datasource. when I chande data in the textbox in first time, the event fires and EndCu ...Show All

• Smart Device Development Windows CE Shared Sources Premium - what's included?

  There is a web site outlining the MS shared sources initiative: http://msdn.microsoft.com/embedded/usewinemb/ce/sharedsrccode/default.aspx , but it's not detailed enough to allow a developer to make suggestions re purchasing decision. Can anyone answer (an MVP perhaps), what exactly is included into the Premium sources, for example does it include TAPI, RIL, cellcore, and so on Thx. VB. I would suggest using one of the newsgroups listed on http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=286724&SiteID=1 to route your questions to the right set of people as this forum is for Smart De ...Show All

• SQL Server Help with ##table

  Hi, I am trying to drop a global temp table (##table) with sa rights and I get no joy. Does anyone have an idea what this could be caused by. The table is used by a sp which checks if the table is there and it drops it if its there. Tnx for help. Quite possible that another user might be accessing the ##table since it is a global temporary table. ...Show All

• Visual C# Could the compiler only build modifled project?

  Whenever I build the solution, the C# compiler build a lot of projects even the files in the project has not been modified. This costs a lot of time. Is there any option that could make the compiler only compile the modified project(projects contains files that has been modified since the last build) Thanks! It is possible but unlikely.  I believe there is a project setting option which I have seen that would likely turn off the building of dependencies.  If I run across it, I will contact you. James ...Show All

• .NET Development Enumerate all Forms

  I want to open dynamically some (dynamic) forms. How can I enumerate all WinForms of the current assembly How can I crate dynamic WinForms How can I save them VS05: Thanks for these hints. Some code for example: Open a Form dynamically by Name: Type ty5 = Type.GetType("testTree.ui.V3.frmTestBlockinggrid"); Form f5 = (Form)Activator.CreateInstance(ty5); f5.Show();   but how can I enumerate all (not only shown) winforms of an assembly Assembly a = Assembly.GetCallingAssembly(); Type[] mytypes = a.GetTypes(); foreach (Type t in mytypes) { Console.WriteLine(t.ToString()); }   There are missing these Wi ...Show All

• Visual Studio 2008 (Pre-release) Getting ListView to do things other than text

  I'm having trouble customizing the ListView for my application's needs. What it needs to do is: a) Allow multiple rows for each item bound, not just one. b) Support things other than just text for binding (DisplayMemberPath). As an example, I want a listview with four columns. Each ListViewItem is bound to a strongly-typed class and will require two rows: For example, take a look at  this mockup , which represents a ListViewItem. The lines are grid lines (it's easy to see the required two rows). I need a Date/Time field bound to the top left cell, a text field in the top middle left, and a decimal in both top rig ...Show All