kantan's Q&A profile

• SQL Server How to convert Dynamic Properties to SSIS Package Config?

  I'm currently trying to convert over packages from SQL 2000 to SQL 2005. The biggest obstacle at the start has to do with converting my "Dynamic Properties" control. I use it to read an .ini file and load the user name and password to my connections. With 2000 it's nice and easy 1 file 3 lines. While trying to convert it I’ve had nothing but problems. I've tried the Registry Entry but it forces everything into the Current User and I can't use that I need local machine. There is no documentation and I can't have a xml file with 1000 different username and password settings because 1 person has to update that file with the new passw ...Show All

• .NET Development Problem with AutoNumber key column

  Hi, I'm using dataGridView in VS 2005 environment. And I observed that the AutoNumber key columns increments the number whenever I sort on the grid. Scenario to reproduce the problem is: -bind the grid with 'Employee' table.(EmployeeID column is Primary key and it's AutoNumber) -Sort on the gird. Observe: EmployeeID column displays different number at each time when we sort the grid. Any idea about this Any comment is appretiated. Thanks. Julia168 Could not reproduce. Tested against SQL Server Employees table and Microsoft Access Employees table. Perhaps you have so ...Show All

• Visual Studio Team System can i develop a web page to insert data ?

  What im looking for is somehow to get the users here to submit tickets classified as bugs. Cant find anything on the sharepoint portal that could help me I'm not sure what you mean.  We have many ways of entering bugs in the system.  The Team Explorer and VS integration can be used.  You can also use the object model.  We also have a configurable work flow system.  We do not currently (and will not for V1) have a web page for entering bugs.  There will be some 3rd party add-ons available to enable more full featured capabilities via the browser.  We will also be look at this as a possible built in fe ...Show All

• Visual Studio 2008 (Pre-release) Why the name "DLinq"?

  Any reason for why it's called "DLinq"   It seems that calling it "RLinq", with the R for Relational, or "SLinq", with the S for SQL, would make more sense. This is true.. However, as you allude, it need not remain so. I think it wouldn't take much to have a pluggable DataContext provider which would contain the logic for determining what to send to the server.  I'm guessing the translation logic is in DataContext, and not Table<> Actually, I think it'd be great to just send the expression tree to the server, but that's just me. ;) Speaking of which, is there anywhere a good (read:  do ...Show All

• .NET Development Server and client configuration with remoting

  I'm getting an error stating that... System.Runtime.Serialization.SerializationException was unhandled Message="The input stream is not a valid binary format. The starting contents (in bytes) are: 53-65-72-76-65-72-20-65-6E-63-6F-75-6E-74-65-72-65 ..." I had the application working when I only have one wellknow object exposed on the server side of things as such <configuration> <system.runtime.remoting> <application> <service> <wellknown mode="SingleCall" type="Customer.AgreementDAO, OMData" objectUri="AgreementDAO.soap"/> </service> <channels> ...Show All

• SQL Server Help W/Disabling FK Constraints for Batch Operations

  HI all, I'm trying to have a SProc that will initialize a database for me. This db is in development (I'm primarily writing SSIS packages, atm), and I constantly need to truncate the tables, then re-add a dummy/unknown row (PK/Identity value = 1). Of course, I need triggers not to fire (got that part working), and FK constraints to be bypassed temporarily -- that's the problem. Here's where I'm at: ---------------------------------------------------------------------------------- CREATE PROCEDURE [dbo].[_InitializeDB] AS SET NOCOUNT ON DECLARE @name varchar(255) DECLARE @sql nvarchar(255) DECLARE tables CURSOR FOR SELECT [n ...Show All

• SQL Server SQL 2005 Express not for Windows 2000 Professional????

  I read that SQL 2005 Express will not work on Windows 2000 Professional but the other version will work on Windows 2000 Professional as long as it has SP 4. What sense does this make and it sure hinders design of applications since many of our customers still use Windows 2000 Pro. Express is not supported on 2000 Pro, workgroup, developer, and standard editions are the only SQL 2005 editions supported on Windows 2000 Pro...see here: http://www.microsoft.com/sql/prodinfo/sysreqs/default.mspx HTH, ...Show All

• Visual FoxPro Need VFP 9.0 Report Help

  Hi I have a report that in the detail band I have the following info: QTY     Part Number      Description              Price           Extended Price   5       2222-009          5500 Watt 220V       $2500.00     $2500.00                       ...Show All

• SQL Server Package Validation Error : The package designer deletes the code from script task.

  While Creating a script task in Control Flow, I am getting "Package Validation Error". Here is the complete message: Error at Validate File and Load Data: The task is configured to pre-compile the script, but binary code is not found. Please visit the IDE in Script Task Editor by clicking Design Script button to cause binary code to be generated. (Microsoft.DataTransformationServices.VsIntegration) As mentioned in the message, I opened the script IDE and added the code I need. When I close the VSA IDE, package designer displays the same error message. The worst part of whole story is that if I close the package designer an ...Show All

• Visual Studio Express Editions Inhirtence

  hi again , okai have a problem in which i want to display the text from a text box which is on form number 1, to the text box which is on form number 2, both forms are in one project. clearly it is a case of inheretence but plz give me its code... Thankyou... hi, no its not inheretence, its properties, or constractor Public Class  Form1      Inherits  Form           'form contain 1 textbox , 2 buttons      Private Sub  button1_Click( ByVal  sender  As Object ,&nb ...Show All

• Microsoft ISV Community Center Forums Defining a range according to the number of responses

  Dear all, I'm a new user of Visual Basic (version 6.3) and need to write a Macro for use in Excel. I need the Macro to calculate Rank values for an unpredictable number of scores. The number of scores that need to be Ranked will vary and I don't know how to incorporate this variation into the Visual Basic Macro. In my current spreadsheet there are 11 scores (Sorted in descending order) in column DS (cells DS2:DS12). The Visual Basic code is as follows (DT is the column where the Rank values will be sorted): Range("DT2").Select ActiveCell.FormulaR1C1 = "=RANK(RC[-1],C[-1],1)" Selection.AutoFill Destin ...Show All

• Visual C# Create a snap-in using VisualStudio 2003 C#

  Hi I have to create a snap-in(for a MMC). I'm trying to do that using VS2003, C#. The .NET framework version is 1.1 I searched for information and I found a basic sample at the following link:http://windowssdk.msdn.microsoft.com/library/default.asp url=/library/ en-us/managedmmc/html/56f458d3-5c65-4664-8107-2ba04efd7d65.asp I tried to compile the code, but I got an error message "The type or namespace name 'ManagementConsole' does not exist ". So, I succesfully installed the MMC 3.0 version for XP(with SP2). I also found the microsoft.managementconsole.dll file(C:\Windows\system32\) and I tried to add a reference to it in ...Show All

• Windows Forms MouseLeave for my panel

  Hello! I have a panel with some controls on it and I want to catch MouseLeave event. The problem is when I move my mouse pointer over any child control (inside panel) MouseLeave event fires. I want to create a panel control with MouseEnter and MouseLeave events, to show and hide panel (like dock windows in VS). Now I'm using timer to hide panel when&nb ...Show All

• Windows Forms How to add culture support in a property with a user control.

  Ok, I have created a user control that is basicly a label and an image. In my user control class, I have added a property called private string labelText; [Browsable(true)] public string LabelText { get { return labelText; } set { labelText = value ; } } But when I set a value in the LabelText field in the form designer, instead of creating a new ressource entry in the resource file, it is "hardcoding" the direct value in the back-end (in the initializecomponent): this .eC2ISLabel1.LabelText = "myText" ; For this reason, I can't use culture because cultur ...Show All

• Software Development for Windows Vista Using Activities in custom activity

  Hi all, I would like to use create a custom activity containing some standard activities. I know those custom activities will only be used in EventDriven activities in State Workflows, and I can be sure of that since the designer and validator will check for that (still to be implemented). The custom activity should contain the following sequence (ideally): - EventSink; - Some other custom activity or code; - SetState. I managed to programmatically add the SetState activity (since the designer does not allow to drop a SetState on a Sequence). My custom activity derives from Sequence. To the custiom activity I add ...Show All