Francesco De Vittori's Q&A profile

• Windows Forms Converting Point from Control to Parent Form coordinates

  Hi all Is there an easy way to convert a Point object (such as MouseEventArgs.Location) from the local Control's coordinate system to its Parent Forms system Currently I am doing something like: void MyMouseDown(Object sender, MouseEventArgs e) { Point ScreenPoint = ((Control)sender).PointToScreen(e.Location); Point FormPoint = this.PointToClient(ScreenPoint); //this is the Form object } But that seems something of a hack to me. The only other way I can think of is to work my way up the heirarchy of parent controls, adding their location to the mouse location until I get to the Form. But that seems even worse. Is there simple function such as the PointToClient() for the Form Cheers ...Show All

• Visual Basic MySQL

  Using MySQL to store my information on my server and I am writing a program to read/write to it. I am using an example on the web click here to setup my Login screen. Im having problems with the Imports MySql.Data.MySqlClient . I have gone to MySQL.com and downloaded the connector but I can't seem to get things working right. What am I doing wrong I clicked on Data and then Add New Data Source. From there I used the userid and password I had created for the specific database (schemea) I am using. VB does the coding behind the scenes. ...Show All

• .NET Development No error message available, result code: E_FAIL(0x80004005).

  hi friends i try to connect to ms excel in asp.net 2.0 protected void Button1_Click(object sender, EventArgs e) { DataTable worksheets; string connectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=Spain_test.xls;Extended Properties=""Excel 8.0;HDR=YES;"""; using (System.Data.OleDb.OleDbConnection connection = new System.Data.OleDb.OleDbConnection(connectionString)) { connection.Open(); worksheets = connection.GetSchema("Tables"); } } but i got Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. ...Show All

• Visual Studio Express Editions connection to SQL Express and then to SQL 2000

  i'm doing one small app for my company... i'm developing in sql express... is it enough for me to change connection string in app.config to point to sql server 2000 and will it work that way or do i need to change some things in code or dataset... i used wizard to connect to database and used drag and drop for fields to form... i need this app quickly done.. so when its finished i'll slowly go and make new version better... this now needs to be done i next 2 weeks... and i'm already 70% done (not counting reports)... tnx i dont use stored proc. i will start using them when i revork app... and start making web interface too... then i'll create first stored proc on sql 2000 and copy them to sql express so i know they will work on s ...Show All

• SQL Server Daily report generating Monthly rollup stats

  Daily report generating Monthly rollup stats I have a daily report which each morning generates monthly information for the current month which was implemented in December. Everything was working correctly untill January 1st. On the 1st the report generated blank since it was suppose to generate 1-31 Dec but but the currently month was Jan, so it failed. How do I program it so if it is the 1st of a month generates the previous month but still would generate current month but while in the current month Any help is appreciated. SELECT GETDATE() - 1 AS rptdate, Errors.WTG_ID, lookup.Phase, Errors.STATUS_TYPE, Errors.STATUS_CODE, STATUS_CODES.STATUS_DEF, Errors.TIME_STAMP, Errors.ANSI_TIME, lookup.WTG_TYPE, Errors.POSITION FROM Errors ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. BasicEffect, adding a texture and redering it.

  I'm trying to add a texture to a cube using the built-in BasicEffect class. Can't seem to get the BasicEffect technique to render the texture. How does one set the BasicEffect technique to allow rendering the texture Here is the cube set-up: public static VertexPositionNormalTexture[] MakeCube() { VertexPositionNormalTexture[] nonIndexedCube = new VertexPositionNormalTexture[36]; Vector3 topLeftFront = new Vector3(-0.5f, 0.5f, 0.5f); Vector3 bottomLeftFront = new Vector3(-0.5f, -0.5f, 0.5f); Vector3 topRightFront = new Vector3(0.5f, 0.5f, 0.5f); Vector3 bottomRightFront = new Vector3(0.5f, -0.5f, 0.5f); Vector3 topLeftBack = new Vector3(-0.5f, 0.5f, -0.5f); Vector3 topRightBack = new Vect ...Show All

• SQL Server Can SQL Server 2005 and Express Edition co-exist?

  I just started getting into C# programming, and downloaded the express version for work and at home. At home, I also installed SQL Server 2005 Express, but not at work, since I already have the full version installed. Unfortunately, Visual Studio Express won't recognize the full version of SQL Server, and I was wondering if there would be any problems installing both the full and express versions side by side. As this is my work computer, I don't want to risk it unless I know it's safe. Thanks for any help. Yes, you can install all of the SQL 2005 editions side-by-side. Installing Express would be a good solution for installing VS on your machine. Let us know if you have any questions with it. Thanks, S ...Show All

• Windows Forms Sending email in vb.net 2005(using vb) not with smtp but the users outlook (mapi)??

  I have an application that I need to send mulitiple emails from. There are about 10 users who will have permission. However my IT Group has locked down the smtp server and will not allow "Applications" use the smtp method. I remember in vb6 I used mapi to send emails using outlook that was on the users computer thus giving my IT folks traceability of who is sending what and not having to set up 10 people on the smtp permissions. Can this still be done using outlook(mapi) Try using SmtpClient.Credentials so you'll logon to the SMTP server with a username and password... ...Show All

• Windows Forms How to Print a form in C#?

  Hi, I am trying to print a form which is a longer form and has a scroll bar. Hence printing using the screen capture method to bitmap is ruled out as it only prints the part of the form which is visible. Drawing and painting each and every control also gives problems since I have some Office Web Components charts. Is there is a simpler way to do it Please help. Thanks in advance. Hi C#Thunder, I have an idea: you can iterate the control in your form, calculate the right-most distance and the bottom-most distance, and self-adjust the client area (by settting this.Size) in order to contain all the controls in the form before you capture the screen. The method of printing a form can be found ...Show All

• Visual Studio Team System Backup&Resto SPS Contents

  Hi, Our Sharepoint of TFS was down a couple of days ago. By luck, we had fully backed up SQL database. Now, the problem is, I uninstalled everything and tried to move TFS to a new server machine on the domain. I installed freshly everything and tried to restore all the databases (with tables also). Now the problems are these: 1 - Since there are lots of different backup-restore procedures telling on the Internet from some forums and this forum also: What should i do basically to make the configuration of Sharepoint and Reporting Services to make them work correctly 2 - Secondly, even if i fail in the problem above, I, at least, want to save the source control files and sharepoint files. Where can I find them and how ca ...Show All

• .NET Development Runtime Error 226

  I am using OS Windows 98 and recive a Runtime Error 226 periodically. Is there a fix for this ...Show All

• Windows Live Developer Forums Virtual Earth in a commercial context

  Hello, I am looking at using Virtual Earth in our new website (which will be offering a commercial service), but I was just wondering if there are any licensing issues involved. Any information on this would be great. Thank you Ben You can find many posts on this if you can search around but here is one: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1098896&SiteID=1 Or you can just read the terms: http://www.microsoft.com/virtualearth/control/terms.mspx On a separate note, I've been noticing a lot of these same questions pop-up, it would be nice to have an announcement on this forum for licensing policies for VE although there seems to be no MSFT's (aka Caleb) around to do this..... ...Show All

• Windows Forms datarelation and dataview

  Simple q regarding .net 2003 I got several tables A master and e few details/child tables add datarelations to it and bind it to controls... so far so good Now i wan't to filter/search the mastertable, Sound easy but when  i use a dataview i lose sync with the detail/child tables Remco I am having the same problem. Hopefully the following example will help people understand what we're trying to do.... Consider you have a DataSet which is made up of Customer information and related Orders, that is, one dataset with 2 distinct tables, "Customers" and "Orders". We create a DataRelation object called "CustomersToOrder" on the dataset which link ...Show All

• SQL Server Calculated Member (beginner)

  Hi, I'm building a calculated member which should only calculate the measures in the calculated member if specific measure is > 0 (otherwise the value should be Null) For example: If physicalStock > 0 [Measures].[Netweight] * [Measures].[Physical] How do I build this in the calculated member... (Using Analysis2000) Thanks in advance Haakon Here is what I am trying.... Iif ([Measures].[Physical] > 0), [Measures].[Netweight] / [Measures].[amount _count] * [Measures].[Physical] Which don't work....any ideas - what I should do... Thanks ...Show All

• Windows Live Developer Forums Strange Error coden when adding negative keywords

  Hi, I am trying to implement the use of negative keywords, but I keep getting this strange error: FAILED_NOT_KEYWORD_MISSING_AMT A negative keyword within the order is missing a partial match amount. I am sending a string array in the orderitem with the values ag nega1 ag nega2 Could someone please explain what this error code actually means What is a partial match amount Another strange thing is that the documentation says that negative keywords are send as a string where each negative keyword is separated by a comma. But in the orderitem class notkeywords are send as an array of strings. Is the documentation wrong Best, Peer Jakobsen Hi Peer, Thank you fo ...Show All