Jessie J's Q&A profile

• SQL Server UDF returning a recordset

  Not sure if this discussion belongs here, but I couldn't find anywhere else to post this. I have inherited a process that is called from an ASP.net site that runs a query who's from table is a UDF returning a recordset. The question I have is, if the underlying tables in the UDF are properly indexed, will the calling query utilize those indexes, or will the process ignore them I have indexes set for those tables, but when the query is executed and the results are a few hundred records, it comes up quickly, but if the recordset is over 1000 records it is noticably slower and if over 10,000 records it is exponentially slower. Can indexes be put on a UDF (I pretty much already know the answer, but I have to ask) ...Show All

• Windows Forms Sql Native Client as Prerequisite

  Hi, I am about to deploy (clickonce) an application that makes use of the SQL Native Client to connect to SQL Server 2005 Express. What are my options here, is prerequisites the only (best) way to make sure the driver gets installed properly and prior to the application If so is the case, is there any material somewhere to read about on how to create a prereq. for SQL Native Client Kind Regards, Robert I don't know the particulars (like command line, exit codes, how to detect if it's installed already)... But, I do have a tool you can use to create the package called Bootstrapper Manifest Generator at: http://www.gotdotnet.com/workspaces/workspace.aspx id=ddb4f08c-7d7c-4f44-a009-ea19fc812545 ...Show All

• .NET Development Context menu shell extensions causing Explorer crash on Vista..help please..

  Hi everybody, Upon developing a .net application which has to have support for Vista and , at some point plays with some context menu shell extensions, i experienced a very very weird problem..Here is the situation: The application was developed for .net framework v1.1.4322. It has to dinamycally create some context menu extensions for folders so, the class responsible with the context menu logic implements IShellExtInit interface, IContextMenu interface and offers implementation for all the methods of the interfaces..All the rules are correctly respected (like keywords for "mirroring" the COM interface by the .NET one, the interface and the implementing class GUIDS, the assembly registered for COM upon instalation, assembly stro ...Show All

• Visual Studio No "Create Instance" menu item

  I use VS.NET VSTS Developer, and I am trying to use the Object Test Bench. Its documentation says I should use the "Create Instance" menu item in either the Class Designer, Class Diagram, or Class View, but I don't see such a menu item. Is it not available in the VSTS Developer edition Hi John My project is the startup project but I still cannot get the instantiate menu item to appear. Does my project being in sourcesafe have anything to do with it I created a dummy app outside sourcesafe and I get the menu item in my class viewer. Thanks in advance ...Show All

• .NET Development Strange SQL connection problem.

  I am building a windows forms app and I get this error when I connect to the DB The type initializer for 'System.Data.SqlClient.SqlConnection' threw an exception. The strange thing is if I put a breakpoint at the line that causes the error ; SqlConnection con = new SqlConnection (ConnStr); Hit the breakpoint and then F5 to continue, the code runs fine . The code only fails if I do not have a breakpoint on that line of code. The database is a SQL2000 db on another box referenced by an IP. Thanks for any help or ideas on this. PatC Without knowing or seeing the rest of your code, I'm going to take a stab and suggest you look at flushing your buffer. System.Windows ...Show All

• Visual Studio Express Editions Encrypting the exe

  Hi guys, i've got a major problem: If i save database connecting string in my application within a class everybody can read out these datas easily. ( Wont axplain here ) is there any way to encrypt the whole .exe .Or do u ve got any thir party software for doing this Have a nice day Sure, I play a code writer in security on TV and write a few hours/week of security related code. Here's what I do.... I encrypt strings inside the process when I put them in. It's a simple algorithm. It certainly is not made to keep NSA busy for more than a few microseconds. But you can't see any strings when you dump the file. After decrypting it and using it to accomplish what you need, you can always clear ...Show All

• Internet Explorer Development Does the IE7 Favorites Import/Export Wizard support Unicode?

  I have Chinese names and URLs in my favorites list. When I tried to export the favorites using the Import/Export Wizard, I examined the output xml file (bookmark.htm) and all the Chinese characters are gone, replaced with " ". I have the various Chinese languages (zh-HK, zh-CN, zh-TW) in the list at Internet Options > Languages but apparently this didn't matter. Does the IE7 favorites Import/Export Wizard support Unicode, or is there a way to make it support Unicode Thanks! I've just tried this myself, with similar results. It appears as though the Import/Export Wizard outputs the HTM file as an ANSI stream. Unlike a page 'Save As' operation, I don't know of a way to force it t ...Show All

• SQL Server ASYNC_NETWORK_IO issue

  I am running a Stored procedure which select from a table and returns approx 800000 records. When calling from any client machine it takes long time to return the result (90 sec). It waits for ASYNC_NETWORK_IO which is pushing the result to client. If select statement is used with TOP operator to return less number of records it executes faster. When calling from the server the stored proc returns data in 13 sec with all records. In another machine of identical HW and configuration this problem is not there. Can anyone help how to improve ASYNC_NETWORK_IO issue SQL-2005 SP1 64 bit Standard on Active/Passive cluster Windows -2003 Ent. Thanks -Ashis Hi, Ashis, Did you encounter this problem during replication If not, can you p ...Show All

• Visual C# CS1525: Invalid expression term 'char'

  temp+=Replace(temp, char (13),"<br>"); temp+=Replace(temp , (char) (13),"<br>"); ...Show All

• Visual C++ heap block modified past requested size

  Hello, I'm new to C++, although I've been developing in .Net since its inception.  I'm taking a class to try and learn the basics of the language.  I'm working on a project for class where I'm supposed to learn how to dynamically allocate memory based on user input.  The following code is supposed to compare two DNA strings and calculate a numerical value for the discrepancies between the two.  When I run it, I get an exception after the user inputs the second string, if the string length exceeds the array size and more memory has been allocated.  [It tells me that the heap has been modified past the requested size of 8.]  This is strange, because I'd expect to get an exception after the first input as well ...Show All

• Windows Forms Publishing in VS2005 is very slow

  Hi, I have simple Windows form project which I choose to publish. Usually it works fine but for my current project for whatever reason it'll sit for 3-5 minutes showing "publish building" while VS is doing nothing (no high CPU utilization, nothing) and then it'll finally publish. Manually building project is very quick. What can be possibly a reason for this behaviour Hi, I have the same problem. It is even slower when publish a net3.0 WPF application. I've re-install my Visual Studio, and it does not help. What went wrong Any specila requirement for a web server to host ClickOnce app Although it is slow, I can publish .NET 2.0 application, I read in the forum that there are some is ...Show All

• Visual Studio How to determine whether user has .NET 2.0 framework before installing add-in?

  Hi - Is there a way to determine whether a user has .NET 2.0 framework prior to installing an addin, and if not, automatically installing it I had .NET 2.0 framework bundled with my addin - but it seemed to be installing whether or not the user already had it. Any ideas thanks! Hi, If your add-in is for VS 2005, you can assume that .NET Framework 2.0 is already installed. If it is for some Office application, you can check some subkeys of HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework ...Show All

• Visual Studio 2008 (Pre-release) sample source to return stream from service to client

  I've got a service returning IEnumeration<Customers>, and sometimes this set can get larger than the buffer size of 64k. Now, instead of raising the buffer size I'd like to return the data as a stream, but am somehow blind how to achieve this using serialization. My service right now is something like this: IEnumerable < Customers > GetSomeCustomers() { return SomeCustomers(); } My client does call this using a proxy: IEnumerable < Customers > somecust = myProxy.GetSomeCustomers(); Now my Service would need to serialize the data referring to the DataContract of Customers, and return a stream, but I don't know how to serialize and deserialize the return value of my s ...Show All

• Visual Studio 2008 (Pre-release) App Positioning Per different types of Resolution

  Ok right now in my application it starts where i have it set right along the Taskbar,But i run at a Resolution of 1280 x 1024 and not everyone runs the same Resolution..Some people run higher Resolutions or Lower..So my Question is where can i find some information on getting the Application to appear along the Task Bar No Matter the Resolution From 800 x 768 all the way up to 2048 x 1280... well no matter the positioning of the persons taskbar it will Adjust the Elements anyways....already ahead of that area,cause i also know people that move their TaskBar from its Normal Install Location ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. which 3d program

  I'm fairly new to xna and i was Does anybody know a good free 3d image program or where i can get a good program for free! thanks for your support. Wings 3D is my favorite 3D modeling application. It is free and very powerful. Along with that I also use Ultimate Unwrap 3D for my UV mapping needs, it works great also. For animation I use Character FX , which does excellent bone animation. While the later two programs are not free, they are very low cost and provide very strong alternatives to the high cost of things like 3D Studio Max. ...Show All