sheng nan's Q&A profile

• Windows Forms Control crashes when using Windows Classic Theme

  Hi, I have a control that is using a custom tree view, the problem that I am having is that when using the 'Windows Classic Theme' in XP (i.e. visual styles are turned off) I get the following error: Visual Styles-related operation resulted in an error because no visual styles is currently active. ************** Exception Text ************** System.InvalidOperationException: Visual Styles-related operation resulted in an error because no visual style is currently active. at System.Windows.Forms.VisualStyles.VisualStyleRenderer.IsCombinationDefined(String className, Int32 part) at System.Windows.Forms.VisualStyles.VisualStyleRenderer..ctor(String className, Int32 part, Int32 state) at System.Windows.Forms.VisualStyles.VisualStyleRenderer ...Show All

• SQL Server Encryption Varbinary Length

  Using the new encryption included in SQL Server 2005, what is a good way to determine what length I should use for the column   For example, I am encrypting a column, its maxlength is about 30 characters, but when encrypted, the encrypted value extends from between 50 and no more than 68 characters- So if I had a column with a max of 500 or so characters, how could I know what varbinary length I should set it to if I were to encrypt it, without actually finding the highest value I could possibly fit into the field Is it good practice to just make it a varbinary(max) field -rob Raul, thanks for the solution on encrypting large amount of data. We have tried your approach on some BLOBs (e.g. ...Show All

• Software Development for Windows Vista Why do I need to specify a connectionstring for a SqlTrackingQuery?

  Hello, I was wondering why I needed to specify a connectionstring for a SqlTrackingQuery  Because when I created the Tracking Service in the "global.asax" I aready specified a connectionstring. Doesn't the SqlTrackingQuery know where the tracking database is located from the Tracking Service I think that : 1°you don't have to use the tracking service to make a SqlTrackingQuery 2°you can query another tracking database than the database your tracking service is currently running on. Hope this help Serge ...Show All

• SQL Server Access with an SQL Server backend.

  My question is this: "Does anyone know where to set up the connectivity for an access database to store data on an Sql Server " Hey Lamot, Sure thing. Go into access and choose the tables tab. Right click a white space and choose "Link Tables" in the "Files of type" drop down, choose ODBC databases. You may have to create a new DSN which is no problem, choose "New" choose "SQL Server" (normally at the bottom) next, give it a name, next, finish, choose your server, next, choose your authentication method, next, choose database for this connection, next test it if you want (the connection) finally choose finish. You are now presented with a list of tables on the sql server for the con ...Show All

• Visual C++ Event in a grid...

  Hi all, I am for example in a grid in visual C++ e.g A.1 and when I edit this cell and press enter i want to confirm my change and the selected cell to be the next B1..How can I do this I think to write sth like switch........case 0x0D{ } Thank you For general "how to questions" sites like codeguru.com or codeproject.com is a more proper location. OTP Thanks, Ayman Shoukry VC++ Team ...Show All

• Windows Forms How to scale controls to 96 Dpi in 120 Dpi environment

  Hello all, I'm stuck on a really serious issue. I need to scale any type of control (e.g. DataGridView) to 96 Dpi in a 120 DPI Windows environment. How can I do this. It would be even better if there is a way to have my whole application (C#) run in 96 DPI and ignore the 120 DPI Windows setting. Is there a way to do this type of thing Please help me on this one, I'm writing this system for someone who runs the app in a 120 DPI environment. It's a desktop app. I see there's a SetProcessDpiAware function that one can use, but I've seen no practical example of how it is used. Could someone please help Thanks in advance Nathanael I have ...Show All

• Visual Studio Team System From Express to Team

  I just installed Team Suite from Express. Do I need to rebuild the current projects I'm excited, it seems there are more tools/option in the Team version gudel wrote: I just installed Team Suite from Express. Do I need to rebuild the current projects I'm excited, it seems there are more tools/option in the Team version Hello, I have downloaded the 180 day trial TS but couldn't install it. I just couldn't find a way to open *.img file. Could you please tell me how did you manage installing it Thanks, ...Show All

• Visual Studio How to sum dates in reportviewer

  I'm creating a time sheet report in which I would need to sum dates. Does anybody have an idea how to do this I'm giving a dataset to the report which holds all individual records. In the report I created a group based on date. In the group footer I would like to show the total time spent for the group. Did you look into the TimeSpan structure ( http://msdn2.microsoft.com/en-us/library/system.timespan_members.aspx ) Note that die RDL expression language can directly use all functions of the VB runtime library and you can also make calls into custom assemblies. -- Robert ...Show All

• Visual Studio Right mouse click on model results in a HRESULT E_FAIL

  When I click on the right mouse button on a model in the debugger, this results in the following exception. - $exception {"Error HRESULT E_FAIL has been returned from a call to a COM component."} System.Exception {System.Runtime.InteropServices.COMException} The ErrorCode = -2147467259 This occurs since the migration to the June SDK, but only in one of our DSL's. The migration was successfull, except of this behavior. I have tried it on several pc's (with both XP and vista) but that made no difference. I do not have a clue what can be the cause. Hopefully you have! By the way, this is the call stack: [External Code] Microsoft.VisualStudio.Shell.dll!Microsoft.VisualStudio.NativeMethods.ThrowOnFailure(int hr = - ...Show All

• Visual Studio 2008 (Pre-release) Resize Elements inside the canvas

  Canvas contains some UIelements like rectange, ellipse, button etc. I would like to resize child elements, when the canvas is resized. I'm able to resize the Canvas using Adorner. Can someone suggest me the general approach to resize any element that located inside the canvas. for e.g <Canvas><Button>Test Button</Button></Canvas>. In this case Button element should be resized with respect to the canvas. Thanks in advance, Venu try this < Window x:Class = " WindowsApplication2.Window1 " xmlns = " http://schemas.microsoft.com/winfx/2006/xaml/presentation " xmlns:x = " http://schemas.microsoft.com/winfx/2006/xaml " Title ...Show All

• Visual Basic Graph Control in VB.NET

  I would Like to know how use create a graph control in VB.NET. i have to create graphs using the database values Hi Can you please advise me how I can generate graphs in visual studio 2005, VB.net I would like to be able to generate dynamic graphs from data which is populated in the Database. I am not too familiar with creating controls, could you please explain how I can use this Also if I can use Excel, please can you advise what is the best way to go about doing this Your help is most appreciated. Many thanks, Ro ...Show All

• Windows Forms the executable file becomes too large.

  can u give me a reference about how to divide an application into several components.. my application executable becomes too large.. i have divided the application into 4 layers but the presentation layer is 21MB in size because it composes of many forms.. pls help. Even if he split everything up into seperate files, they would all still be fairly large files. If your application is large, thats just it, its large. There isn't anything you can do about it besides try to decrease the size of the resources in your application, because that is what usually makes an application large. Bitmaps, Sound files, or other exe's in your resources will greatly increase the size of your application. And in the long run, your users will still have ...Show All

• Windows Forms binding datatable with image as byte[] to datagridview

  Try to bind datatable with image stored as byte[] to datagridview Way 1: Auto generation of columns of datagridview / /init dataGridView1.AutoGenerateColumns = true; DataTable dt = new DataTable(); Bitmap bmp = new Bitmap("test.bmp"); //convert test image to byte MemoryStream ms = new MemoryStream(); bmp.Save(ms, System.Drawing.Imaging.ImageFormat.Bmp); byte[] buf = ms.ToArray(); //binding dt.Columns.Add("Pic"); dt.Rows.Add(buf); dataGridView1.DataSource = dt; Result of Way 1: DataGridView shows cell with text "System.Byte[]" ################################## Way 2: Manual generation of columns of datagridview //init ...Show All

• SQL Server SSIS Auditing example

  Greetings SSIS friends, Do any of you guys have a link to a website with an example of how to create a solid audit system for SSIS packages Thanks for your suggestions in advance. Hi Rafael, Are you referring to the SQL Server 2005 Data Quality Solutions white paper I already have this and I have also read the section on Auditing but the document is much more high level and I was hoping for a more detailed session on this forum. The white paper mentions creating a schema consisting of perhaps 5 tables (which seem too much for my liking) but perhaps a detailed discussion here might convince me of their usage ...Show All

• SQL Server Problem in Navigating two charts

  Hi all, I have done 2 charts.while clicking one chart it is navigating to another chart. it is working in Report Server. But using this graph in the UI page(putting Iframe and calling reports) it is not navigating to another chart. Can u guys help me to solve the problem Thanks in advance. V.M.Senthil wrote: Hi all, I have done 2 charts.while clicking one chart it is navigating to another chart. it is working in Report Server. But using this graph in the UI page(putting Iframe and calling reports) it is not navigating to another chart. Can u guys help me to solve the problem Thanks in advance. So you are saying that when you use a report viewer in Visual Studio 2005 to view ...Show All