DaveHorner's Q&A profile

• .NET Development an datetime problem, please have a look:)

  I have a simple select command issuse,  I am using sqlExpress 2005 server,  when I try to use following select count(*) command: SqlConnection1.Open(); DateTime dt = DateTime.Today; SqlCommand cmd1 = new SqlCommand("SELECT count(*) FROM ClinicTimeTable WHERE ClinicDate >= '" + dt + "' ", SqlConnection1); int count = (int)cmd1.ExecuteScalar();  SqlConnection1.Close(); MessageBox.Show(count.ToString());   count always return 0 unless I use datetime formate like '9-march-2006' , I don't understand why I can't just use a datetime object why the datatime formate has to be like '9-march-2006' is it something to ...Show All

• SQL Server Import tables from DB2 to sql 2005

  I have problems importing tables from db2 using the import wizard using IBM OLE DB Provider for DB2 The tables and data ('Preview...') can be viewed but when trying to map the columns ('Edit...' next to the tables) or import the data an error is recieved [DB2/NT] SQL0443N  Routine "SYSIBM.SQLCOLUMNS" (specific name "COLUMNS") has returned an error SQLSTATE with diagnostic text "SYSIBM:CLI:-727".  SQLSTATE=38553 Schemas is used in both DB2 and Sql 2005 There is no problem importing to Sql 2000   Alot of people have been having issues related to IBM's OLE DB Provider with SS ...Show All

• .NET Development Parameters in a sql statement

  I am creating a simple sql statement that returns all from the table that is equal to Comp_UserID. The problem I am having is that I want to pass in the Comp_UserID as a variable. I am not sure of how sql parameters work, i have tryed searching the msdn network but I can see nothing for begineers so if anybody has any useful links that would be great. Below is the code I am using. //This is statement works correctly SqlDataSource1.SelectCommand = "SELECT * FROM ApprovedComponents WHERE Comp_UserID = 61" ;   //Now I tryed inserting the variable like I would pass a variable to a function but it does not work, int ...Show All

• Visual C++ C2248 error when migrating my project from VC7(2003) to VC8(2005)

  My project compiles in .net 2003, but when compiling in .net2005, i got tons of errors like this. error C2248: 'std::vector<_Ty>::_Myfirst' : cannot access protected member declared in class 'std::vector<_Ty>' with [ _Ty=unsigned char ] c:\program files\microsoft visual studio 8\vc\incude\vector(1243) : see declaration of 'std::vector<_Ty>::_Myfirst' with [ _Ty=unsigned char ] thanks for helping me on this. PeelerJ wrote: My project compiles in .net 2003, but when compiling in .net2005, i got tons of errors like this. error C2248: 'std::vector<_Ty&g ...Show All

• .NET Development My thread was erased

  mmm i dont know if this is the right place to post it ,, well some thing like a week ago i posted a thread on c# general about sending bytes trough tcp.. it got like 10 answers and they told me to post in this forum... so today i came and post a thread that explained my new code and another way that im using to send the byte[] and also showing my new code.. and that 1 got erased and my old therad was pasted instead of my new.. so i ask pls to put back my thread the name was sending byte [] trough tcp C# , theres allready this thread in this forum but its overwriten... and when a mod read this pls erase this thread thx mig16 ...Show All

• Windows Forms How can I pass the messages between windows MDI forms and childforms?

  I am using VS 2003 version with MDIForms and childforms.I wanted to pass the messages from childform to parent(MDI)form depending on childform events For example, if I have 5 childforms, when the childform closes, I wanted to pass a message to parent. Based on the message, parent form needs to enable or disable the menu. Parent form also wants to check how many child forms opened or similar logic. The logic I can take care, but How can I pass the messages between windows MDI forms and childforms .Any c# or VB or C++ sample code appreciated.Thanks in advance, Hi you need to listen to the MdiChildActivate event and in that event ch ...Show All

• SQL Server Report Builder limitations

  Can anyone confirm the following 1. Can't add images to reports. 2. Can't have fields in a non-tabular layout (e.g. mailing labels, letters, etc.). 3. Can't control column or row spacing of fields or have details that span more than one row. Thanks. 1) In the current version you can have images pulled from database. You need to have a model entity with an attribute of type binary (corresponding to your image column) and you need to edit the attribute to specify the right MIMType. After that you can drag the attribute into report and you will see images. In Yukon SP1 we are adding support for ima ...Show All

• Visual Studio CrystalReportViewer

  Is there a deployment fee if I use the CrystalReportViewer in my app Hello, Here is a link to our licensing web site: http://www.businessobjects.com/products/reporting/crystalreports/net/licensing.asp You should be able to find the information for you scenario there. Keith - Business Objects ...Show All

• Visual C# Ressources from another assembly

  When you use ressources from another assembly, how do you know what Name to use when calling a resource for example : pictureBoxUser.Image = (Image)rm.GetObject("add"); how do you know you have to use the add string to get an image of the add .... Maybe you know it by looking at the documentation of the ressource library when you get resources you must use fully qualified name. full name could be found by using Lutz Roeder's .NET Reflector and of course you must be sure you call appropriate type of resource hope this helps ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rotating individual point sprites

  I am using point sprites to render a snow particle system. It would be nice to be able to rotate each individual point sprite around the Z-axis,X-axis or Y-axis , to give the illusion of using more than one texture. Looking through the docs, there doesn't seem to be any support for this. Has anyone found a workaround, like maybe rotating the view matrix per particle That would pretty much wipe out any bandwidth benefit from using point sprites though... How to rotate the texture for each particle sprite quickly could you tell me where can find the sample Which sample The example I mentioned ...Show All

• Visual C++ sqrtf under 24 bit floating point precision

  Hi, While trying to estimate performance impact of using 24 bits floating point precision versus 53 bits, I've noticed that sqrtf function was 6 times slower in 24 bits control mode. Every other operation I've tried (divide, exp, cos, ...) are all faster or equal in 24 bits mode compared with 53 bits mode. How could this be explained Are there other math functions or instructions that will suffer using 24 bit mode Regards Guillaume Are you using VS2005 If you are which floating point switch are you using Also, could you post a small sample to reproduce the issue on my side Thanks, Aym ...Show All

• SQL Server Invalid snapshot-triggered data-driven subscription causes RS dump

  If a data-driven subscription definition is invalid because it is trying to set a report parameter that affects the contents of the snapshot that the report is using, in a report that is rendered from a snapshot, SSRS responds with "An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help For more information about this error navigate to the report server on the local server machine, or enable remote errors" If I display the report itself, parameters that are used in the dataset query are grayed out and I can't change them. When I define a data-driven subsubsc ...Show All

• .NET Development Error on adding custom section to roaming users configuration

  Hi, I'm actually trying to write a custom configuration section class and use it to write into a roaming users file. I took the base code on MSDN Help, but the example works only with ConfigurationUserLevel.None. In my application I like to use ConfigurationUserLevel.PerUserRoamingAndLocal. In fact all works well, I can build the section object, and can attach it to the configuration, but if I try to set the SectionInformation.ForceSave to true or try to use the Save method on the configuration himself, an exception will be thrown with Message "ConfigurationSection properties cannot be edited when locked". The lock will exactly be done on ad ...Show All

• Windows Forms Order events are fired in form

  I don't know if I'm perhaps following bad coding practice, but here we go: I've got an application that is dynamically opening child forms. In the form_Load event for one of my forms, I am populating some combo boxes. That works beautifully. Here's where it gets interesting: The combo boxes have sorts and filters applied when they are loaded. All three combo boxes are related to each other. I would like to figure out a way to change the text showing in the other 2 combo boxes whenever a user selects (or types) something in one of the other two combo boxes. This would be done using a combobox.findString with a string based on a query to ...Show All

• SQL Server Print Problem in SSRS

  Is it possible to send report directly on printer when user clicks Print button on web page I am using SQL Server 2005 reporting service. Thanks in advance. ...Show All