laue's Q&A profile

• Windows Forms Populating Serial No Problem

  hi i have a datagrid, and i have binded it to a dataset, i have a column called srno and its autogenerated, it works fine, the problem is when i enter the data for the first time in a row the srno is 1, after entering the data i navigate to the second row, at that time srno is 2, before entering the data in the 2nd row do some alterations in the first row, after finishing alterations in the 1st row i return back to the 2nd row, and suprisingly the srno is now 3, need help thanks Prasenna opinion: yep the seed is autoincremented by 1 and suppose a variable called number is holding the count,. it will not go and redecrement when ...(your case) ... a newnumber() is called when ne ...Show All

• Visual Studio Express Editions Variables

  Hello, I need to know the different variables used in C#. Could someone give me a site or just tell me through a post what each of them are, and their definition. Thanks. No sorry, I know what an int is, and a string, and a bool. But I need to know what the rest are, and what they are used for. I think that there are 12 or 13 variables. ...Show All

• .NET Development OTP: Help with speed

  Hi all, I have a asp.net 1.1 app that Im running on a clients server its all going well, but he complains about it running "slow" I have alot of postbacks, but it shouldnt be that slow. How can I see what is taking time, how my code is inefficient etc... so as to speed it all up Thanks for the help Mark Ok Ill post it over there. And that could very well be the correct response, but I'd still like to look into some code analysis tools first. ...Show All

• Visual Studio 2008 (Pre-release) Read ClaimSets in BeforeSendReply of IDispatchMessageInspector

  Hi, We are working with a IDispatchMessageInspector and we want to read the user's claims in the BeforeSendReply method but when we read OperationContext.Current.ServiceSecurityContext.AuthorizationContext.ClaimSets We get 'System.ServiceModel.OperationContext.Current.ServiceSecurityContext' threw an exception of type ' System.ObjectDisposedException ' Using OperationContext.Current.ServiceSecurityContext.AuthorizationContext.ClaimSets in the AfterReceiveRequest method works great. We are using the June CTP. How can we read the user's claims in the BeforeSendReply method of the IDispatchMessageInspector Thanks Jp.- I am using July CTP,i am able to access claimset,i am using wsht ...Show All

• Visual Studio Filter out null column values

  I have a dataset that returns the all the days of a month and some other data. Ex. Day Item SellingPrice 1 a 1.00 2 c 1.50 3 a 1.00 3 c 1.50 4 NULL NULL 5 c 1.50 5 c 2.00 Some days are returned more than once, but all days are returned (1-31). I have a Matrix where the columns are the items and the rows are the days. The matrix sums total sales for a day based on the item. The reason I return all days is so an empty day is easy to spot. My problem is that when I run the report I get a blank column that comes from the null items in the dataset. How can I filter this 'null' column out I have tried various filters and everyone that I think should work doesn't do anything or ...Show All

• Visual Studio Tools for Office Advanced Outlook addin .msi/setup.exe Questions

  I've written a working installer. If the user runs it, he has to hit "next" once or twice to install it. No actual decisions have to be made. If we roll out an upgrade, the user has to uninstall the old addin before he can install the new one. So I have two questions about making this process better: First, what would I have to do to make my installer suitable for, say, SMS deployment I'd like to take the burden off the user. I looked at the "Admin" installer functionality, but I interpreted that as a process which simply sets the app to run or install from a network, as opposed to automating the local install itself. Second, isn't there versioning in the MSI system such that you can install a newer vers ...Show All

• Visual Basic my first DLL: Class is visible but not Functions

  I'm learning how to write a DLL in VB Express 2005. It compiles fine: Public Class Common Public Function FourTimes( ByVal x As Long ) As Long FourTimes = x * 4 End Function Public Sub SayHello() MsgBox( "Hello from Pearl4.dll" ) End Sub End Class Then I create a TLB library file, which also appears to work fine: C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\regasm.exe C:\Windows\System32\Pearl4.dll /tlb I want to access the functions in VBA, so in Access I added a Reference to the TLB, and now I can see the class named Common, but neither of the two procedures. How do I make them visible Thanks for your help. Henry You'll need to either c ...Show All

• Visual Studio Tools for Office Excel 2003 addin with actionspane

  Hi I have created addin for Excel2007 using CustomTaskPane in C# VS2005, VSTO, works geeat, but my client need to run addin in Excel 2003. How cand I show my customcontrol in ActionsPane Source code would be verry usefull! TIA Paul Is your addin a workbook addin or application Actions panes don't work in 2003 application addins unfortunately. I've tried quite extensively to get around it with no success. ...Show All

• Visual Studio Express Editions How to Print an RTF Document.

  This may have been answered previously (if so I apologise for the redundancy). But how do I go about making a button that, when pressed make the RTF box in my application print out. please be detailed or link me to somewhere that is...as I'm still not that great at VB.net Thanks in advance to anyone who answers my call. ‘ Posted by Nobugz ‘ http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1044135&SiteID=1 Imports System Imports System.Text Imports System.Drawing.Printing Imports System.Windows.Forms Imports System.Runtime.InteropServices Public Class RichTextBoxPrinter '--- P/Invoke declarations <StructLayout(LayoutKind.Sequential)> _ private structure CHARRANGE Public cpMin As Integer Public cpMax As ...Show All

• Visual Studio Tools for Office Office Interop Assemblies

  When deploying an .NET application that uses Microsoft Excel, how do I check for the existence of Excel on the machine before starting the program The issue lies in that the project I am working on references the Microsoft Office interop assemblies and I need a way to check if they exist before starting the application. Well, we'd need to know if you're using Office 2003 or 2007 ... if you're using 2003, then you'll want to look into implementing AppCheck and PIACheck. You can obtain copies from Mad's Blog http://weblogs.asp.net/mnissen/archive/2006/05/03/444927.aspx If you're using Office 2007, AppChecka and PIACheck won't work; however, one way you can check the registry key HKEY_CLASSES_ROOT\Excel.Application\CurVer, which woul ...Show All

• Visual Studio 2008 (Pre-release) MessageContract does not serialize lists correctly?

  For some reason the following MessageContract will not work, complaining that a set accessor is needed for the property: public class GetOrderStatusDetailsMessage : MessageContract { private List<string> orderIds = new List<string>(); [MessageBody(Name="orderIds")] [XmlArray("orderIds")] [XmlArrayItem("orderId")] public List<string> OrderIds { get { return this.orderIds; } } } Normally for ICollection subtypes you don't need a set accessor as it understands it just needs to get the instance and call .Add on it. This rule certainly works with my data contracts, but not with message contracts. Adding a set accessor in allows everything to work, but I find it od ...Show All

• SQL Server SSIS logging

  I am executing the SSIS package and generating the execution log information in SQL server and text file. i.e. using the SSIS---->logging and there SSIS log provider for SQL server and SSIS log provider for text file. Now I want to push the execution information of all the events in SQL server whereas in text file I want to log only the OnError events. Now I am unable to to select the different set of the events for two log provider (SQL server and text file) Please suggest how to do this. ...Show All

• Visual Studio Team System Error when trying to generate Unit tests.

  I have previously been able to generate unit tests from the IDE but now I recieve an error: The source code cannot be sufficiently parsed for Code Generation. Please try to compile your project and fix any issues. I've recompiled, cleaned, etc the projects in the solution all the ways I can think of and I still recieve this error Anyone have any ideas Hi, What kind of project is it and what language are you using Thanks, David Gorena Elizondo [MSFT] VSTS ...Show All

• SQL Server sql server 2005 auto convert text to UPPER case

  Our sql server 2005 database is receiving data from a third part program over which we have no control. We need to be able to automatically convert data entered in one column of one table to UPPER case only. How can this be done in the table itself I would think that an AFTER trigger to convert the data to upper case would work (given no other info, that's my guess). CREATE TRIGGER myTrigger ON MyTable AFTER INSERT AS UPDATE MyTable SET MyColumn = UPPER(MyColumn) WHERE PrimaryKey IN ( SELECT PrimaryKey FROM inserted ) ...Show All

• SQL Server SQL Exception like clockwork

  Setup: Windows Server 2003 (Standard Edition) WITH Service Pack 1 SQL Server 2000 WITH Service Pack 4 SQL Reporting Services WITH Service Pack 2 SQL Server 2005 Upgrade Advisor - Migrate Legacy Maintenance Plans Installed SQL Server 2005 + SQL Server 2005 Reporting Services Pretty impressed at how smooth the transition was during the upgrade. SQL 2000 went down for less than a minute and up came SQL 2005. The upgrade was a success (nothing broken). BUT. Problem 1.  "Cannot find folder "\Maintenance Plans"."                Solved by using a system sp to add the folder. Problem 2.  "Unable to read local eventlog (reason: The parameter is incorrect) ...Show All