Jasper Eenhoorn's Q&A profile

• SQL Server Date validation

  How would you go about adding date validation in reports For instance, I'd like to ensure the "start date" parameter is an earlier date than the "end date" one. Is it appropriate to use as data type string for the Date parameter to suppress the time b'coz in my company they doesn't want the time to be displayed for the Datetime parameter while executing the Report. So i used the string datatype instead of DateTime to suppress the time is it appriopriate to use. Thank's. Hi, actucally you can’t do validation in the partameters section. Wha ...Show All

• Visual Studio Express Editions EXE

  Is it possible to compile simple .exe's in vb.net. Simple, like asking the user what message will he display through say an input box then he chooses. Then, clicks "build" and saves the .exe somewhere so when you click on the .exe it will say the message that he inputed. I read that some language called KPL was written in C#. And i thought, hey, c sharp and vb are almost the same. Maybe i can do an extreamly cheesy simple version of this. KPL (kids programing language) was written in C# ...Show All

• Visual Studio Local Report in Winforms returns the followin error "The report definition for report 'xxx' has not been specified.Object Refere

  "The report definition for report 'xxx' has not been specified. Object Reference not set to an instance of an Object" The report viewer was dropped onto a tabpage, the report was created, and using the smartags for the viewer the report was specified.  The datasource has also been set in the report designer. The error occurs on the Refreshreport step.              ' See the Activate event             Dim aparm_report_parms(0) As Microsoft.Reporting.WinForms.ReportParameter        &n ...Show All

• .NET Development VS2005 Server Explorer Doesn't show stored proc columns

  In the server explorer for VS2003 it was possible toview the columns that a stored procedure returned along with its parameters. VS2005 server explorer only shows parameters, no columns. I've searched high and low fo a place to turn this on, if that can be done. What's up Anybody know how to view the columns. That's a real help when making sure column names in code match their stored proc names. Hi Thomas In Visual Studio 2005 we do not display the output columns in Server Explorer because this list can be non-deterministic for Stored Procedures.  For example, if a user had the following stored procedure code: ALTER PR ...Show All

• .NET Development Need help with web application

  I've got a VB program that i've built in Express beta 2... A user fills out a form, including an email address, and the program stores the entered data in a database, and sends an email to that address... That much works fine, but... I need that email to include a "more detailed info" link/button/something that will trigger another program that will send another email. I need some way of knowing which user clicked the link. When the record is created in my database, i've given it a unique identifier, because i thought i could send this to the database, to choose the correct record, and format the 'more detailed info' properly. how do i incl ...Show All

• Visual Basic Retrieve the ID of a new row

  I have two table: Category and Product. The second one has a column CategoryID referring to the Category ID. Now, I need to add a the same time a row on Category and a row on Product with Product.CategoryID =Category.ID If a create a new row on Category I don't know the ID value of this, because it's autonumber and I don't set it, it's automatically created. If I have to create just after that the row on Product, how can I set the CategoryID How can I find the value of ID of the new Category row just created Thanks in advance Dado I would like to make a slight change to the info above. that I wrote.. I ...Show All

• .NET Development Help with ODBC Connection from Windows App

  Hi, I have some code which works perfectly from an asp.net 2.0 application to connect to a database create a command/dataadapter, and return the dataset.  But when I try to run this same code, with the same libraries referenced I get this error:   "ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"  Here is the code from the windows app, I actually get it when I try to open the connection OdbcConnection conn = new OdbcConnection ( " Driver={MySQL ODBC 3.51 Driver};SERVER=Server;DATABASE=DB;UID=UID;PASSWORD=PW;OPTION=3" ); try { conn. ...Show All

• Windows Forms Adding picture to System.Windows.Forms.DataGird 1.1

  Is it possible to have a column in my Win DataGrid (1.1) that is a picture if so, then how Why is my thread ignored Is it possible to add a picture or not ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Confusing issue for a moderately new DirectX developer

  First off, the preliminaries: I'm an actual game developer, though I've worked exclusively on consoles and mostly audio and network coding.  I'm wanting to do lightweight home games in my spare time for me and my friends. I'm doing this on a laptop with a GeForceFX Go5200.  I have the December DX SDK installed, and I'm using VS 2005 Standard (hooray for launch events). I decided it would be a good idea to follow the Coding4Fun "Beginning Game Development" tutorials to get a feel for managed DX.  I printed them out and started working. I'll be using the C# code from here  to explain my issue.  It ...Show All

• .NET Development How can i use C# windows control library project in VB6

  hi, i have created user control in C#.Net. i created UI design. i already set the Register For Com Interop= true. i created a tlb file for that control. & make it's registry & register that control. in vb6 i try to add that control but it can't provide me control. as well as i try to add reference of that control it add the reference but it can't provide the UI design in VB6. if u have any kind of help plz... help me. i have working on live project there i have to use this kind of interop. advance thanks, & plz plz plz help me related to this topic. Why do you need to use VB6, but want to support .NET as wel ...Show All

• Visual FoxPro MSComctlLib.TreeCtrl.2 BackColor ???

  MSComctlLib.TreeCtrl.2 does not have BackColor property. Is it possible to define one (it is of course possible) and actually make it functionable Thanks. DECLARE LONG SendMessage IN User32 LONG nhWnd, INTEGER Msg, LONG wParam, LONG LPARAM SendMessage( THISFORM .TreeView1. HWND , 4381, 0, RGB (255,255,192)) ...Show All

• Visual C# Download file(MP3) with progressbar

  Any sample(s) online (I don't need to stream it)   private bool DownloadFile( string sURL, ProgressBar pProgress, string Filename) { System.Net. HttpWebRequest URLReq; System.Net. HttpWebResponse URLRes; System.IO. FileStream FileStreamer; byte [] bBuffer = new byte [1024]; int iBytesRead = 0; try { FileStreamer = new FileStream (Filename, System.IO. FileMode .Create); URLReq = ( HttpWebRequest )System.Net. WebRequest .Create(sURL); URLRes = ( HttpWebResponse )URLReq.GetResponse(); Stream sChunks = URLReq.GetResponse().GetResponseStream(); pProgress.Maximum = ...Show All

• SQL Server Can't connect to Report Server via Management Studio

  Hi, I have a local installation of SQL Server 2005 (Developer Edition) on XP Professional SP2, with Reporting Services, Integration Services, and Analysis Server installed. I can connect to Integration Services and Analysis Server via the SQL Server Management Studio, but not to the Report Server. I can access and use the Report Server installation via http://localhost/Reports and http://localhost/ReportServer , and everything checks out on the Reporting Services Configuration tool, so the server appears to be working fine. I've uninstalled/re-formatted/reinstalled the services (with all default options, and services running a ...Show All

• SQL Server How to move the whole SQL 2005 instance?

  Hi, What is the simplest way to move the whole instance from one box to another. I can stop all SQL services for couple hours, it's no problem. But I'd like to make absolute copy. So I need to move all databases, logins, roles, triggers, stored procs, packages, jobs, credentials, endpoints, proxys, etc. I need just replace the server (the box itself) with a new one. Thank you. Do you mean backup and restore for each database Or for all at once By the way, would it work: If I delete whole folder "SQL 2005" on the new box (after installation) and then copy this folder from the old box ...Show All

• Visual Studio Team System use Team Build on a website

  How to use Team Build with a website with Project references within the same solution The project referenced assemblies are not copied over to the bin directory and is resulting in unable to find namespace or assembly error See post http://forums.microsoft.com/msdn/ShowPost.aspx PostID=10588  the issue seem to be in MSBuild Task not with Team Build, thanks ... ...Show All