Amit Bansal's Q&A profile

• Visual Studio Express Editions Please Why?

  Why was my last post taken of the forum without any notification why or what I said wrong Is someone hiding something seems like it to me. I aint going to write the full problem until i get a post back, just incase this post gets deleted aswell. Problem I have is with the clickonce Installer built into Vb Express 2005 awaiting patiently for a reply Thanks. it was moved to the appropriate forum as I had replied to it to tell you about this, you should have got a notification but most certainly shown up in the "My threads" section in the navigation bar at the top rightish corner of your screen: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=684116&SiteID=1 ...Show All

• SQL Server Help Creating Dynamic Reports

  I can create static report with Report Server, but wanted if anyone can help me create a report that is dynamic and regenerates with new data as it comes in. Thanks so much! Jvinsky, Maybe I missing something in what your asking, but adding a dataset to your report, add those fields on the report will get you a dynamic report as "your data changes". If you add a dataset which returns customers, you will see all of your customer, if customers are added to the table and if you refresh your report then you will see those "new" customers. I hope this is what you meant by "dynamic". Ham ...Show All

• .NET Development DS HELP

  I currently have this error when I delete a record and then save it. My code is at the bottom of this post, im a newb to this though wish to learn. Though i've tryed to google this many a times and still come up blank with out knowing how to fix this problem. Can anyone help much thanks and please keep the answer with simple instructions. --------------------------------------------------------------------- ERROR: Update requires a valid DeleteCommand when passed DataRow collection with deleted rows. {"Update requires a valid DeleteCommand when passed DataRow collection with deleted rows."} System.InvalidOperationException was unhandled Message="Update requires a valid DeleteCommand when passed DataRow col ...Show All

• Visual Studio Remote Debugging (not domain managed)

  I'm using VS2005 Team Edition, and can't figure any way to attach to a remote machine that is not network domain managed. That is, the machine I want to remotely debug, is in a network workgroup, not a network domain. I can't figure what I'm supposed to call the machine in the "qualifier" line of the "attach to process," and I can't figure what "permissions" to give in the remote debugging tool (msvsmon.exe). No matter what person/role/or permissions I try to assign in msvsmon.exe, it always tells me "unknown object." Can someone give me an example of permissions assigned in msvsmon.exe (msvsmon.exe is running on a box that is not part of a network domain), and the corresponding name syntax for ...Show All

• Visual Studio Team System Confused about SQL Server Licensing

  If I install TFS, I understand that the license includes a copy of SQL Server 2005 for use with TFS. Is this license ONLY for TFS IOW, I do not have to buy another SQL Server license (which can be expensive). Yes, you get the restricted SQL Server license which can be used only for the TFS. Excerpt from the licensing white paper : Using SQL Server 2005 Standard Edition As mentioned earlier, SQL Server 2005 provides the sole data repository for Team Foundation Server. A restricted-use license of Microsoft SQL Server 2005 Standard Edition is provided under the following terms: · You may only use the SQL Server software with Visual Studio Team Foundation Server; you may not use i ...Show All

• SQL Server Mon- Fri Bit fields Query

  I am having trouble figuring out how to complete this any help is appreiciated. I have Mon , Tues , Weds , Thurs , Fri as bit fields I need to write a query for a report to see if the value is true, and display M , T , W , Th , F in a column Days if they are scheduled that day example: Mon and Wed I got on the bus the checkboxes are set to True, I want one column in the report Days : to display M, W That is exactly what mastros' code does: Replace(RTrim( Case When Mon = 1 Then 'M ' Else '' End + Case When Tues = 1 Then 'T ' Else '' End + Case When Wed = 1 Then 'W ' Else '' End + Case When Thur = 1 Then 'TH ' Else '' End + Case When Fri = 1 Then 'F ' Else '' End) , ' ', ',') As Da ...Show All

• SQL Server Jump to Report Without Parameters

  Hi, Is there any way in Rs2000 "Jump to Report" Action, to pass only some off the target report parameters, and when the report opens fill the rest from the target report parameter area I can make this work in VS2003 but not in Report Manager. In Report Manager when you click the link it just clear the screen and stays like that. Thank you for your help Rgranada i do have a crude way of doing it and i still looking out for the best way to do it. for example, lets take @Empno is the parameter and u want to make it optional so declare another variable like @ES when u r passing employee number , then pass @ES = 'S' ( means selected) when u do not want to use @EmpNO , then pass @ES = 'A' (mean ...Show All

• Smart Device Development Overriding wceload's install directory in WM5

  In previous versions of Windows Mobile (starting with 2002, anyway), there was a way to programmatically override the install directory for a CAB with wceload.exe by using the /noaskdest command line switch and populating the following registry key: HKLM\Software\Apps\Microsoft Application Installer\Install With WM5, though, that functionality is half-broken. It's not completely ignoring that key, because the CAB file specified there is still installed, but it's ignoring the install directory that's specified there. What I'm wondering is, when will this bug be fixed, or is there now an alternate way to do it My reasons for wanting to do this instead of using wceload's install destination GUI are two-fold: - Uniform destination selection G ...Show All

• Windows Forms Exception is not propagated up the call stack

  in the name of god hi i got a problem in exception handling. i have two forms.i have a button on the first form (Form1). in that button's click event i will instantiate the second form(form2) and then show that form. then in the second form's constructor i will throw an exception, the i catch it and then throw another exception to propagate up the stack (or it could be a simple finally). when i run my application in debug mode (F5,F11 or F10) every thing goes well and the exception will propagate up the call stack. but when i build it with (Ctrl + F5) or i run the exe file by double clicking on it the exception is not propagated and that ugly exception message box will appear exactly on the second form. i have tested the resolution f ...Show All

• Visual Studio Team System Save "Test View" and "Test Results" column preferences?

  Is there any way to save the "column" and "group by" preferences in the "Test View" and "Test Results" windows Every time that I start VS2005, the tweeks that I've made to these windows are gone. For example, I like to see the "Class Name" in both windows when I run my unit tests. I have to right-click on the column headers, choose "Add/Remove Columns", find the "Class Name" column, check it, select the "Class Name" item, and then click the "Move Up" button until it is in the place that I want. It's seems incredibly unlikely that there's no way to save my preferences. Anyone have any ideas Thanks, -Ben Day Hi, We've hea ...Show All

• .NET Development Windows service access to UNC paths

  Hi, I am writting a windows service with C# (Running under the Network Service account). I need to be able to access shared network resources on a different domain from the one the service is running in. (this is in order to copy files) Usually this would be achieved by mapping the share to a drive letter using an API call. However, in this case, because the program is running as a service it cannot see any non-local devices. So my only choice, as far as I know, is to use the UNC path directly to access the files. Unfortunatley the share is on a different domain so although I have username and password I have no way to access it. Does anyone know of a way around this Hi, What you can do is the followi ...Show All

• Visual Basic VB & MODBUS TCP/IP, I need some help

  Hi, I have remote I/O which communicate with MODBUS TCP/IP. Now I want to control (write and read the status of the i/O) the remote I/O with VB. Now is my question do I need a extra OPC Server Or is this not necessary and can I directly control the I/O in VB. Regards Marc For what it is worth, I have recently dealt with the same issues with limited success. First, I haven't found anything pre-build into .net to deal with this. I suppose that you could make your own driver of sorts but you would neet to do a lot of research with respect to modbus protocol. There are several 3rd party vendors that sale modbus interface controls, but the number gets really small if you narrow the search to tcp/ip - .ne ...Show All

• Visual Studio 2008 (Pre-release) Problem getting started w/ WPF

  So I'm trying my hand at playing around a bit w/ WPF. I uninstalled the last WinFx 3.0 CTP I had installed, installed the new .NET Fx 3.0 June CTP and thought I'd try my hand at running the Cube Animation sample app. Following the instructions, the app built just fine using msbuild from the command prompt. When I attempted to open CubeAnimation.exe, nothing happens. I then tried opening CubeAnimation.xbap and was present w/ the error you'll find at the bottom of this post. I saw another post on here w/ a similar exception stating that before the Windows Image Component (WIC) also needed to be uninstalled so I followed this instrucutions (Uninstalled Fx 3.0 June CTP, ran the listed command to uninstall WIC, and then reinstalled Fx 3.0 ...Show All

• SQL Server sql server connection

  when I try to connect my application for database in sql server 2003, while compiling there is an error message "An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. That occurs in the code Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load DACategories.Fill(CategoriesProducts1, "Categories") DAProducts.Fill(CategoriesProducts1, "Products") End Sub how can I solve this. I uninstalled and installed SQL twice and VB.net once, but the problem was not solved It has an error msg: SQL Server does not exist or access denied . So, can ...Show All

• SQL Server Does anyone have sql2005 EE running on 64 bit Itanium server?

  I don't think mine is using all of the memory it could on the server. I've read that the Task Manager does not give you an accurate measure of the memory usage but 130 MB max does not seem right on a 12 GB server. I've set the minimum to 2 GB in SSMS. The account that is running sqlservice has Lock Pages in Memory privileges . I've turned on AWE in SSMS just to be safe. We are experiencing high CPU usage and my theory is that it is caused my unnecessary I/O due to not being able to cache. The serve has Windows 2003 sp1. The SQL2005 Buffer Manager AWE Lookup maps\sec, stolen maps\sec, unmap calls/sec, unmap pages/sec, write maps/sec are all 0. Any help would be appreciated. Below is the out from DBCC MEMORYSTATUS. This server also ha ...Show All