MSDev23's Q&A profile

• Visual Basic VB.Net IDE Crashes Often...

  I am having a problem where my VB.Net IDE crashes often throughout the day... I have a Client/Server application that I am developing, shared between the two is a ClassLibrary I developed. So my Client and Server project both have this ClassLibrary as a Project added to the main Solutions. This way if I am in either the Client or the Server code, I can immediately get access to the ClassLibrary code to make changes if needed. Now, my problem is that several times a day, when I attempt to open a form in Design view, I get a white screen with a pink bar on the top that says: One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may ...Show All

• Visual C# SqlParametersCollection only accepts non null paremater types

  Trying to pass parameters to an Sql Stored Procedure I got this error (the first parameter: Table name): SqlParametersCollection only accepts non null parameter type objects, not String objects. I do not understand it. I do have string parameters and I have null parameters, some of them may well be null. What am I going to do about it Thanks. tried giving the SqlCommand connection property the SqlConnection theSQLCommand.Connection = theSQLConnection; actually it should have thrown an error before that, when you try to open the connection if there was no connection to be initialized...can you show us the code for that ...Show All

• SQL Server Oracle 9i -> SQL Server 2005: Schema_option parameter when adding an article to a publication

  First of all; My Oracle publication works fine when I don't explicit specify the shema_option parameter for the articles I'm adding to the publication. The reason why I then want to explicit specify the parameter is as following. I'm developing a replication solution to get data from our production server (Oracle) to our Data Warehouse (SQL Server). The SQL Server (and the Data Warehouse code) uses the SQL_Latin1_General_CP1_CI_AS collation. When I don't explicit specify the schema_option, the nvarchar columns of the replicated tables are created using the SQL_Latin1_General_CP1_CS_AS collation and this results in some comparison errors, when for instance a select statement is trying to compare two nvarchar strings using different colla ...Show All

• Visual C# creating a sprite from a file picture

  I have spent over 4 hours trying to figure out how to create a sprite from a picture. I have a programming background of turing I know a little bit of visual basic. I can't understand how to load a picture. Any help is appreciated. Image image = Image.FromFile(string fileName); fileName is just the name, not location if you have the picture file added under bin\Debug (in Solution Explorer, Show All Files). fileName is location if you have the file in another directory. ...Show All

• .NET Development Connection Timeout

  I have a problem with Connection Pool running out of connections. I have a site which can get upwords of 1000 conncurrent hits at once. We never had problems with the connections when using classic ASP. But now we are running into the issue with timing out before getting an available connection. We are closing all of the connections. We have bumped up the max pool size to 700 but i don't feel this is really the right solution. Should we not use ADO.NET and go back to using ODBC as stated before we don't have this problem with our classic ASP which uses ODBC connections. Thanks for any help! Here is a sample method that I am using. I do call close not Dispose. On the front end once the page is ...Show All

• .NET Development When to use elements versus attributes

  Hi , A very intense debate is going on in my project for a schema design where the main issue is how to make a wise choice between nested elements vs. attributes especially from a performance perspective. I did some googling and found an interesting article on the IBM site ( http://www-128.ibm.com/developerworks/xml/library/x-eleatt.html ) but I could not find anything on MSDN . We would be using System.XML classes within the .NET framework 2.0 to process the XML's . I think that ideally attributes should be faster to process as the processor would find them in the same line rather than traversing through nodes but I may be wrong. Any pointers would be greately appreciated. Thanks, Sumeet There are cases when attribut ...Show All

• Microsoft ISV Community Center Forums Help to create a new table using VBA codes

  Hello All, How to copy a structure of an existing table to a new table and also i need to change a particular field in that table to Primary key. (in MS Access) i can create it using gui but i need it in code. Please help me for this code. Thanx in Advance Madhan Hi Madhan, You have a couple of approaches. Look at the TableDef object, which is part of DAO, this lets you alter the definition of a table. The other option is to use ADO and that involves adding a referenc to Microsoft ADO Ext. 2.7 for DLL and Security objects. In here there is a collection of objects that let you modify table and database structure for example the Table and Key objects. I don't have any specific code for you but the help files and some edu ...Show All

• Visual Studio Tools for Office Document path in Word 2007

  I am using the new customization tools to create a new ribbon-tab in Word 2007. I try to execute code every time an existing document is opened in Word, and Word is already open. More specifically, I want my customized ribbon-tab to be invisible if the opened document is stored in C:\temp\documents\blabla. In order to do that, I must be able to execute code when the document is opened in order to access the file-path of the document. The methods Connect, OnConnection, OnStartupComplete fires when the Word-application is opened for the first time, and are not useful because I need my code to be executed every time a document is opened. Where can I place my code in order to access the file-path ...Show All

• Visual Studio Team System How To Generate Sales Data

  I want to generate sales data where different product will have different price in diferrent date. Let say I have a Product table to store the MinPrice and MaxPrice of each product. How do I generate the data so that the price is in the range of MinPrice and MaxPrice for each product Thanks. Jimmy Jimmy, If I understand you correctly, you wish to generate price data for a table and the min/max of the price is dependent upon data from another table. So, the min/max of the price data will change from row to row. Is this correct ...Show All

• Visual C# forms threading asynchronus delegates

  Heys guys&gals I am working on front end(GUI) in .NET 1.1. I need to create a loading form when a delegate is fetching data from the database object. After the objects gets the data a new form is created and that data is sent as parameters (in form of dataset). The new form then manipulates the data and show result to user in that new form.  Could someone please tell me how to implement asynchronous callbacks in this case... and create a threaded loading form which will not freeze when the main form is fetching the data...   Please help ...Show All

• .NET Development Remoting timeout issues

  Are there any known workarounds for the really annoying lengthy remoting timeouts on down servers This is particularly a problem when using .Net remoting and the server isn't available, it can take up to 2-3 minutes for the line of code to timeout when accessing a remote object. I have tried implementing a Ping class before I access the object, but sometimes this just doesn't work if the server is in the process of shutting down... Obviously having an application hang for that long is unacceptable.. I am threading everything however my application will not cleanly close if the thread is hung waiting for a socket timeout. A sample for you.. can you set both timeout and connectionTimeout properties and let us know the resu ...Show All

• Visual Studio Express Editions Unable to create New project

  When ever I try to create new project I get this error, I have reinstalled the application and am not able to uninstall it as i get this error "Setup is unable to determine a valid ordering of the installation". Main error while creating project: C:\Documents and Settings\User Name\Local Settings\Temp\bana1g0h.voq\Temp\WindowsApplication1.csproj(67,10): The imported project "C:\Microsoft.CSharp.targets" was not found. Confirm that the the path in the <Import> declaration is correct, and that the file exist on disk. ...Show All

• Visual C# How do I programmatically shutdown the computer?

  How do I programmatically shutdown the computer after waiting for 3 seconds and use a timer to countdown Thank u guys for all ur help but how do I make a label's text change according to how many seconds r left in the timer For instance I have a timer and a label, I want the timer to countdown for 3 seconds and the label to countdown like 3, 2, 1 and then the shutdown method activated. ...Show All

• Visual C++ Arrays of strings

  Hi, need to write a simple C program (using Visual Studio 6)that will store multiple strings in an array. And also print them out using the scanf() and printf() functions Here is what i would roughly like it to look like: void main(void) { char array[1] [20]; scanf("%c", &array[0]); //I have a feeling that this line is wrong printf("\n%c", array[0]); //And this line } Thanks daniboy120 wrote: Hi, need to write a simple C program (using Visual Studio 6)that will store multiple strings in an array. And also print them out using the scanf() and printf() functions Here is what i would roughly like it to look like: void main(void) { char array[1] [20]; scanf("%c", &array[0]); ...Show All

• SQL Server Stored Procedure Update parameters question

  I just posted a question on WHERE clause impotence in SELECT command, I mean in my setting. It obviously should work on a global scale and now I have a problem with UPDATE command WHERE clause. I am talking about a different SP now. It is supposed to update a record in a table. Anyhow, the procedure did NOT seem to execute properly (did not update the record) when called from C# code but when I tried to exec it in the server it finally did work but raised a problem of safeguarding the unused parameters . I do not need to update all columns in every call to the SP that uses UPDATE statement. Some parameters are left the way they are. I found out that if I ignore them they are set to default values which is NULL for DateTime. It ess ...Show All