Yuhang's Q&A profile

• .NET Development .Net application Eating Memory & releases when minimized

  Dear all, I have developed an application based on C#, The problem is "Garbage Collector being not called" from the application, i have not used any unmanaged code. The application is a Multithreaded application and the Memory Usages figure in Task Manager comes to minimum when i minimizes the application. Example: Task manager's Mem Usage is showing 328 MB and on minimizing the application it shows 45 MB. thanks in advance... aniruddh you can try forced garbage collection but that also doesn't give you 100% assurance. http://DotNetWithMe.blogspot.com vikas goyal ...Show All

• Visual Studio Express Editions DataGridView Manipulating data

  Hi I want to use a DataGridView as a report for a system I'm designing, I don't want to bind it to a database and I don't have the know how yet to figure out how too... although it would help me out soo much! basically all I want to do for now is be able to change the header of the table (which at the moment only seem to be changable in design time) and then to add data to how ever many cells are required. thanks Ah thanks man!! I'd like to ask you something else not sure if I should start a new thread or not though.. I want to create a database without having to implement an SQLserver enviroment is this possible can I still have a single DB that follows my app around and then how do I bind it to ...Show All

• SQL Server Change case sensitive database to case-insensitive

  I recently downloaded and attached the AdventureWorks sample database and it's using a case-sensitive collation (Latin1_General_CS_AS). I thought I could change it like this: USE master GO ALTER DATABASE AdventureWorks COLLATE SQL_Latin1_General_CP1_CI_AS GO but it doesn't let me (several messages that objects are dependent on database collation and one at the end telling me it can't be set to SQL_Latin1_General_CP1_CI_AS ). Is there an easy way (or any way) to do this Thanks, Dave BOL states: No schema bound object is dependent on the collation of the database. If the following objects, which are dependent on the database collation, exist in the database, the ALTER DA ...Show All

• SQL Server why not showing nulls?

  Hi, I have the following query: SELECT COUNT(dbo.UkPostcodes.Postcode) AS PCCount, dbo.UkPostcodes.Postcode, dbo.UkPostcodes.Town, dbo.UkPostcodes.County, dbo.UkPostcodes.Area, dbo.UkPostcodes.Country FROM dbo.UkPostcodes LEFT OUTER JOIN dbo.Customers_Trade ON dbo.UkPostcodes.Postcode = CASE LEN(REPLACE(dbo.Customers_Trade.PostCode, ' ', '')) WHEN 5 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 2) WHEN 6 THEN LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 3) ELSE LEFT(REPLACE(dbo.Customers_Trade.PostCode, ' ', ''), 4) END GROUP BY dbo.UkPostcodes.Postcode, dbo.UkPostcodes.Town, dbo.UkPostcodes.County, dbo.UkPostcodes.Area, dbo.UkPostcodes.Country The query ...Show All

• SQL Server Bulk insert and splitting content into collumns

  Hi, when i try to load XML file into a table with bulk insert, i get bunch of errors: Msg 4864, Level 16, State 1, Line 2 Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (cislo_subjektu). My guess it is, that it has something to do with 11 different collumns defined in dbo table and this command's lack of some specification about where to put which value. BULK INSERT pokus.dbo.organiz FROM 'D:\organizace.xml' /* my file */ WITH (FORMATFILE = 'D:\organiz-x-c.xml'); /* formatfile*/ GO Is there a way to split content of loaded file into correct collumn in dbo table Hi, thanks for input. Do you know, what this error means Bulk load da ...Show All

• .NET Development Error: ExecuteReader requires and open and available Connection. The connection's current status is open, Fetching.

  Hello, I am having a problem with selecting rows from an Access database (for code, I am using c# 2003). I have a list that I will go through one by one. As I increment through the list, I want to make a select statement to retrieve rows that meet my set criteria. Currrently, I am just outputting the selected column to the screen. However, I get the following error message: ExecuteReader requires and open and available Connection. The connection's current status is open, Fetching. What am I doing wrong int i = 0; try { string strOleDb; strOleDb = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + myPath; OleDbConnection cn = new OleDbConnection(strOleDb); OleDbCommand myCom = new OleDb ...Show All

• SQL Server How to display reports in one page

  Hi All, Is there any way to display reports in one page My reports has 3 pages by default. Thanks. If you are using table or a list, set KeepTogether property to true so that some data will be shrunk and moved to pages above. Shyam ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Capturing left & right channels seperately

  Hi I am a newbie to this DirectX world I am using latest DirectX SDK with Visual Studio 2005 and using C# as programming language I have checked the samples and they are working perfectly I have an custom made external sound card (connected with USB) that has 2 inputs, 1 for left channel and 1 for right channel, DirectX SDK's Capture example is working perfectly with it capturing the sounds of both inputs and saving them in a wav file, now I want to save left and right channels' sounds in seperate files I think it must be pretty simple but I have no clue about it Thanks in advance ...Show All

• Visual Studio Local reports without session. (sessionless) Is this possible?

  Is it possible to run reportview control without session If its not possible... does anyone have suggestion on other ways to implement session other than using the standard .net session. The app is running in web farm so using the default session is a no go. In the webconfig when I use < sessionState mode = " Off " here is the error I'm running in to: + Error {"Session state has been disabled for ASP.NET. The Report Viewer control requires that session state be enabled in local mode."} System.Exception {Microsoft.Reporting.WebForms.SessionDisabledException} When the sessionstate mode is not set (set to default value) the reports run fine when testing on a single machine. (prob won't wor ...Show All

• Microsoft ISV Community Center Forums is it possible to get windows Services with VBA ?

  Hello, I want to create a macro wich is able to get a services like Services.msc is doing (by network) , is it possible thanks ...Show All

• Windows Forms Testing Multiple Instances of Winform application

  Hi, Wanted to know what are the testing tools available to test the multiple instances of a win form application. Here is what i need to do: I have a win form application which uses some external toolkit. the toolkit has limitations in terms of the instances creation. I wish to automate the stress testing of the win form application using some tool so that i can find out the threshold limit of the external toolkit.. Basically i want to do a load generation on the win form app by spawning multiple instances of the application with the necessary user clicks scripted in. Are there any tools that come along with the VS 2005 which can help me or i have to resort to LoadRunner or any other tool. Any pointers would be appreciated. Thanks Paritos ...Show All

• Visual Studio 2008 (Pre-release) How can i find window handle in dotnet3?

  Like the topic said Me.handle in dotnet2 doesn't seem to be there please how... Thanks!!! Assume the Window1 is a class derived from Window, then you can get the hwnd for Window1 using the following code: Window1 wnd1 = new Window1(); System.IntPtr hwnd= (new WinInterop.WindowInteropHelper(wnd1)).Handle; Sheva ...Show All

• SQL Server VS2005 Designer runs report once, on subsequent run, VS hangs

  VS2005 Designer runs report once, on subsequent run, VS hangs. Is there a way (other than shutting down VS) to reset database connections I'd like to rule out the connection as the source of my problems. You can access the database server the queries are running against and kill the processes from there. This is not guaranteed to Visual Studio back to life though. I've lost quite a few hours of development effort through VS locking up. One tip save often and definately before going to the preview. When accessing the preview tab, Visual Studio runs the report and caches the data on the file system in a file called <report_name>.rdl.data in the same location as the RDL file. There could be some file locking issues your encoun ...Show All

• .NET Development Get WRONG primary key when i use DbDataAdapter.FillSchema or DbDataReader.GetSchemaTable

  Hi All: I have one table at below: Table Name=T_APP Columns: APP_ID IDENTITY(1,1) NOT NULL, NAME nvarchar, LOWERED_APP_NAME nvarchar The table has one pk : CONSTRAINT [C_IC_APP_PK] PRIMARY KEY NONCLUSTERED ( [APP_ID] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY], it also has one uk: CONSTRAINT [C_IC_APP_UK1] UNIQUE CLUSTERED ( [LOWERED_APP_NAME] ASC )WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY] But when i use DbDataAdapter.FillSchema or DbDataReader.GetSchemaTable, they return LOWERED_APP_NAME as primary key to me NOT APP_ID. But when i try to make C_IC_APP_UK1 to non-Unique, others still remain, the two methods return me correct column. Is it a bug After all, ...Show All

• .NET Development XPathReader Anomolies

  I have been using the .net XPathReader MS announced: http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnexxml/html/xml05192004.asp According to the documentation of "serial XPath," the legal subset grammar of XPath  (which the above link references), I should be allowed to use the "text()" function in my XPath expressions.   But I'm trying it, with Rev 1.1 of the XPathReader (the latest), and its not working.  Anyone run into this   The XML doc I'm reading is really just a fragment, which is precisely this: < LocalizedProperties >< Language > en </ Language >< Title > Message Maker </ Title >< Description > Message Maker Gold </ Description > ...Show All