Jeremy Lew's Q&A profile

• SQL Server Two tables, one dataset. Performance?

  If I create a report with one dataset referenced in two tables, will the dataset be queried twice, or once, and copied to both tables (preferred). I am trying to create a report with a summary report and then summarized detail report, both using the same data. ...Show All

• Visual C++ error LNK2019: with ATL::CStringT

  I am getting multiple linking errors, which the one below is representative... error LNK2019: unresolved external symbol "class ATL::CStringT<wchar_t,class StrTraitMFC_DLL<wchar_t,class ATL::ChTraitsCRT<wchar_t> > > The related calls are from within a static library I am building with in a MFC executable. The MFC solution finds the lib just fine and both projects involved are using atl.lib as an additional dependency. Totally stumped, any ideas would be very welcome ;)) Thanks in advance. btw, I'm using VS 2005 or v 8.0 if you prefer... ...Show All

• Visual Studio 2008 (Pre-release) Two Jan 2007 Orcas Editions ?

  Hi Can anyone tell me the difference between Microsoft Pre-release Software Visual Studio Code Name "Orcas" - January Community Technology Preview (CTP) (Installable Bits) and Microsoft Pre-release Software Visual Studio Code Name "Orcas" - January 2007 Community Technology Preview (CTP) Both have different links yet similar files - the latter has one 700MB extra. Thanks It might be a good idea for MS to display that warning on the download page .  I had started the download but when I read this thread I cancelled it.  MS is going to be paying for a lot of bits to get downloaded that just get thrown in the bit-bucket, once people find out this isn't really going to help them with WPF / WCF devel ...Show All

• Visual C# how to get every element of a string?

  For example, string s = "12"; then, how can I get the last element "2" of s For array, we can access each element by the index, however, I do not know how to deal with a string.. Any suggestion Thanks! I find one way, string p = ""; for (int j = 0; j < (i - 1); j++) { p = p + a[j]; } So that I can get rid of the last element of the original string Is there any other method to realize this ...Show All

• Windows Forms Masked DataGridViewEditControl

  Can anyone point me in the right direction (or show a sample) to have a masked edit control as the editing control in a datagridview cell I have a data source that stores an int which represents minutes. I want to display that and have users be able to enter it as 'HH:MM' so it needs to be converted before display, shown in a masked edit control, and converted back to minutes after editing. Thanks, Ken There is a c# example masked edit column in the datagridview faq samples . I placed a vb sample on the vb-tips website . ...Show All

• Microsoft ISV Community Center Forums [Access 2003] [ADO Excel Connection] Run-time error '-2147217865 (80040e37)'

  Error clause when retrieve data from Excel file using ADO, error message as the following: ShtName = "'AA BB CCCCC DD(EEEEEEE$00+) (0)" strSQL = "Select * From [" & ShtName & "$A7:BB65536]" Run-time error '-2147217865 (80040e37)': The Microsoft Jet database engine could not find the object 'AA BB CCCCC DD[EEEEEEE$00+] [0]$A7:BB65536'. Make sure the object exists and that you spell its name and the path name correctly. Thank you very much! Hi Perry, It's your range thats causing the error, if you run with only the sheet name then it's fine but when you add the range A7:BB65536 the error is thrown. Have you tried using a named range instead ...Show All

• Visual C++ I'm unable to add windows message events or new functions/variables with the IDE using the wizard... WHY?

  My project, which has moved forward through the VS IDE's from version 5 now has a problem using the wizards to add new functions variables, or windows events. I "converted" the source files when I first opened the project in version 8 from version 7 and can successfully manually add the functions, message handlers and class members but it would be nice if the IDE worked the way it does with older versions, and with newer projects. Is there some file I need to remove, or is there a setting that needs to be changed (similiar to deleting the old clw file to reset the class wizard). Thanks Chris Chris, I'm not a wizards-user and I'm fearing that the information you're giving isn't going to r ...Show All

• Windows Forms Form Design

  Can a form receive contact data entry, send out emails and prints mail labels all in one interface Please provide samples. Thanks. to send emails: VB.NET http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=616274&SiteID=1 C# http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=760457&SiteID=1 for printing, something trickier so I would suggest searching the forums as well as reading these: http://msdn2.microsoft.com/en-us/library/system.drawing.printing.printdocument(VS.80).aspx http://msdn2.microsoft.com/en-us/library/system.windows.forms.printdialog(VS.80).aspx http://msdn2.microsoft.com/en-us/library/aa467115.aspx ...Show All

• Visual Studio Express Editions void System::Array::Resize(cli::array<Type,dimension> ^%,int)

  How can I return a cli::array's size on a specific dimension and how do i resize multi dimensionnal arrays Thx for the help. Sucks about the the resizing though ...Show All

• Visual C# what database for a small C# app?

  I'm creating a small application that will be used by several people but only on their local computer. I need some sort of database with it, it's going to be used offline and I do not want them to have to install mysql or sql locally. I was thinking of just using MS access, but thought I'd ask if C# works better with something else Thanks in advance for any and all ideas Firebird is also a good alterative to access, i use it alot for embedded databases and they also have a .net connector. Information and downloads can be found here. ...Show All

• SQL Server Computed columns

  Hi, Consider the following example create table sample (col1 int, col2 int , col3 AS col1 + col2) PERSISTED NOT NULL) basically col3 is a computed column. Now when ever a row in col1 or col2 is updated the computed column will reflect the new value. how does this happen in the background. does this use row level triggers or what other mechanism is used to maintain col3 - computed column one good thing in answering in this forum is that you got to learn new things. anyway here's what BOL has to say Unless otherwise specified, computed columns are virtual columns that are not physically stored in the table. Their values are recalculated every time they are referenced in a query. T ...Show All

• Visual Studio Team System Ability to incorporate relational data within TFS fields?

  I would like to add role information to a customised work item. When a user is chosen from a dropdown, I would like the role dropdown to default to the chosen user's role. Currently both users and roles are defined in Global Lists, but I wondered if there was anyway that I could move to a relational model. Can this be done Cool, here is the sample and documentation on custom controls: http://blogs.msdn.com/narend/archive/2006/10/02/How-to-use-Custom-Controls-in-Work-Item-Form.aspx ...Show All

• Smart Device Development Registry limitation ? UnauthorizedAccessException

  Hello! I encounter a problem with deleting a key in registry with CF2. I did not have this error with CF1 and OpennetCF registry class. I try to delete a key in HKCU\Software\Microsoft\Internet Explorer\Main\FavoritesEntries\ The CF2 allow me to create one but it is impossible to delete it after ! Indeed I get an UnauthorizedAccessException exception in mscorlib. Why Is there a workaround help! Thanks in advance! Are you saying that on the same device you can delete a registry key using OpenNETCF SDF, but not with CF2 (and just to clarify - CF1 did not support registry access) ...Show All

• Visual Studio 2008 (Pre-release) How can we change the WS-Addressing headers?

  By default the WSDL generated for a WCF service have WS-Addressing headers using the 2005 namespace. Is there a way we can change it to use the 2004 namespace version Thanks! Hi Raj, Madhu's example actually shows the service side (in code) and the client side (in config). You can also configure the service side in config as well, just create a custom binding as he does in his config example, but reference it from within a <service> element instead of a <client> element. Cheers, JJustice [MSFT] ...Show All

• Software Development for Windows Vista How to Execute a XAML file in Work Flow(WWF) ?

  Hi, I want to execute a XAML file through Work Flow(WWF). I unable to initialize the objects in the XAML file. Can somebody help me out on this. Please use WF as an abbreviation for Windows Workflow Foundation, not WWF . For an example of using XAML activation take a look at this blog. ...Show All