ptlsra's Q&A profile

• SQL Server Two issues with SSIS script

  I have a variable declared at the package level as a string and am trying to assign a value to it in a script file. I have it setup as a ReadWritevariable and am using this code: lockString = "LOAD.MPE." & CStr (Dts.Variables.Item( "gvDistrictid" ).Value) Dts.Variables( "gvLockString" ).Value = lockString and I get the following error: Error: The type of the value being assigned to variable "User::gvLockString" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object. Another Issu ...Show All

• Software Development for Windows Vista Radeon 9600 Mobile and CTP 5308 - Not working Error (10) and (Code 43)

  Hello! I have a Compaq R3000 Notebook (Intel 3.2 HT Model with the Radeon 9600 Built in). I just installed CTP 5308 and it detected my card but in Device Manager it states its not working. I have used the built in drivers and the Beta drivers from ATI and both have the same issue. Right after install I get an error code 10, but after a reboot I get : Windows has stopped this device because it has reported problems. (Code 43) Anyne have any ideas My GFX are so choppy without the driver... Thanks! Scott Hi Scott, Using the standard VGA driver I did get the full resolution of my screen 1400 ...Show All

• SQL Server using EXEC to execute a formula stored in a string

  Hopefully someone will have run into this before...  Basically, I have a table with a column that stores mathematical formulas in string format.  When my UDF is executed, it needs to select an appropriate formula from this table and evaluate it using values that are stored in local variables.  Look at the example below: Suppose I have a string named @vcFormula that contains the following: "@dVar1 + @dVar2 / @dVar2" Now suppose I have a variable named @dVar1 that contains a value of 1.0, and variable @dVar2 contains a value of 2.5.  I can use the REPLACE function to change my original string t ...Show All

• Visual Studio 2008 (Pre-release) How do I handle a click event for a button in a ControlTemplate?

  I have a ControlTemplate that consists of a horizontal StackPanel with a TextBlock and a Button: < Style x:Key = " MyStyle " TargetType = " {x:Type ContentControl} " > < Setter Property = " Template " > < Setter.Value > < ControlTemplate > < StackPanel Orientation = " Horizontal " Margin = " 1,0,1,0 " > < TextBlock VerticalAlignment = " Center " Margin = " 3 " > < ContentPresenter Content = " {TemplateBinding Property=ContentControl.Content} " /> </ TextBlock > < Button Width = " 16 " Height = " 16 " Background = " LightBlue " VerticalA ...Show All

• Windows Forms Resize button !? (I have same problem pls help)

  how i can resize button or any object in my form in run time not in Design time thanx You are vietnamese me too. Could you email me full source code of this example to dohoangtung@gmail.com thanks in advance ...Show All

• Visual C++ How to get mother board's and hard disc's Serial Number

  Is there any API function that retrieves serial number of mother board or hard disc. This forum is for general IDE issues for VC programming. That said, I don't think there's a Win32 API for that kind of thing. This is an OEM- specific question. Try starting with the hardware manufacturer tech support (their diagnostic tools often make such queries, but it's usually in assembly language). Yon can also search the web. Brian ...Show All

• SQL Server Replication to IP addressed server

  we have an outside company that replicates to us and we are known to them via an IP address.   We get an error now...Sql Server 2005 now does not support a server Alias, IP address, or any other alternate name are not supports.  Specify the actual Server Name I tried putting in the hosts file on their server 168.168.110.2       SQL2005 able to connect to our server through Studio Manager...no problem.... replication....no dice what is the work around to make this happen, I am not a network guru...know enough to kill someone, but I need to get this to work before I can move to the ne ...Show All

• Visual C# custom appdomain, crossing .net versions, "Type is not resolved for member <member I'm loading>"

  I'm stumped! I have an app which loads assemblies into a seperate app domain. it is written in 2.0. I have the assemblies I'm loading which were built in 1.1. I have a custom interface library which was written in 1.1 signed and installed in the GAC. I have a custom appdomain loader (marshal by ref object) which was written in 2.0, and uses the interface library which was done in 1.1 to pass a type back to the default appdomain. It is also signed and installed in the gac. here's the loader: namespace AppDomainLoader { public class LoadManager : MarshalByRefObject { public IAddIn LoadAddIn(string asmPa ...Show All

• Visual Studio Express Editions UserDeletingRow in Datagridview

  Ok here is my issue, I have my datagridview bound to my DB, but when I go to delete a row the row disappears from the datagridview, but when I go into the backkend of the DB the data is still there. Here is the code, any help is apperciated. I am quite new to VB, so I am still learning thsi stuff. Private Sub DataGridView1_UserDeletingRow( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewRowCancelEventArgs) Handles dgrWirelessView.UserDeletingRow If MessageBox.Show( "Are you sure " , "Delete Row" , MessageBoxButtons.YesNo) = Windows.Forms.DialogResult.No Then e.Cancel = ...Show All

• Visual Basic Change cursor in Drag Drop

  All, How do you changes the cursor in a drag drop operation to something other than a built in one. Yet i still want the system to handle the changing back of the cursor etc. Anyone any suggestions Cheers Dim c As New Cursor ( FileName ) Me . Cursor = c ...Show All

• Visual Studio Team System I have install TFS in local system account, can I switch to AD account as user ?

  Hi. I have already install the TFS in Local system account, but later I decide to use AD account as user to login. Can I switch this by config I saw the installation guide, it says... no way..... Single-Server Deployment To set up and configure Team Foundation Server using a single-server deployment on a computer joined to an Active Directory domain, you need three Active Directory domain user accounts as outlined in the following table. To set up and configure Team Foundation Server using a single-server deployment on a computer that is a member of a workgroup, you can use local user accounts. If you install Team Fo ...Show All

• Visual C# Making the page back to the same position...

  How can I make the web page comeback to the same position on a postback Like I have a dropdown at the end of the page, and when I change the selected value it calls a function, after that it come back to the top of the page, and not to the end.. Thanks Set the page's SmartNavigation attrbiute to true <%@Page SmartNavigation="true" %> ...Show All

• SQL Server SQL Express Std & Adv hardware warning

  I have insured that I have the x86 version downloaded of both the ver. 2.0 .net foundation. I have insured that I meet the min. requirements of all software requirements. For the Std. edition my hardware reports I exceed the minimum requirements. For the Adv. edition my hardware meets the min. mem. requirements. I proceed with the Adv. installation, I find a warning during the preamable or the installation support tools regarding insufficient hardware. I then back out of installation, I remove the /program files/ms sql folder and verify registry is cleared. I proceed to install the std. edition, I find the same warning as above. I susp ...Show All

• Visual C# plz help re-write vb code to c# code

  hi i am new to c#.net, currently on MSDN library page learning the "New DataSet Features in Visual Studio 2005", I saw this chunk of code which is writen in vb.net, because I am learning c#.net, can any one plz help me translate this code into c# so that I will be able to understand the code better. thx in advance, the code is here: Partial Public Class NorthwindDataSet Partial Class OrdersDataTable Protected Sub ValidateNewRow(ByVal sender As Object, _ ByVal e As System.Data.DataTableNewRowEventArgs) _ Handles Me.TableNewRow ' Create a strongly typed instance of the row ' This helps us avoid code in quotes, ' eg, ...Show All

• SQL Server xml index not working properly

  When I use xmltype .exist(..) to check whether one xml type instance contains a node with the path and value specified in the xpath, the xml index created doesn't work as what I expected. My xpath is simply like /Book/Title[.="blah"]. According to many tech guides on the web, the query optimizer will map the /Book/Title to a coded path_id, then the path_id will be used to scan the rows in the primary xml index with the matching path_id. After the matching rows are found, their value column will be compared to "blah" to calculate the return value of exist(...). However when the xml instance is untyped, the index just ...Show All