sn1022's Q&A profile

• Windows Forms IndexOutOfRangeExceptionwhile deleting multiple rows from a bound DataGridView

  Hi, I have a DataGridView which is bound to a bindingsource. In my DataGridView, I have a nbound checkboxcolumn which i use to select multiple rows from the datagridview without using CTRL+LCLICK. When the user selects a row by checking that checkbox, the row is added to an ArrayList called selectedMembers. Then if user clicks a delete button, those rows in my datagridview are deleted but ofcourse with the exception window below appearing forever even if it is closed : --------------------------- DataGridView Default Error Dialog --------------------------- The following exception occurred in the DataGridView: System.IndexOutO ...Show All

• SQL Server Strange out of memory error on 2005

  Hi, I am getting the following: spid53,Unknown,Failed Virtual Allocate Bytes: FAIL_VIRTUAL_RESERVE 262144 spid53,Unknown,Memory Manager <nl/> VM Reserved = 1662084 KB<nl/> VM Committed = 954940 KB <nl/> AWE Allocated = 0 KB <nl/> Reserved Memory = 1024 KB <nl/> Reserved Memory In Use = 0 KB ... <lots of memoryclerk/cachestore stuff) ... Followed by loads of 701s (There is insufficient system memory to run this query.) until the service is stopped. No new connections can be made at this time either. I'm running an ASP page under IIS 5.0 (on 2000) against the SQL Server. Connec ...Show All

• Visual Studio Tools for Office How to customize column into VSTO's Excel sheet

  Hi all, I have done following: 1. Click on "Add New DataSource" into Datasource configuration wizard. 2. Choose the "Object" from the options. 3. Select any of the classes from "NameSpace.Entities" dll generated by myself that works as dataaccesslayer. Lets suppose class is "XXX.cs", select it & click finish. 4. Open the "Datasource Explorer", Browse the class "XXX.cs" that i have selected in the above process. 6. Drag this class to the excelsheet, datagridview of the class get represented with bindingdatasource control. 7. Write code to grab all the data with this class to the sheet_startup ...Show All

• Smart Device Development problem with pocket pc emulator on localhost in VS 2005

  HI, I'm trying to develop a Mobile web application in Visual Studio 2005 (in Framework 1.1). I am trying to run it in Pocket PC 2003 Emulator. But when i press F5, i get an error saying that the application cannot open http://localhost/.../..aspx (I have added the emulator.exe file as default browser thru File->Browse With->Add..) Can anybody help me regarding this problem as to why i cannot rum my application on localhost/pocket pc emulator Using 'localhost' instead of actual host name is probably #1 mistake with WS. 'localhost' means 'host, this software is running on'. Sinc ...Show All

• SQL Server Problem using dates in XMLtoFLFF Transformation

  I am having a bit of trouble transforming a XML (xs:date) type to the DBDATE in my FLFF. I believe the problem is because the SSIS DF (Metadeta) converts xs:date to DT_DBTIMESTAMP which becomes 01/01/2005 00:00:00 -- appending the time. So when I try to transform in my fixed length flat file, it throws a truncation error when the length is set to 10. (which is the length of date) Is it possible to (A) use some other xs format that changes DF Metadata to only use date and not DT_DBTIMESTAMP, or (B) is there a field type in the destination FLFF Connection that will allow a length of 10 without throwing a truncation err ...Show All

• Visual C# Excel range from event

  Using the following event to get range info from Excel: private void SelectionChange(Excel.Range Target) { _currRng = Target; _currWS = (Excel.Worksheet)_currRng.Worksheet; _currWB = (Excel.Workbook)_currWS.Parent; string address = _currRng.get_Address(Missing.Value, Missing.Value,_xlRef ,Missing.Value,Missing.Value); _currWS = (Excel.Worksheet)_currRng.Worksheet; _currWB = (Excel.Workbook)_currWS.Parent; lblWB.Text = _currWB.Name; lblWS.Name = _currWS.Name; lblAddress.Text = address; } When the 'SelectionChange' runs the get_Address method invariably returns an empty string. If  ...Show All

• Windows Forms Creating an exe without using a Form

  I have been using ASP.NET for some time, but now I need to be able to create a quick program that sends out an email if a file exist. A batch file will be executing this file on a scheduled basis. What is the best way to write this. (By the way, I have the code to do this, I did it as an ASP.NET application, now I&nbs ...Show All

• Visual C# RaftingContainer upgrade to Beta 2

  I don't even know what a rafting container does.  I assume that it was automatically added to my forms when I added some other controls.  Now when I upgraded to Beta 2 it is obsolete and I need to change to ToolStripContainer I think. I have top, bottom, left, and right RaftingContainers, what are they there for thanks for looking, dave Well, I think it is something left over from playing around with different controls.  I commented out every line that contained RaftingContainer and I don't notice any difference in my app. Thanks for the information. dave ...Show All

• SQL Server SQL Server 2005 Express June CTP Setup Error

  Hi Folks, When I try to install the software, I get the following error: TITLE: Microsoft SQL Server 2005 CTP Setup ------------------------------ The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." For help, click: http://go.microsoft.com/fwlink LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1187.07&EvtSrc=setup.rll&EvtID=1603&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlScript%40sqls%3a%3aService%3a%3aStart%40x429a ----------------------------- Clicking Help reports that there is ...Show All

• Visual C# Cursor problem

  I have a project with two namespaces, and all I want to do is load a cursor resource in one of them. Sounds simple doesn't it The cursor has it's Build Action property set to Embedded Resource. I use the following code to load it: Cursor = new Cursor(GetType(), "Rectangle.cur"); This works fine in one namespace, but fails in the other. I receive an unhandled exception of type 'System.NullReferenceException'. Additional information: Object reference not set to an instance of an object. Can someone tell me how to overcome this error please Thanks! The constructor you are using, tak ...Show All

• SQL Server What happened to good old object search ???

  Hi There I have been working with MSS Management Studio for some time now. One thing really bothers me, i cannot find the equivalent for object search found in good old query analyser. I have many QA databases, and the all have tens of thousands of tables and views. If i need to find a table or view i go to query analyser and do an object search and i get the result within a second. The only thing i can do in Management Studion is filter the views or tables for the one i am looking for , problem is with the number of objects in these databases i can go for a smoke and come back before i get results. Am i missing some ...Show All

• .NET Development Abstract classes and interfaces

  I'm a newbie to C# but ran into the following issue and was wondering why I had to do what I did to get the code to compile. Let's say I have an interface defined like this: interface Foo { void doFoo(); String getBar(); } Then I make an abstract base class: public abstract class Bar : Foo { public String getBar() { return "Bar"; } } With a concrete implementation: public class ConcreteBar : Bar { public void doFoo() { Console.WriteLine("Doing Foo..."); } } When I try to compile the code, it tells me I can't as class Bar doesn't implement method ...Show All

• Visual Studio Team System Remote Accessing of VSTS Source Code Control (SCC)

  Hi, We are having our TFS Server installed remotely(in US) and our machines (in India) were able to access the TFS Server. The problem is that we are not able to "Check in" or "Check out" the code from the source code control from Team Explorer  as the "Get Latest Version" and "Check out for Edit" menu options were disabled or through the command line method . So kindly let us know how to resolve this problem. How can we enable the source code control accessible remotely. Please mention the steps which we have to implement on server and as well in client machines. Thanks & Regards, Venu Madhav Deevi. Hi Venu- When Get L ...Show All

• SQL Server Shortcut to move the splitter in Management Studio?

  Apologies if this has already been asked. In SQL 2000 QA, the ctrl-b shortcut by default put you into move splitter mode when you had the results pane showing. I cannot find the euqivalent shortcut in management studio's query window. Has this been removed or is there another shortcut that does the same thing This may not sound like a big deal but it's having a definite impact on my productivity by interupting my train of thought and making me use the mouse! This is not available in SQL Server 2005.  Please request the feature at https://support.microsoft.com/common/survey.aspx scid=sw;en;1208& ...Show All

• Visual C# Design Question

  Pretty new to C# and Im rewriting a VB6 app that contains many features that should force the ol learning curve. I have hundreds of images that are saved with a filename, such as: temp1.jpg temp2.jpg....etc. The full path will have to be added later, probably to a list or Arraylist...in numerical order. As I recall I had to jump thru hoops to do this sorting with VB. temp1.jpg temp101.jpg temp2.jpg temp211.jpg....etc. What is my best bet now I can name the files anything. I just need to load them later numerically as fast as possible. Sorry, I didn't save the thread. That quote was basically the only thing worth gleaning. Looks li ...Show All