em malsi's Q&A profile
SQL Server Server Performance
Real quick I have multiple reports that use the same headers say Topic 1 and Topic 2 The body of the reports will have 0-50 records and 2-15 columns. These reports will be run many times concurrently. My question is which is more efficient 1. Open connection Call sp to returns Topic 1 and Topic 2 for report header Close connection Open Connection Call sp to return the report body data Close Connection 2. Open connection Call sp to return the report body data as well as 2 addition text fields of char(50) and use FIRST to extract headers Close connection Thanks ...Show All
Visual Basic Launch VB Program Instead of Default Browser
Is there any way to make Windows call a VB program instead of the default Internet browser What I want to do is to use a VB program with buttons down the left-hand side that when clicked will launch that URL in the browser windows of the form. This will prevent users from surfing in places they shouldn't but still allow them to get to the sites they need to get to for their jobs. These buttons could also change based on the username of the person launching the program. But it all depends on being able to call this program in place of the browser when they click on a link in a email or somewhere else. Thanks for the help, Jim ...Show All
Visual Studio Express Editions Extending the Personal Web Site Starter Kit
I have read the article on extending the Personal Starter Kit by Bill Evjen. There are 3 image files that he makes a reference to, that I cannot find. <table width="90%"><tr> ImageUrl="../Images/button_sitecontent.gif" ImageUrl="../Images/button_manageusers.gif" &nb ...Show All
.NET Development please help..iis 6
hi everyone, please reply asap if you can help. i'm running windows server 2003 with iis 6.0. i'm trying to start using asp throughout my website, so i made sure active server pages was allowed. for testing purposes, i installed iis 6 on my windows xp 64-bit computer. my pages worked fine. when i upload them to my 2003 server i get a 500 error telling me there is a problem with the page. the only difference that i notice between my computer and my server is that my computer has an "application pool" folder available in the iis console-the server does not. did i install something wrong i'm going cra ...Show All
SQL Server Problems with SQL 2005 Export Wizard
I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site. I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting: TITLE: Operation stopped... ------------------------------ The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails. --------------- ...Show All
Smart Device Development i m new...from where to start!
hello friends i m begineer who has not begin yet. please tell me how to start in mobile development. difference between smartphone,pocket pc, windows mobile 2005 thanx in advance what are you using to develop Visual Studio 2003 or 2005 as there are 2 version of the compact framework v1.0 and v2.0 v1.0 http://samples.gotdotnet.com/quickstart/CompactFramework/ v2.0 http://netcf2.blogspot.com/ ...Show All
Windows Forms Exception Error
Why would the following line: Dim dlResult As DataLayerResult = m_DataLayer.Login(txtUserName.Text, txtPassword.Text) give me an exception error System.NullReferenceException - Object reference not set to an instance of an object when I'm sure I am passing a user name and password across Many thanks Mark Thinking about it, I should explain further: I'm using a similar structur ...Show All
Windows Forms MSB3110
Hi, I am using mage.exe to deploy a simple clickonce application but I keep on getting the warning MSB3110 after mage -New application ........... I have read this MSBuild Error MSB3110 MSB3110: Assembly '<assembly>' has mismatched identity '<AssemblyIdentity>', expected filename: '<file>'. This error is generated when the assembly file name obtained from the assembly identity does not match the actual file name. To correct this error Correct the assembly file name so that it matches the assembly identity. how do i do that Hi, How did you fix this ...Show All
SQL Server SSIS custom component will only partially update in VS causing debugging to fail
When I try to debug the break points will always say the source code is different from the current version, but the custom component in the GAC has the new version number. The other strange thing is the toolbox will not reset to the original version meaning it will not remove the custom components. The funny thing is after I compile the custom components and restart VS the custom component runs with the new code changes. I can see the new features I added, but the debugger and toolbox still seem to be broken. I have tried the following 1) Reset the tool box. 2) uninstall all my custom dll from the GAC “C:\WINDOWS\assembly ...Show All
Windows Forms Getting Assembly Path from within a UITypeEditor
I have a property in a usercontrol that contains a combination of a user defined form class and the assembly it is contained in. It is formatted like: "MyNamespace.MyForm, MyAssembly". What I am trying to do is _reliably_ get the path to the assembly depending if we are at design-time or running the app. We can assume that the form assembly ...Show All
Visual Studio 2008 (Pre-release) ditto
Any comment on roughly when the next Linq release is scheduled, and what kinds of changes we can expect I would love to know as well ...Show All
Visual Studio Passing same parameters from Main report to subreport
Hello, I'm having a problem setting the parameters of a subreport. Both reports (main and subreport) use stored procedures. Both procedures have the exact same parameters (named the same as well). I tried to just straight assign the main parameter values to the subreport parameters and it doesn't like it. Can someone show me simply how to assign the the values of a subreport Thanks in advance. Greg You may want to give this a try: myReport.Subreports.Item(0).SetParameterValue(0, Value) ' Using Index Values or myReport.Subreports.Item("SubReportName").SetParameterValue("Par ...Show All
SQL Server SQL Server 2005 Stored Procedure inserting duplicate keys into table that is uniquely indexed
I'm having a problem in SQL Server 2005 Developer Edition where I am calling a stored procedure to insert a row into a table. In the example below there is a table called "Machine" with three columns, MachineID, MachineName, MachineIPAddress defined. MachineID is the table Identity and pk. MachineName is setup as a unique index and can not be null. MachineIPAddress can be null - it can also be ignored for the sake of this example. When I run the following stored procedure, inserting a MachineName that already exists, the insert occurs without error. However, when I try to insert directly into the table view in SQL Management Stu ...Show All
Windows Forms Low level error handling
Hi, I'd like to hear opinions on the best way to handle low-level errors. By low level I mean things like a referenced DLL or resource file being missing. Am I correct in saying that these will cause an exception before any of your "user" code execute If so, how should they be handled Thanks in advance. - Fergal ...Show All
Visual Studio Tools for Office Adding an outlook toolbar button
Using VSTO 2005 and VB 2005 I want to add a toolbar button (or a custom button with an image icon) to Outlook (Programmatically when outlook starts may be inside ThisApplication_Startup procedure ) and when a user click on that button do some e-mail processing. Any sample code This link might be helpful too: Outlook Tasks http://msdn2.microsoft.com/en-us/library/ms268731(VS.80).aspx ...Show All