SKCM's Q&A profile

• SQL Server Trouble With Inserting Record into SQL Server 2005 Express via Visual Studio

  I'm hoping someone can help me with inserting records into the DB (SQL Server 2005 Express Edition) for my app.  Below is the code that I used to establish an OK button to insert records into the database.  When the user click on the OK button, a message box opens confirming the user wants to save the changes.  When the user clicks on the "Yes" button in the message box, the record is supposed to save to the database.  T ...Show All

• Visual C++ Bitmap -> blob

  I have an object of type Bitmap that I'd like to save in an SQL server (type blob), and then retrieve it. I can find a few examples of how to do this using MFC, but I'm not using MFC. :) I can't find anything in the documentation about this. Dear Jimenez, Your Answer was youseful for me also. And I am also new to GDI+. So Please let me know how to get back the original Bitmap from the LPBYTE (raw ...Show All

• Windows Forms Display recordset in more than one row

  Hello, I miss the container control from access in .NET. In an existing access application their is a detail area that displays data from a database in two rows. For example 1. Row: Name Given name Date of birth 2. Row Street City Number ----------- 1. Row: Name Given name Date of birth 2. Row Street City Number ----------- 1. Row: Name Given name Date of birth 2. Row Street City Number ----------- and so one. Is it possible to display o ...Show All

• Visual Studio Which Crystal Version on Studio 2005 final?

  OK... So after just spending most the morning trying to get Crystal XI working with Visual Studio 2005 RC1, I read on here that I shouldn't do that. I started developing a new project using Studio 2005. I'm writing it in managed c++, so even though it's still pre-release, I want to use it to take advantage of the new language syntax changes without having to convert later on. We have some licenses of Crystal XI so I want to integrate that inste ...Show All

• Visual Basic vb6 convertion

  I am porting a project from vb6 to vb.net 2005 and I cannot figure out one convertion. 'This Function gets the text of the window Private Function GetText(Get_hWnd As Long) As String Dim lenTxt As Long, retText As String lenTxt = GetWindowTextLength(Get_hWnd) + 1 retText = String$ (lenTxt, " ") GetWindowText Get_hWnd, retText, lenTxt GetText = retText End Function The bold function is what I cannot figure out. I kn ...Show All

• SQL Server ReportViewer in VS2005.

  Hello, I am having too many problems with this, can anyone give me example how to pass parameter to ReportViewer and set export form to PDF in VS2005. Thanks. Jim In VS 2005, when you click on your report ONLY if you see Data, Layout,Preview tabs then here is what you do click on 'Generic Query Designer button' on the panel in Data tab and type your sql statement here. for eg: SELECT empid,name,gender FROM guest.e ...Show All

• Visual C++ using ATL macro to change LPSTR to LPCWSTR

  Hello, I'm making a 3D game and realized I would have to face many problems and maybe trying to "reinvent the wheel" on my own, if I wanted to implement SETTINGS -(for graphics mode) in my game. So I am going for DXUT framework or engine by Dx team or what it is called to simplify my life. But I am facing some problems, because it is using UNICODE and I need to change LPSTR to LPCWSTR so I use macro A2W(lpstr) and inc ...Show All

• Visual C++ (Newbie) - getline - Import/Export file

  OK There I go i'm having a Hell to understand how Import/Export file work in C++ i need to save stuff in a external file and get them later when i re-run the program. To be more specific, i would like to save ''accounts'' without using Databases. only to master Import/Export.  I just don't know how to procede I tried something with getline() but every time I enter the information shown on msdn, I get an error saying it was expec ...Show All

• Visual C# how can i disallow spaces or any or even numbers in text box?

  Hi evry1, i have a question that how can i disallow spaces in the textbox or any character that i dont want the user to textit , thx (thats my 1st time here ^_^) Handle the KeyPressed event and if the key passed in through the event args is not one you want, then sent e.Handled = true; Be careful tho, if char.IsControl returns true, you want to leave e.Handled, otherrwise the arrows, etc will not work. ...Show All

• Visual Studio Team System Upgrade from B3R to RTM: Possible database upgrade issue.

  After we upgraded from B3R to RTM, all Microsoft created Work Items, Queries and Reports work perfectly, and all our Work Item customizations work perfectly, as well. B3R was our initial installation version. That said, we ran into an issue with some of Conchango's SCRUM for TeamSystem reports that utilize the Work Item History field. It seems that the TfsWarehouse>Work Item History>Date field was not upgraded from type int to type d ...Show All

• Windows Forms Customizing Comment Web Pages

  Anyone have any idea and/or samples of new layouts for the comment web pages  I'm releasing a control for sale, and I want to improve them a little (like implementing cross-references and some of the other things that the current pages don't do ...Show All

• Visual Studio 2008 (Pre-release) SQL Translation

  When I use the following statement: var q =    from       o in db . Orders    where       o . CustomerID == "ALFKI"       &&       o . OrderDate < new DateTime (1998, 5, 1)    select       o ;   D ...Show All

• Visual Studio VSS Problem

  I have installed VSS 6 in my system . But its not coming in VB IDE I have DOTNET . Its working properly with VSS Sanal, What version of Visual Basic are trying to get to work with Visual Source Safe What version of Visual Studio and Visual SourceSafe do you have -Brad ...Show All

• Software Development for Windows Vista Security error hosting the WWF designer in a WinForm UserControl hosted in an ASP.NET page

  We've taken Lab 12 Exercise 1 and applied the same steps to create a WinForm UserControl that hosts the WWF designer. We're now trying to host the WinForm User Control (with the embedded WWF Designer) in an ASP.NET page using <object> tags. We're current getting the following error.  Does anyone know a quick&dirty way to get pass this System.Security.SecurityException: That assembly does not allow partially trusted ...Show All

• SQL Server Performance/Optimizer question

  In SQL Server 2000, when I have a where clause in the following form WHERE intcol = floating point constant the estimated query plan makes it clear that there is data conversion going on and does not use the index that is on intcol. In SQL Server 2005, the estimated plan shows an index seek and has no evidence of data conversion. The rules for SQL Server 2005 seem to be the same as the rules for SQL Server 2000: If the constant ...Show All