Paulustrious's Q&A profile

• SQL Server splitting data

  I've read that we need to split data into a training and testing data set. How do I go about that You can use the sampling transforms in Integration Services, Percentage Sampling and Row Sampling. Percentage Sampling simply divides an input set by a %. A typical division is 70% training and 30% test. Row sampling allows you to choose exactly how many rows you want to select from an input of unknown size In general for splitting a dataset you would use % sampling. Row sampling is good if you have an aribtrarily large dataset that you want to reduce to a reasonable size before mining - e.g. millions to 100's or 10's of thousands (not that you need to, it's just faster) There are some tips on advanced sampling at http://www.sql ...Show All

• SQL Server SOLUTION! - VB.NET 2005 Express and SQL Server 2005 - NOT saving updates to DB - SOLUTION!

  VB.NET 2005 Express and SQL Server 2005 Express - NOT saving updates to DB - SOLUTION! ----------------------------------- The following article is bogus and confusing: How to: Manage Local Data Files - Setting 'Copy to Output Directory' to 'Do not copy' http://msdn2.microsoft.com/en-us/library/ms246989.aspx You must manually copy the database file to the output directory AFTER setting 'Copy to Output Directory' to 'Do not copy'. Do not copy The file is never copied or overwritten by the project system. Because your application creates a dynamic connection string that points to the database file in the output directory, this setting only works for local database files when you manually copy the file ...Show All

• Visual C++ Convert Exe to dll

  Hello friends, I have an application for VC++ 6.0. This application creates an exe. I want to convert this application, so that the output is win32 dll. Whether i have change some project settings or i have to modify the code. Please help me in doing so. Thanks Look at the /LD compiler option. You will need to change your code as well. Take a look at creating Dll on MSDN. For further related issues on VC6.0, please use the newsgroups at http://msdn.microsoft.com/newsgroups Thanks, Ayman Shoukry VC++ Team ...Show All

• Windows Forms add 2 DataTables into 1 DataGrid

  hi, I have 2 dataadapters that fills 2 datatables i want to show them both in 1 datagrid How do i do it I think detail steps to combine two tables depend on the logic how you want to combine them. If you just want to create a new table with all columns in those original two tables, use following code for example DataTable dt = new DataTable(); foreach (DataColumn column in northwindDataSet.Customers.Columns) dt.Columns.Add( new DataColumn(column.ColumnName,column.DataType,column.Expression)); foreach (DataColumn column in northwindDataSet.Employees.Columns) { if (dt.Columns.Contains(column.ColumnName)) continue ; dt.Columns.Add( new DataColum ...Show All

• SQL Server Is it possible to disable a specific warning ?

  Hi! I'm running dtexec with the /WarnAsErrors flag, to be sure to detect any configuration warning (configuration errors are actually throwed as warning, which is not sufficient) or any other important warning. I only get one warning (0x80047076, optimisation warning). Is there a way to disable this specific warning thanks Thibaut ...Show All

• Visual Studio Express Editions Window fully loaded

  Is there a way to check if a window has been fully loaded In particular, I am starting a program with Process.Start This opens up a window where the process is loaded after some time. I am using sendkeys to that window but I need to do it only once the process is fully loaded so that it accepts my keys. In Internet Explorer there is a handy readystate method, but I understand that for other applications, if they do not send this information to the operating system what I am asking may not be available. Thanks, Antonio You could do something like sending a message to its main window. It will respond once it is done initializing and entered its message loop. Once it ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. How Do I Determine The Currently Visible Area?

    I'm building a 3D game and currently have everything working, but I'm in the process of optimizing my framerate.  The world in the game is many times larger than the screen/window.  How would I go about determining the world coordinates that are visible on the screen   Even though the objects outside of the viewport are clipped, the draw code still has to translate (and rotate) the meshes in the objects (many of which will be clipped).  It would be much more efficient if I could just not process meshes that will be outside of the screen.  Thanks!   The best and most used practice for efficient management of the viewport contents is to use a tree str ...Show All

• Visual Studio 2008 (Pre-release) IWsdlExportExtension contracts

  Hi all, I we have an environment where there is a set or message inspectors that on the client, inject a custom header to pass information to the service and then on the service side take it and expose the information as a class that is available to service methods. The problem i have is this header is not exposed on the wsdl and i would like it to be so that non wcf clients can pass the information. I think i need to have a class implement the IWsdlExportExtension interface but i cannot find any example of using the ExportEndpoint method Can anyone help me on this, or recommend how i can expose the header in the wsdl There are few examples already in the this forums 1. http://forums.m ...Show All

• Visual Studio 2008 (Pre-release) UDDI Sample Questions

  1) Does the uddi sample work with only basicHttpBinding only Or can you use wsHttpBinding also 2) I noticed that UDDI related code is not coming from .net framework but appeared to have been generated with some internal schema or published uddi wsdl. Does this mean this code will look like this until WS-Discovery support is in place Thanks. Your welcome. Do check out the SDK documentation at http://msdn.microsoft.com/library/default.asp url=/library/en-us/uddi/uddi/portal.asp so that you know your way around. The UDDI SDK will happily serve up discovered endpoints that you can easily use from WCF clients. Andy. ...Show All

• .NET Development VB.NET and MYSQL

  Hey guys: Where can i get help in order to connect VB.NET to a remote MYSQL database Framework : Net 2.0. Languaje : VB.NET OS : XP Profesional Database : MYSQL Imports : Systen.Data.Oledb String connection : Provider=Microsoft.Jet.OLEDB.4.0;Server= www.domain.com ;Data Source= Mydb ;Uid=xxx;Password=yyy;" Errror : No se pudo encontrar el archivo ISAM instalable Remote server is available. Same error is produced when try to connect to localhost Database is up and running Thanks in advance campo You won't be able to connect using the Jet OLEDB provider. Try using some of the MySQL options such as the ODBC driver, OLEDB provider or .NET library: http://dev.mysql.com/tec ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Content pipeline design issues

  I LOVE the content pipeline, but while digging deep and creating a bunch of cool custom importers/processors/etc I found a few annoyances that I don't see clean solutions for. I was hoping some experts here or MSFTies could set me on the right path. My problem is with the content pipeline and it's files/types. I have two assemblies that I'm using, we'll call them Foo.Content and Foo.Content.Pipeline, with Foo.Content containing the types I use and the content readers, and Foo.Content.Pipeline containing the processors/writers/importers. Of course I have two versions of Foo.Content (one for Windows, Foo.Content.Windows, and one for the 360, Foo.Content.X360 - the 360 one has the files from the Windows folder linked in). I kind of lik ...Show All

• .NET Development What's the difference between BCL and FCL??

  hi, guys, I would like about what's the difference between BCL(Base Class Library) and FCL(Framework Class Library)in .NET technology thank's!!! There really isn't any difference in general usage IMHO.  When people say BCL or FCL they are generally talking about the same thing.  However when push comes to shove the BCL is technically the base classes from which everything else is based (including the remainder of the framework).  The FCL is the entire framework.  The BCL would include everything in mscorlib and system and possibly some additional assemblies.  It includes all the type, assembly, reflection and collection classes of the framework (among others).  It does not include A ...Show All

• SQL Server attribute relationship modelling by BIDS

  Hi, litle question about modelling attribute relationships on dimensions with >=50 Attributes As far as I know it is only possible in the treeview of BIDS to model attribute relationships, but what if I have already 50 Attributes and want to drag an attribute to an attribute thats already as much down that i cannot see it - if you drag an attribute the view does not scroll down like excel or some other appliation while you are at the boarder of the view. Is there any other way do add some attribute relationships (not code, not programming) Hannes You can right click on an attribute in the tree view and then choose "copy". Then you can go down to the attribute that you want to relate the first attribute to and ...Show All

• SQL Server Help with Join Syntax

  I have a query where I need to join a table to multiple tables and alias a field from those tables on each join. I tried the syntax below but received a error. Please assist, first time trying to do this. JOIN dbo . AbsenceReason ar ON ar . AbsenceReasonID = sda . AbsenceReasonID WHERE ar . [Name] = 'DailyReason' LEFT JOIN dbo . AbsenceReason ON ar . AbsenceReasonID = spa . AbsenceReasonID WHERE ar . [Name] = 'PeriodReason' LEFT JOIN dbo . AbsenceReason ON ar . AbsenceReasonID = cio . AbsenceReasonID WHERE ar . [Name] = 'CheckInOutReason' error I receive is : Msg 156, Level 15, State 1, Procedure p_000001_GetAttendanceProfileData, Line 45 Incorrect syntax near the keyword 'LEFT'. Msg ...Show All

• Visual Studio Express Editions Linker problem for OpenGL Program

  Hello, I'm trying to start going through the "Beginning OpenGL Game Programming" by Astle and Hawkins. The book uses VC++6.0 for its sample code, but I have VC++ 2005 Express Edition, and I'm having trouble getting a simple sample working. It compiles fine, but when I try to build it, it says LINK : fatal error LNK1181: cannot open input file 'condlg32.lib' Does anyone have any suggestions Thank you so much! That's the new world of C++/CLI. It has very little to do with C++, it has everything to do with adapting C++ to let it generate .NET code. The key issue is that memory management between traditional C++ and managed C++ is completely different. MSFT invented a new syntax ...Show All