MA2005's Q&A profile

• SQL Server native vs. clr stored procedures

  Hello, my question is, what is "better" for relative simple querys. native stored procedures or the clr method The procedures are relative simple select's or insert's. What are the advantages of clr procedures perhaps you have some links to read about... thanks and greets from germany! Dirk You should also take a look at this whitepaper . Cheers, -Isaac ...Show All

• Visual Studio 2008 (Pre-release) Bug? LoadSequence with LoadOption.PreserveChanges doesn't work as I am expecting

  When calling the version of LoadSequence that allows me to specify a LoadOption, LoadOptions OverwriteChanges and Upsert work as the Intellisense states, but PreserveChanges does not. According to the popup text, PreserveChanges should update the original version of the data, but not the current version. In my testing, it updates both the orignal version of the data AND the current version of the data. Am I doing something wrong Here is some code demonstrating this problem: class Student { public int Id; public string Name; private string SSN; } Student[] students = { { Id = 1, Name = "Joe Rattz" } }; Student[] moreStudents = { { Id = 1, Name = "Joseph Rattz" } }; // Create the tabl ...Show All

• Software Development for Windows Vista MessageBox wrapping text differently than XP

  Is there a stated reason why MessageBox's will wrap text differently than in XP For example a MessageBox in XP may be wide but the same MessageBox (text and caption) will be narrow and wrap the text earlier. Is this configurable or a fundamental change to MessageBox behavior in Vista Thanks, Jim The width is 5/8 of the width of the work area, 3/4 of the width of the work area, or 7/8 of the width of the work area, whichever is smallest without causing the message box to be taller than the work area. Are your monitors the same size on the XP and Vista machines Is the work area the same size on both I bet you have a Sidebar on your Vista machine but not on the XP machine. Turn off the Sidebar on ...Show All

• Visual Basic Structure from VB6 gives error in 2005

  Have a legacy application migrated with wizard from VB6. Full of structures. Original author is gone. Below is edited snipped with error shown. Help would be GR8TLY appreciated. Thanks in advance. 'UDT for Simulation Parameters Structure Simulation Dim Senior As Integer 'UPGRADE_TODO: "Initialize" must be called to initialize instances of this structure. 'Click for more: 'ms-help://MS.VSCC/commoner/redir/redirect.htm keyword="vbup1026"' <VBFixedArray(5, 9)> Dim Characteristic(,) As Single Public Sub Initialize() ReDim Sim(27).Characteristic(5, 9) Characteristic.Initialize() End Sub End Structure ' Now declare the collection, with the name "Sim" 'UPGRADE_WARNING: Array Sim ...Show All

• Visual C# Problem in accesssing System.IO.Compression

  I'm not able to access Namespace: System.IO.Compression, even thought i have installed .NET Framework 2.0. I need this as i need to access the Class Library GZipStream. Is there any setting that needs to be done Thanks in advance. Mayur. ...Show All

• Windows Forms Show data from ms access in a textBox

  Hi there, I need your help with something you may find easy but it isn't for me, sadly. I need to show data from my MS Access database into several textBox-es just showing no modifing. I have a sample from my program : OleDbCommand nameCmnd = new OleDbCommand("SELECT name from Customer WHERE customerID = "+ enteredID, myConn); OleDbDataAdapter nameAdapter = new OleDbDataAdapter(nameCmnd); DataSet dsName = new DataSet(); nameAdapter.SelectCommmand = nameCmnd; nameAdapter.Fill(dsName); I try this: nameTextBox.Text = dsName.ToString(); but its wrong! And I have to do the above for every customer details such as name, mobile number, home number ..etc So you can see I need a solution plzz. ...Show All

• Windows Forms forms designer error, vb .net 2005

  I am trying to follow the code in Taskvision 2.0. It compiles and runs, in VB .NET 2005. But if I use the designer (right-click on a specific form, MainForm), the designer crashes with a message: "The Name PriorityText is already in use by another component" PriorityText might be a datagrid, but I am really not sure I remember this kind of error happening in VB 2005 Beta programs when run under 2005. To fix it, I had to edit the designer.vb file and fix something,... but I can't remember what. Any help, please thx find in your designer.vb for "PriorityText " to check whether you have use it for more than one component maybe you can use find and mark all to help you find all priority text ...Show All

• Visual Studio This shouldn't be this tough ... ReportViewerControl Web Forms

  I have implemented the following custom authentication code from MSDN: Imports Microsoft.VisualBasic Imports Microsoft.Reporting.WebForms Imports System.Security.Principal Imports System.Net Partial Class psm_moc_reports Inherits System.Web.UI.Page Public Class ReportServerCredentials Implements IReportServerCredentials Private _userName As String Private _password As String Private _domain As String Public Sub New ( ByVal userName As String , ByVal password As String , ByVal domain As String ) _userName = userName _password = password _domain = domain End Sub Public ReadOnly Property Imper ...Show All

• .NET Development Reflection - Strong Name

  Hello, Pls any1 can help to answer my question. Why when ni use Reflection in my Exe to get the path like: Me .m_RunningPath = Reflection.Assembly.GetExecutingAssembly.Location 'including filename and i try to use the Strong Name to verify the Dll. I found that if i'm not using "Reflection" to get the path and direct call the dll, the same way of Strong name will work fine.However if i use reflection,even version wrong it also verify as approved. Is it anyway wrong or i can't use reflection for calling dll in my Exe. Thank you. So basically you want to prevent your EXE from loading Dlls that you didn't build. If you can narrow down where you load the assembly then checking strong ...Show All

• SQL Server how to query the SQL server name?

  I use : select @@servername to find SQL server name. But it will return the virtual OS name in cluster environment, not SQL server name. I need this server name for error handling as well as generating query scripts. How to query SQL server name If you are using SQL Server 2005, then you can use the SERVERPROPERTY built-in to get the various names. select SERVERPROPERTY('MachineName') as [Cluster Virtual Server Name] , SERVERPROPERTY('ComputerNamePhysicalNetBIOS') as [Cluster Node Name] Otherwise, you will have to get the netbios name using any of the OS utilities. ...Show All

• Software Development for Windows Vista after persistence workflow is not starting

  hi all, i have workflow with dalay activity 5 sec in persistenceservice setting , unloadonidle =true instanceOnershipduration = Timespan.maxvalue loadinginterval 20 sec on unload on i dled i am putting code ThreadPool.QueueUserWorkItem( New WaitCallback( AddressOf UnloadInstance), e.WorkflowInstance) Sub UnloadInstance( ByVal workflowInstance As Object ) CType (workflowInstance, WorkflowInstance).TryUnload() End Sub it goes in waiting mode after delay activity and calling workflowLoaded event again and again can anybody help me Are you using the ManualWorkflowSchedulerService If you are, make sure you have UseActivityTimers set to true. Why are you unloading the work ...Show All

• Windows Live Developer Forums addOrder() - startdate

  Is there a reason why when you add an order to a campaign the OrderStartDate, must be the (day you give it)+1. e.g. DateTime.Today.AddDays(1) DateTime.Today, throws an invalid start date error. I have noticed this in the reporting also, but this error was corrected there, that is the date you give is the date you give, not the date-1 Hi, The following works when setting the start date prior to a call to AddOrders: orders[1].OrderStartDate = DateTime.Today; I don’t know why this is resulting in an invalid start date for you. Please provide details about what time zone you are in and the time of day (in your time zone) when you are making the call. Thank you. Walter Poup ...Show All

• SQL Server ReportViewer Find

  I have a Local report bound to a R eportViewer control and when I am typing in text in the find text box and I click find I get this message on the report viewer "Object reference not set to an instance of an object" anybody have any idea This is a known issue with the report viewer control. It is fixed in Visual Studio SP1. See this posting for more information: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1032267&SiteID=1 ...Show All

• Windows Forms Combo box problem

  hi im having a little problem with combobox control the problem is that when i show another form on the dropdown event of combobox then the combobox dosent remains drop down... but when i show a dialog (.showdialog) the combobox remains drop down even after the dialog box is closed...... is there any way i can close the drop down of combobox without clicking it.....on some event of my dialog box thanks in advance You should close the form on any of this form events: Deactivate, Leave and also good on Escape key down. Not to mention on selected item with click, double click, select end pressed enter key. ...Show All

• Visual Studio Team System Work Item Tracking Customization - Potential Bug in TFS

  I added some custom work item types and modified them using the GUI tool from Imaginets to export and import. When I found out I couldn't delete a work item or rename one, I ended up deleting my Team Project. I created a new one by the same name, but the menu for Work Items now displays an "Error loading menu: Index was outside the bounds of the array." I deleted that Team Project and created a new one by a different name, and it is working OK. Cade, From what you said looks like you deleted that project and we no longer have repro We have seen this when doing backend localization stuff, but that was workaround-able by closing/reopening VS, or in some cases doing "devenv /resetuserdata& ...Show All