ashish.'s Q&A profile

• SQL Server selecting colunm with a space ''

  When I submit a sql : select * from view from column='' the table is a view point to oracle table with ole db provider for oracle In mssql2000, the result return rows which containing a space ' ' However, in mssql2005, the result return no rows . Any advise on it Can you post the SET STATISTICS PROFILE output for the query You need to run the SET statement and then run your query in SQL2000 & SQL2005. This is most probably due to some plan change but we can confirm that by looking at the output.   Please post the view definition if it is anything more than a SELECT from the Oracle table ...Show All

• Windows Forms Yet another Toolstrip question.....

  I have a really large project around a toolstrip. It already has several thousand lines of code to support all the dynamism I want. I run toolstrips through many conceivable configurations. I put them through flow mode and change their stacking etc. Now, I'm seeing something new that I have not seen before. The toolstrip separators are horizontal and look like hyphens instead of the nice vertical separators.  A drop down button gets very small and is only the size of the arrow head. Once they do this, I can't get them to appear as they used to. Also I've seen this with new projects with default toolstrip item settings with NO code invol ...Show All

• Visual Basic Unable to Close Serial Port after USB/Serial Converter Disconnected

  I have a stand alone VB.Net 2005 application that uses a serial port that generally stays open while the application runs on a Windows XP system. In trying to bullet-proof the UI, I ran into a problem when the USB to Serial Converter normally used to provide the serial port is disconnected while the serial port is open. In trying to handle the resulting error when accessing the port, I find I cannot close the port. When trying to do so, the error message says something like "unable to close the port. You may not have sufficient permissions." Reconnecting the USB/Serial Converter does not reactivate the port. I ran the PermCalc.e ...Show All

• Visual Studio Can't debug ASP in VS2005

  VS2005 doesn't seem to support debugging ASP pages. Is this really so That's a serious problem if it is. Thanks Jeremy No, she meant IE. Can you clarify what you mean by 'refuse to debug them'. Do you see your ASP documents in the Script Explorer window As for the many requests to bring back auto-attach support for ASP debugging, what are people looking for: Debug classic ASP code locally Debug ASP code + .NET code (either a .NET COM object or ASP.NET code in the same process) Debug class ASP code on a remote computer Case #2 and #3 are pretty hard to solve. On the other hand, Monica's ...Show All

• SQL Server IIS Internet Info Services

  Hi, I'm trying to install SQL Server 2005 Enterprise edition. It is telling me that I don't have IIS installed and that it may cause some problems. I can't find where to install from add/remove components nor can I find it in any of my network connections. Does anyone know where to install this from Thanks in advance. Newbie.......Eric IIS comes with XP Pro, it is not available with XP Home. It's never installed by default, but you can add it in add windows components. ...Show All

• Visual Studio Team System Custom rules again.....

  hi all, i'm trying to develop a new custom rule which will help me in checking the exception handling in FxCop..... The first one is about checking whether the custom exception derives from application exception.The system exception derived are excluded for CLR. How do i make any headway into this rule The other exception handling rule is about checking whether any destructor is throwing any exception from inside. if yes, the CLR stops executing and pass the exception to the base class destructor. if there is no base class, then the destructor's discarded. The easiest way to do this is to w ...Show All

• Smart Device Development force to load compact framework on desktop?

  I would really appreciate it if you could help me with the following question regarding the compact framework Is it possible to force a dll/exe compiled using CF to be loaded on desktop using CF for example I have a form to display the following information Environment.Version.ToString(); I compile it using CF ( by command line csc /nostdlib /noconifg ...etc ) I can deploy it onto a device and it shows 2.0.5238.0 If I just go to the compiler output folder on desktop and double click the output exe It shows 2.0.50727.42 which is the full 2.0 framework my goal is to run the exe on desktop but have it running under CF so the two way ...Show All

• Visual C# Unable to update the dependencies of the project

  I have had this error every time I try to check my program into source control after making changes. The project builds and works fine until I check it in and check it back out then it won’t build. I have deleted the setup project and built a new one only to have the same problem after checking it into source control. It also givs me a warning that " Assembly ' FolderName\FileName.exe ' is incorrectly specified as a file. Any suggestions would be helpful. I need a little more information to try to narrow things down.  I should mention that there do seem to have been similiar problems reported before [ ...Show All

• .NET Development Delayed send with smtpclient in .net 2.0

  Is there any way to force the smtpclient to send mail immediately with the .send method in system.net.mail 2.0 Right now it takes anywhere from 90 secods to two minutes before the mail is actually sent once the .send method executes. I've tried setting the object to nothing immediately after the .send method call, but no luck. The real issue for me is the send delay is also causing the smtpclient  to hold a lock on attached files that are being sent for that same 90 seconds to two minutes. I need to move the file immediately after emailing it, and right I get an exception telling me two processes can't access the file at the same time ...Show All

• .NET Development XsltArgumentList and XmlObject.TransformArgumentList Issues

  Hi, I'm in the process of testing out my asp.net 1.1 application under the new 2.0 framework. For the most part, everything seems to work, however one of my applications uses XSLT Transformation objects to adjust the rendered HTML to the client. In 1.1, I was creating a new XsltArgumentList object and filling it with .AddParam I'd then set the newly created XsltArgumentList to the XmlObject.TransformArgumentList = myXsltArgumentList This would transform the XML control datasource XML document with the provided transformation list, however in asp.net 2.0 Final it doesn't seem to do anything. Can anybody else either confirm or deny this issue ...Show All

• Visual Studio How to change the font of a shape?

  How can I change the font for    1-) whole shape   2-) diagram   3-) part of a shape (like only compartment items, or title) Thanks. Fonts are a bit of a tricky thing in the diagramming surface. First, there's no easy way to change the font for the whole diagram. You'll need to change things at an individual shape level. You can change the font for all of the decorators on a shape (I've added the code for this below), but it's complicated by the fact that decorators are not ShapeFields, so you need to change the font information on each decorator. However, one of our planned changes ...Show All

• SQL Server Why use nested table?

  Hi, all here, I have a question about nested table use. I dont quite clearly see through why the nested table is very much necessary I mean if we need information from both the current case table and nested table for mining models, we can just join both tables Thanks a lot in advance for any guidance and help. Nested tables are useful in two ways: 1. As a natural modeling concept for one-to-many relationships - examples: products purchased by a customer, movies watched by a person. 2. As a powerful and compact way of representing variable-length, sparse cases where individual cases contain only a small subset of the poten ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. LoaderLock was detected

  Hi, I have installed DirectX 9 SDK (October 2005) and Visual Studio 2005 RC1. When I try using directx classes for capture audio, I have a problem. The code i have wrote is: Dim d As DirectSound.Device Dim ds As DirectSound.CaptureDevicesCollection ds = New CaptureDevicesCollection For Each d In ds           Me .ListBox1.Items.Add(d.ToString) Next When I run the application I get error when creating new instance of CaptureDevicesCollection. The error is : LoaderLock is detected. The MDA message is: LoaderLock was detected Message: DLL 'C:\WINDOWS\assembly\GAC\Microsoft.DirectX ...Show All

• Visual Studio Team System "Unexpected token was encountered" error after schema import

  Greetings, After importing a schema from a SQL Server 2000 database to a project targetting SQL Server 2000 the parsing engine seems to have some problems with specific constructs... IF dbo.fnIsBillPullError() = 1 "Unexpected token was encountered" error being generated for User defined Functions. RAISERROR ( '%s (%d)' , @Severity, 1, @sMsg, @iErr) "Unexpected token was encountered" error being generated for some RAISERROR calls. ALSO if an error is detected relating to a UDF then some stored procedures are showing "Unexpected token was encountered" errors relating to the END part of a B ...Show All

• Windows Forms BindingSource: Refresh data

  How do i refresh the data of a BindingSource without fully reloading the data I have a DataGridView for showing my record, but each time i add, edit or delete a record i must fully reload the data from the database :( Also there seems to be some kinda bug in the DataGridView ... Before i start loading the data into the dataset again, i must remove the databinding to the datagrid or i get some out of index errors :( see if you are not working with selectedIndex property. I have same problem with out of index and think this is because I use it selectedIndex to select row. you can create yourown up ...Show All