Deicide's Q&A profile

• .NET Development Why the difference between Access Query Configuration and Tableadapter Query Configuration Wizard

  I have found that I can run a query using Access query builder works fine but the same query does not work in the "TableAdapter Query Configuration Wizard". Why is this Example: SELECT * from Rental_Agreement WHERE DateSerial(year(end_date), month(end_date) , day(end_date) - 5) = Date() This works in Acess 2003 but not in the "TableAdapter Query Configuration Wizard". Hi Paul, Thats good to hear. I'm going to have to recreate it tonight.   RegardsDid you access an access datatable ...Show All

• Visual Studio Express Editions Precompiled headers

  I can't seem to figure out how these things work. I've RTFM, but it's as clear as mud. I had a project that I initially set up not to use pch. I decided to use one, so I created a new project with pch and tried to use the same options it did, among them, "Use precompiled headers (/Yu)". That didn't work. I changed it to "Create precompiled headers (\Yc)". That seems to work, but I'm not sure if it's rebuilding the pch every time. Seems to me there should be a build rule with the proj.pch file depending on the stdafx.h file in the project. It doesn't seem right that I should have to remember to change that Y flag when I change stdafx.h, and then change it back. So, Is it possible to set a project up so it will use preco ...Show All

• Windows Forms Best method to Validate windows form field data bound to a dataset datatable?

  I've built a form using the drag and drop method from a dataset. Great, so now I have a form that I can add, edit, and delete details but how do I create field validation to a) Prevent the errors generated from the datatable constraints (No Nulls) b) Put in my own validation like making sure if one tick box is ticked that certain fields are completed I want to validate fields before the user moves to another record (new or existing) or when a user clicks on the save button to save the datatable changes. Ideally validation would only occur if the row of data has changes or is a new row. Any help on this would be appreciated. Well, you always want to validate at the db level b/c it's the final f ...Show All

• .NET Development Installed 3.0: Now what?

  I believe I have successfully installed the 3.0 Framework, but I see little evidence of it on my system. Shouldn't there be something Is there a readme that says what I actually installed I found a readme on the web, but it is about trouble shooting issues. I want to know what I can do with what I installed. I don't see any new references in VS.NET. I don't see any new Control Panel or Administrative Tools items. I do see C:\WINDOWS\Microsoft.NET\Framework\v3.0 with some MSI files in it. Do I need to run each one There is a WPF.msi. Do I have to run it to create WPF apps Am I ready to run WPF apps The 3.0 Framework like the previous ones is pretty quiet when installed as it should really only be used when ...Show All

• Visual Basic very strange dependency problem with DLL's VB.NET

  This is a very weird issue I just recently had happen and am totally stumped by it after a day of trying everything I can think of to fix it. Here is the scenerio I have one master function library dll written in VB.NET 2.0 framework. It references adodb primary interop assebly (originally it was vb6 dll that has been fixed over time and expanded for my purposes, and thus has a dependency on adodb still being used for data access). This DLL is used in almost every project I have written in the past 2 years in .NET and has worked wonderfully. It has no other important references other than system.data, system.configuration, etc... I have one large solution that contains 5 projects not including the function library above. 1 EXE Fro ...Show All

• .NET Development Imports cell from DataTable

  I have a DataTable with many Columns i want to imports Data From one Column and add it to a variable How do i do it in VB you have 2 ways direct convert try to convert - better option Dim theResult as Integer If Integer.TryParse(theColumn.ToString(), theResult) then 'successfully converted "theColumn" object to an Integer and result is saved in "theResult" end if ...Show All

• Visual Studio 2008 (Pre-release) GZipEncoder and Serialization

  Hi, I wrote a Service that returns an array of objects using netTcpBinding. The size of the data I have passed is 13MB. It takes about 24 seconds , the most expensive time is the Serialization and deserialization. In order to see how compression improve performance I change the contract to return instead of an array of objects an array of bytes with the same data but compressed and I do the decompression on the client side.I was surprised since all the round trip include compression and decompression tooks about 2 seconds. Ok.Then I thought that don't want that the operations in my contracts will return an array of bytes so I saw that the GZipencoder can help and I can return array of my objects. I change my configuration to use t ...Show All

• Windows Forms minimize validation of data

  I have a DataGridView containing some complex data. I need to validate that the data on each row is valid every time a user updates data on that row (and not after just updating a single cell in the row). However, the validation-process is quite expensive so I only want to validate data if the user actually updated some data on that row (and omit validation if the user just "travels" between rows). If the data is invalid, I would like to cancel the update. My problem is that the when the rowvalidating event is fired, the rowstate is not updated to Modified, so I have no way of telling that the user has updated data in the row (without checking explicitly on each cell of the row). And when the rowvalidated event is fired, it is no ...Show All

• Windows Forms dateTimePicker question

  is it possible to prevent changing the date in the DateTimePicker and allow the user to change the time only DTP doesn't offer any options or Windows messages to prevent editing the date part. You can't even control the focus. Frank's suggestion is the best you got. ...Show All

• SQL Server passing XML as stored proc parameter to a linked server

  Hello! I was just wondering if there are any "best practice" solutions to enable an XML document to be passed as an XML parameter to a stored proc on a linked server. It seems like this isn't supported. As a quick workaround, I am currently just converting the XML to varchar(max) before the remote call to the stored proc and converting it back to XML on the linked server. Cheers and thanks for any suggestions! Drew Passing XML via linked servers is currently not supported. Casting it to varbinary(max) or nvarchar(max) is the recommended workaround (or use pass-through queries). Note that you should use CONVERT option 1 when casting from the max-type in order to preserve all the whitespaces... ...Show All

• Smart Device Development Update with a Guid ID

  customerID =Guid.Equals(lvCustomers.FocusedItem.Text); I wan to make a updatate statment using a Guid.Updating with a int works great but not when the data is a Guid. Any suggestyions Have a nice day. Guid.Equals isn't a static function, is it It's an instance method I thought ...   either way, you likely need to cast the text value as a Guid before comparing in order to achieve reliable results.   you're setting your customerID equal to the bool result of the Equals method ...   maybe you want:   bool idsMatch = customerID.Equals((Guid)lvCustomers.FocusedItem.Text); ...Show All

• Visual Studio Express Editions Using progress bars, downloading files, and console applications?

  Hey all, I've just started programming with Visual Basic and I just can't get these three things done. I've been searching for about half an hour now but still haven't found anything. Everything seems so extremely large for a beginner like me. Question 1: How can I make a progress bar react depending on how much a website is finished loading Once I get that working, how can I make it so whatever I download on my little internet browser have a progress bar or a percentage too Question 2 (yeah I know it's actuall question 3): How can I download files with a customly created browser Question 3: How can I display text in a console application I don't know any commands in it, and I just want to display some text without closing the console, a ...Show All

• Smart Device Development Losing Databinding with ResultSetViews

  I am programming in C# for the .net compact framework 2.0. I am binding controls on the screen to my SqlCe database using ResultSetViews. Everything works fine, as long as there are rows in the table when I create a ResultSet. If I create a ResultSet when there are no rows in the table, and then later add rows to the table, and after that set up the databindings, the bindings won't work (Controls who's Text property is bound display no text at all). Do I need to do something to update the resultSetViews This is (sort of) how I am doing it: cmndDB = new SqlCeCommand("SELECT * FROM MyTable", dbConn); SqlCeResultSet rs = cmndDB.ExecuteResultSet(); ResultSetView rv = rs.ResultSetView; ... cmndDB.CommandText = ...Show All

• Visual C++ Edit and continue in VS2005

  Hi, I just recently started to use VS2005. I am trying to use the edit and continue function, but for some reason it desn't work. I have it enabled in the project options (check mark). when I change the code during debug I get this message: "This source file has changed. It no longer matches the version of the file used to build the application being debugged." Then I have no coise but to click "OK" and forget about the change I just made What could be wrong Thanks! Thanks james and all, It was the project specific settings. I had some weird behaviour though: I created a function that does nothing but return true. Then, I set a breakpoint on the return tru ...Show All

• Visual Studio 2008 (Pre-release) Bug Report: Window transparency cause the Frame invisible (June CTP)

  In June CTP, I create a transparent window by setting its AllowsTransparency, WindowStyle and Background. Then I place a Frame element on the window. As I load a webpage, say Http://www.microsoft.com , into the frame, I only get a blank Frame but I can find the hyperlinks on the page when I move mouse over the frame. Bug Or I can't use it in that way BTW, I do the demo in EID. Thanks Leo, When you navigate a Frame to HTML content, it uses HwndHost under the covers to render the content. HwndHost is not compatible with layered windows. Nick Kramer has blogged about this ( http://blogs.msdn.com/nickkramer/archive/2005/12/14/503644.aspx ). Thanks, Lauren [MS] ...Show All