Shihan's Q&A profile

• Silverlight (formerly WPF/E) WPF/e vs. HTML

  After reading Mike Harsh's blog post What WPF/e Really is . I'm kind of disappointed with the approach that the Architects are taking with WPF/e, as in that it augments HTML instead of replacing it. Why not Personaly I find that HTML slows me down in producing rich content for my users (something that WPF promises). Sure its easy, its fast, and we should keep it (not every website needs rotating letters). However, as I see .NET being used -alot- for mission critical application, I would only EXPECT WPF/e to take the fore front and upgrading the way we provide commericial services on the Internet in a fast, uniform way. Flash is doing this, Flex is not 'augmenting' the Web, its rewriting it. Share your thoughts. Bar ...Show All

• SQL Server distinguish between the Publisher and the Subscribers

  I have a database on SQL Sever 2005 SP1 against which a Publication has been defined and to which many servers (both Workgroup and Express editions - SP1) Subscribe to. I would like to be able to distinguish between the Publisher and the Subscribers programmatically via T-SQL. From reading BoL and various forums it appears that the IsPubl ished, IsMergePublished and IsSubscribed options of the DatabasePropertyEx function should give me this information. However within all our tested environments, whilst the IsMergePublished option returns expected values. IsPublished and IsSubscribed both return 0 on all servers (the Publisher and Subscribers). Is this a know issue and how can I rectify the problem or alter ...Show All

• SQL Server After an insert, how do I get the primary key of the new row?

  I am using C# and ADO.NET After executing an INSERT, I would like to retrieve the primary key of the last row inserted. I've tried running SELECT @@IDENTITY in a query, but I get an OleDbException with the message: {"Syntax error. in query expression 'SELECT @@IDENTITY'."}. does anyone know what to do Someone asked me the same thing today and after a couple of hours I've came up with this (the code is in VB but I will try to explain the concept as well as I can): I'll use a sample table from a SQL Server (I work with an SQL 2000 right now). The table is called _FluxModels and has two fields FluxModelID (an identity field) and FluxModel (a varchar (50) field). In order to update the ta ...Show All

• Windows Forms Screen resolution affects GUI

  Hi, I've developed an windows application in VS2003 (VB.NET) and set form window size as maximized. Problem is, GUI affected b'cos of different resolution in deployment PC. My Development PCs Max .Resolution is 1400 x 1050 (32 bit). Deployment PC has a Max. resolution of 1024 x 768. Many controls are out of the screen. How to bring the exact GUI what i designed before . I've seen an article in Code Project. but i Couldn't get a clear Picture abt the concept. Sometimes Manually , I'm adjusting the GUI. Please give me good solution for it. I want to design an apps that fits to all kind of screen. Thank You! You need to redesign your form to fit the minimum resolution you may ...Show All

• Visual Studio Express Editions not able to run a new instance of EXCEL.EXE from VC++ code

  Hi, I want to run a new instance of EXCEL.EXE from my code (if there is already one running) in VC++ . I am using Visual Studio 7.0 ..and then i need to attach my process to that new instance of EXCEL.EXE.. please help Regards, Prashant You can use the system method. Search MSDN for that. By the way, these forums are specific for the VC2005 express edition. For non VC2005 version, use the newsgroupsat http://msdn.microsoft.com/newsgroups Thanks, Ayman Shoukry VC++ Team ...Show All

• SQL Server Remove SP1 or install SP2 Dec. CTP

  This sounds trivial but it has become an issue here. We had the original RTM of SQL2005 with Reporting Services installed and running fine. We were explicity NOT installing SP1 because of a feature that was removed from reporting services (the select-all checkbox in the multi-value parameter). This feature is supposed to be back in SP2. So wouldn't you know it, somehow someone inadvertently installed SP1 in the course of doing windows updates and now users are complaining about the missing select-all checkbox. I figure my options are to either install the SP2 Dec CTP or try uninstalling SP1 (if that's even possible). Any recommendations Ah! there is a hotfix addressing this very issue. I will try it. ...Show All

• SQL Server Problem with SMO on a ASP.NET page

  Hi ! I have done an EXE which copy a database using SMO. When i double click my exe everything is working fine. If i tried to execute my EXE in a ASP.NET web page the process is start but doesn't do anything. If i tried other EXE i've made it's working fine so the problem seems to come from SMO. Did i have something to add to my code if i want to use it in a webpage In common no, did you try to debug the SMO application / library which you wrote HTH, jens Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual Studio Express Editions keyboard event

  If it's possible id like a "Do Until" loop so that it loops until a key is pressed, any key at all well this is helping but its not what i meant. i meant a click in general not when a person clicks on the form. ...Show All

• Visual Basic from dgv to excel start on line 18(I got it)

  I'm able to print from dgv to excel with the following. Dim r As Integer Dim c As Integer For r = 0 To InvoiceDetailsDataGridView.Rows.Count - 1 For c = 0 To InvoiceDetailsDataGridView.Rows(r).Cells.Count - 1 Dim s As String = InvoiceDetailsDataGridView.Rows(r).Cells(c).Value xlsheet.Cells(r + 1, c + 1).Value = s Next But how can I get it to start in excel line 18 I understood what you said, when I do Dim r As Integer Dim c As Integer Dim s As String For r = 17 To InvoiceDetailsDataGridView.Rows.Count - 1 For c = 0 To InvoiceDetailsDataGridView.Rows(r).Cells.Count - 1 s = InvoiceDetailsDataGrid ...Show All

• .NET Development HttpWebRequest.GetResponse gives HTTP 502 error in Framework 2.0

  When trying to access a URL on a remote server over a VPN, HttpWebRequest.GetResponse throws System.Net.WebException: The remote server returned an error: (502) Bad Gateway. The same application runs fine in Framework 1.1. Any ideas I am having a similar problem. I have an application that works fine with .NET 1.1 and fails with 502 errors when run under .NET 2.0. Can you provide additional information on disabling of the new auto proxy detection feature Thanks. ...Show All

• SQL Server Declare Variable For All In SP

  In a previous life, for each variable that we passed into a query, we would set -1 to the default for all so that when we converted it to an SP, we could query a specific dataset or or all.  The following is a sample bit of code, I can not for the life of me remember how to pull back all using -1. The following is the code that I currently have, it's a simplified version of the total SP that I am trying to use, but enough to give you the idea of what I am trying to do. The MemberId field is a varchar(20) in the table. Create procedure sp_GetClaims_BY_MemberID @Memberid varchar (50) as Select top 100 * from [QICC-TEST].dbo.tblClaims_eligible where Membid = @memberid EXEC sp_GetClaims_BY_MemberID '99999999999' The above S ...Show All

• Windows Forms is there a limit on Controls contained in VS 2005 .NET Form ? handle creation exception

  I get a Error creating a window handle upon trying to create the 9937'th control. The number of controls when the exception occurs is dependent upon the mixture of controls created, InkEdit controls produce the exception much earlier. I was attempting to reproduce the incosistent behavior of ToolTip in my "real" application which currently has 9,216 controls (previous post that has no solution yet!). This has the feeling of running out of memory OS: Windows XP professional (32bit), patches as of 9/12/2006 CPU: Dual Core Opteron, 2GB Ram Attached is the exception detail and the files that make up the VS 2005 test program. ================================================================== System.ComponentModel ...Show All

• SQL Server Autogrowth values keep changing

  Hi! We have 2 dbs on our dw-server and the autogrowth values for both the data- and logfiles on both of these dbs changes about once a month. The data autogrowth value changes from 10megs to a percentage value between 3200 and 6400 and the log-file value changes from 10 percent to a percentage value between 3200 and 6400. Resulting in huge files and filling the drive. What am I missing here BR John Yes - we've been hit by this as well. We had it set to autogrow by 250MB, until after a reboot where it changed to 32000%. Unfortunately we didn't spot this until we filled up our log file disk. The annoying thing was that SQL Server Management Studio doesn't let you change back a value that has ...Show All

• Windows Forms Is there any way to spin through the objects in a property grid

  Hello all, Is there any kind of an items collection buried inside a PropertyGrid I know there is a SelectedGridItem property, but I need to iterate through them and I have been unsuccessful in finding out a way to do that. Thanks in advance for any ideas and/or suggestions! Better late than never I guess.. Here is one way to do it. if the SelectedObect property is not null then SelectedGridItem property will always be valid , even if the SelectedObject contains no browsable properties. The GridItem object contains Parent, and GridItem s properties. This gives you a path to every GridItem on the PropertyGrid. In the code snippet below are two simple static functions. One for get ...Show All

• Visual C# How to tell VS C# to stop coying ref assemblies locally

  Hello, I'm using VS2005 Pro Edition and my C# project is referencing an external assembly. The external assembly gets copied locally in my project folder when I build the project in debug mode. Also, the output library that the project builds is created twice: one copy in the project output folder (as set in my project) and another copy in the obj\Debug folder. I really need to get rid of this behavior. Is there an option in VS2005 to avoid that Thanks for your help, -mab OK I see: <Private>False</Private> What about the output lib being copied in obj\Debug Is there also a similar XML tag for that Thanks -mab ...Show All