DC3Dreamer's Q&A profile

• SQL Server Updating a record from table with data from a column of another record from the same table

  Hey guys, I have a table say as follows id, id2, field1, field2, date1, date2 I want to update the date1 field to the date2 field of the very next record with the same id2. In short I want to update a record id(x) by putting in the date2 field if id(y) in the date1 of id(x) where id2(x) = id2(y) and id(y) > id(x) (as id is a sequence). I have written a query as below: update t_remarks te set out_date = (select TOP 1 date_remark_entered fro ...Show All

• .NET Development Datagrid textbox resizing

  Hi there, My datagrid has Edit,Update&Cancel column, and other columns from my dataset. When i click the edit link the textboxes are just too wide, how do i set the sizes such that they fit the screen. I have tried converting them into template column, editing each template and then resizing the textboxes but when i click on Update i get an InvaildCastException error: "Specified cast is not valid" Please help... ...Show All

• Visual Basic Opening forms in a tab

  I have an mdi form with a few smaller forms that open within it. I recently decided that I do not want to do this. Is there a way to open the forms I have already created in a tab Say I have Form2.vb as a child form of Form1.vb. Right now, I have it set as I click a button and Form2 opens in a child window. Instead, I want to create a new tab on my tabcontrol and open it there (no new child window). I don't want to write out all the code that ...Show All

• Visual C# Change size of MainForm (with nice effect...)

  Hi there, I'm sorry for the bad description in the subject line, but how am I gonna explane this... I want to change the the size of the MainForm. But I don't want it do be changed just like that... with a click and "boom" it's bigger. I want a effect. Just like those powerpoint-effects. You know what I mean Not as many, though. Just, that makes the size changing slower. Something like: for (i=0; i < 760; i++) {    this.size += ...Show All

• Visual C++ vc++8.0 bug: access violation upon call of any CImageList methods

  I have sucessfully imported and compiled a complex MFC 6.0 project from vc++6.0  into vc++ 8.0 (MFC 8.0). It contains several subprojects (libs and dlls). In vc++ 6.0 those project linked MFC6.0 statically and after I imported it to vc++ 8.0 I set the linkage of MFC8.0 to "shared". However when I try to compile and link the project in vc++ 8.0 in release mode (debugmode works fine) I get an acess violation in afxcomctl32.inl. This happnes w ...Show All

• Visual Basic Breakpoints in Visual Basic.Net Code

  Hi There, The Breakpoints that I set in my Visual Basic.Net application doesn't function(It doesn't break the running). It's as if I have not set any Breakpoints at all!!! Any help will be appreciated. Instead of running the code, try stepping into the code and see whats happening....breakpoints will not break if they are not reached. ...Show All

• Windows Forms Confessing Event Handling failiure

  After reading a bunch of articles and book chapters on event handling in VB.NET and looking at other people`s code, I have to confess: I dont get it... I find it confusing and very hard to get the full picture. I`m able to write (or s ...Show All

• Windows Forms sort datagrid column like windows explorer.

  Hi All, I want to sort datagrid like windows explorer. In windows explorer they sort folders and files separately. I want to add that functionality to datagrid. is it possible to add that functionality to datagrid Thanks Mogli use a DataView in you DataGridView, you'll be able to specify multiple sorts like DataView.Sort ="Type ASC, Folders ASC, Files, ASC" whereas Type will be folde ...Show All

• Visual C++ Inheriting build settings

  Hello, This is VS2005. I'd like to centralize certain build settings, to be inherited by a long list of projects. That's easy in general using .vsprops. But what if I want to inherit per-configuration settings, e.g. debug vs. release Vsprops files don't appear to deal with configurations, so I'd need to do something like this: my-settings-debug.vsprops debug configuration settings my-settings-release.vsprops release configuration settings ...Show All

• SQL Server How to encorporate Date and Time comparison to pull a field

  I'm trying to pull this data in my first inner join trying to pull the rmsbalance based on the latest date/time combination but not having any luck with my syntax because sql is throwing errors due to my syntax below and I can't figure how how to do the check on the date and time combo:   SELECT   rf . RMSTRANCDE ,             rm . rmsacctnum ,     ...Show All

• Visual Studio Express Editions why can't I exist the application?

  hi, I have a listbox and a few textboxes that have databinding with an ACCESS db, when an item is selected in the listbox, the texboxes will show the details of the corresponding record (certain texbox shows data for a certain column). when I run the application, click on "close" at the begining, it works, i.e. the application exits. However, if i try to exit the application after a few clicks inside the listbox, it stops working, the applica ...Show All

• Microsoft ISV Community Center Forums Problem with integer function

  I have been trying to troubleshoot the following code, but cannot figure out what is causing "Type Mismatch" error. Sub PutData() '\ called by other subroutines         If Me.CheckTech.Value Then Range("TechAppDB").Cells(iRowNumber, iColNumber + 1) = Int(Me.TextD) Else Range("TechAppDB").Cells(iRowNumber, iColNumber + 1) = 0 End Sub When I take out the integer function a number is written as text.  ...Show All

• Visual Studio Installation Requirements

  I have built an app that references Microsoft.ReportViewer.Winforms to use an instantiation of LocalReport.  What is necessary in order to migrate my app to another machine that doesn't have VS 2005 installed   I have already installed the .NET Framework 2.0.  Is there anything I have to do with that ReportViewer assembly since it isn't one of the standard System assemblies Thanks. Thank you both for the responses. Although ...Show All

• Architecture Who needs Architecture?

  http://msmvps.com/blogs/rohanthomas/archive/2006/01/26/81848.aspx Would love to hear your comments... Thanks Rohan Thomas wrote: if they still prefer to go with their taste, the recipe is as good as useless, although it would have saved them a lot of trouble if they would have used the recipe instead... On my projects if they don't get approval to go with their taste, before they dump in the extra ingredients, th ...Show All

• Visual C++ XML in unmanaged C++

  I need to use the XPathNavigator.  What is the include file for the XML in unmanaged C++   You can use MSXML in unmanaged code. http://msdn.microsoft.com/xml/default.aspx ...Show All