Sportsdude's Q&A profile

• Visual Studio Express Editions Looking up Username n password from login form to access database

  I have this login form and i want it to be able to do... When you click 'Login' - It will take the Text out of the username textbox and look for a match in the database table and then when it find it, it will look at the password in the next column and see if it matchs the password textbox http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=638452&SiteID=1 ...Show All

• SQL Server convert character data to datetime

  Hi! I need to insert character data into a SQL 2005 table in the datetime format. The strings I need to convert are in the following format: ddmmyyyy I tried using case and convert: cast('08162006' as datetime)) convert(datetime,'08162006',101)) Both attempts fail with the following error: The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value. Any advice is greatly appreciated. Thanks. You'll have to get the slashes in there to get it conformant with style 101.  Try:   select convert ( datetime , stuff ( stuff ( '08162006' , 3 , 0 , '/' ), 6 , 0 , '/' ) , 101 )   -- Adam Machanic Pro SQL Serv ...Show All

• Visual FoxPro Suggestion for VFP-MySQL Multiuser env.

  Hi all, I've just shifted from Foxpro tables to MySQL server based application. For a multiuser environment in VFP I used to have the temporary tables for the individual users in their own local machines. But in case of Mysql / oracle how to handle this situation The temporary table that I 'm speaking of are generated when I want to create some reports or perform some maintenance on tables. For example consider a scenario of producing a Sales analysis report. In VFP based application I created a local table say temp and put the data from invoice, invoice return and all related tables. then I manipulated the temp table to suit my reports. There was no problem in multiuser env. since each user created their own 'temp' table in thei ...Show All

• Audio and Video Development XPath Node Set Functions

  Does any know if node set functions, such as count or position, are vaild to use in the HDi world I've been trying, but I keep having problems getting a valued returned. Below is the line that is giving me the issue. It may not be 100% correct because I am writing this from home without the exact code in front of me. I believe it's close enough to get the idea across though. var position = this.savedbookmarks.evaluteXPath(position( //bookmark[@time ="+current+")],this.savedbookmarks.documentElement); From what I can remember, the evaluteXPath call returns a node list. In this case, it's returning a node list with a length of zero. Is there maybe a different way I should be going about this ...Show All

• Visual Studio How can I determine is VS is in Debug or Release mode from the BuildTask

  How can my buildtask determine what mode/configuration the instance of Visual Studio calling it in, Debug or Release The reason I require this is because I need to know the paths to the references in the current project i.e. <currentprojectcallingbuildtask>/bin/<mode> Thanks. LP. You will need to pass in the property Configuration to your task so that your task can determine the value or conditionally pass debug = true or false depending on the Configuration property when calling your task. Within a task you cannot determine if the configuration is debug or release. Thanks, Jay ( jaysh@microsoft.com ) ...Show All

• Windows Live Developer Forums VE and metric unit system

  Is there any way to display VE in metric unit system You can set the VEDistanceUnit to Kilometers so that routes and directions display in km. You can also change the map scale bar to km. This is an unofficial hack that SoulSolutions posted, but works for the time being at least: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=616949&SiteID=1&PageID=1 (and for cross-reference, here it is again): map = new VEMap('myMap'); MapControl.Features.ScaleBarKilometers = true; ...Show All

• Visual C# Convert Decimal to String???

  this .txtCommission.Text = ( decimal )_SalesPersonToEdit["Default Commission"]; How do i convert this string to a Decimal, I have tried using ToString() but that does not work and I also tried to use Convert.ToDecimal(string) = object....and that didnt work eithier any help on this situation! thanks! Actually i didnt need "(decimal)" in my code and it worked i guess when using that row of a datset i dont need to declare its type to bind it to the form.. but i did add the ToString() method though it looked like this this .txtCommission.Text = _SalesPersonToEdit["Default Commission"].ToString(); thanks 4 the help! ...Show All

• SQL Server Initializing a Merge Subscription Without a Snapshot - doesn't operate correctly

  Hi! I do the backup from the publisher, next I restore it at the subscriber using *pure* database. next I attempt to create subscription using this db. of course, I use SubscriptionSyncType .None for SyncType propery of the subscription. But, 1. nevertheless the merge agent downloads whole snapshot! both data (bcp files) and the schema. 2. I get the *strange* error. below thelines from the log: Applying the snapshot to the Subscriber A dynamic snapshot will be applied from 'C:\DOCUME~1\...\LOCALS~1\Temp\DB$MAIN_DB1_Main_testReplFromBackup\' Preparing table '__UserSyncOptions' for merge replication Applied script '__UserSyncOptions_2.cft' {call sp_MSsetconflicttable (N'__UserSyncOptions', N'MSmerge_con ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Really, REALLY strange "bug" with Vector3

  For my ray tracer, I created my own Vector struct that pretty much wraps a Vector3. The thing is, I used to have just three floats; X, Y, and Z. Now I just unioned them with the Vector3. For some reason, rendering time cut down by about 15% (i.e. from 10 seconds to 8.5). I removed the Vector3 and it went back to being 10 seconds. ...Wtf Is there a hidden type constructor with Vector3 that makes it much more efficient I'm not even using any of the Vector3 methods for my transforms and such. Could anyone tell me what the hell did I stumble into Pon t3h pony wrote: They're exactly the same. Are you sure There must be a difference somewhere! If all of the methods and constructors are t ...Show All

• SQL Server Tagging Sets

  I have a number of sets.... CREATE SET CURRENTCUBE .[Set1] AS {[Product].[Product Hierarchy].[Product Grouping].[Product Group 1].children} CREATE SET CURRENTCUBE .[Set2] AS {[Product].[Product Hierarchy].[Product Grouping].[Product Group 8].children} ..which I combine to form one master set.. CREATE SET CURRENTCUBE .[MasterSet] AS {[Set1] + [Set2]} Is there anyway I can flag which set the subsets originate from in the master set Would it be possible to achieve this using an IF statement as a column Thanks for the response but this doesn't quite crack it. Some of the sets are from the same part of the heirarchy and will have the same parent. I need to be able to d ...Show All

• Software Development for Windows Vista Workflow Compile Error

  I use the following code to compile my workflow WorkflowCompiler compiler = new WorkflowCompiler(); WorkflowCompilerParameters parameters = new WorkflowCompilerParameters(); WorkflowCompilerResults results = compiler.Compile(parameters, strArr); and I got a compile error "The root activity is invalid" The xoml file of my workflow begin with "<ns0:mySequentialWorkflowActivity ... ..." I think this is the problem, because this is the type I defined myself public class mySequentialWorkflowActivity : SequentialWorkflowActivity How can modify my compile code to compile with this workflow I'm using WWF beta 2.0 Thank you. What you are doing ...Show All

• SQL Server Weekly grain?

  I seems to be having issues setting grain of one of my fact table to weekly here's the error I'm getting: Error 1 Errors in the metadata manager. The attribute with ID of 'Quarter Name', Name of 'Calendar Quarter' referred to by the 'Week Name' aggregation dimension cannot be aggregated from the 'Week Name' granularity attribute of the measure group. 0 0 week name looks like Week 1, 2006 quarter name looks like Q1, 2006 they're both calculated columns in the DSV there's no hierarchy or relationship setup between weeks & quarter directly - only through the DateKey they're both related to. seems like SSAS can't roll up WeekOfYear to a calendar month. I'm pretty sure it's something stupid on my part, but I can't s ...Show All

• Visual Basic How to convert delimiter base text file to .mdb

  Hi, How to convert delimiter based text file to mdb. Actually I need create table structure also runtime. If any has coding like that pls send to me ASAP by Thiaygu I have an old trick I'm fond of. You can import a delimited file into excel and then label the columns and save the Excel file. The Excel file is directly importable into an Access MDB file. ...Show All

• Visual Basic Getpixel for JPEG

  as i was searching the forum, i encountered Getpixel which is easy to use for image manipulation, my problem is i need to manipulate a JPEG file, how could i incorporate or address this problem thanks An image (.jpg, .bmp, ...) is usually represented as a Bitmap object, so if you want to look at the pixelcolor of an image inside a picturebox, it's easier to make the Bitmap object yourself so that you have a variable pointing at it, and then load that Bitmap as the image in the PictureBox. The pixel that you want to get the color of, needs to be specified by x,y coordinates on the Bitmap, so x can go from 0 to Bitmap.Width, and the y coordinate can go from 0 to Bitmap.Height. To find the right bitmap x,y coordinates takes a bit of rec ...Show All

• Visual C++ How i can create ZIP archives in C++?

  Hello! How i can create ZIP archive files in C++ Baybe some library help me with this or MSVS already have function for work with ZIP files I know library "zlib" but this library can`t compress folder only files. Please help me with this problem, Thanks! Check this link. http://www.codeproject.com/file/zip_utils.asp ...Show All