Jeremy Schneider's Q&A profile

• SQL Server VIEWS With Columns set by NEWID()

  I have a view which at the moment has no unique identifier on each record. When I try adding a column definition to the view such as NEWID() as TransactionId , the view then cannot 1) be selected into a temporary table, or 2) queried on other columns in the table. In either case I end up with an empty result set. I believe I have a way around this for my purpose, which was principally testability. However, can anyone enlighten me as to how and why this happens Andrew Raymond Interesting. When I did select * from bobPlusUniqueIdentifier where bobId = 2 I got the one row result. Here is the exact command I executed: set nocount on go --the first time, this might raise an error drop table bob drop table #hold ...Show All

• Visual Studio 2008 (Pre-release) New XBAP and Code @ xamlXaml.com: ScrollingCanvas

  New XBAP with Code example up at xamlXaml.com: http://xamlxaml.com/2006/09/27/scroll-text-and-almost-anything-else-with-the-scrollingcanvas-container/ This example creates a custom user control based on the Canvas container. This ScrollingCanvas allows you to scroll any FrameworkElement: text, video, shapes, or even whole scenes. Moreover, you can scroll multiple FrameworkElement objects at the same time in a single scroll container. Both speed and direction of the scroll is controllable via dependency properties. Simply drop the ScrollingCanvas control on the design surface or add it in XAML, add any FrameworkElements you want to scroll to the ScrollingCanvas container and call the ScrollBegin() method. All object scrolling is ha ...Show All

• Visual C++ non-.NET - sleeping for 100 microseconds

  Hi! Is there any function in the CRT or Platform SDK which I can use for sleep-ing for 100 microseconds Thanks. The standard sleeping function "Sleep", in the Win32 API only supports milliseconds. There are various methods of timing in the Win32 API (like WM_TIMER, the multimedia timer) but they all seem to be at a millisecond or slower granularity. You might be able to get more granular time with performance counters and/or GetTickCount(); but you will only be able to simulate causing the thread to sleep because you'll have to loop until a specific time has elapsed--probably defeating the purpose, as you'll hog the CPU while "sleeping". ...Show All

• Windows Forms Using BindingNavigator with multiple BindingSources

  How does one implement BindingNavigator with multiple BindingSources I have successfully coded to change the BindingSource of the Navigator according to the user-selected table. However, the SaveItem method of the Navigator is designed for only one table. I cannot figure out how to allow the user to choose which TableAdapter to update (Because there is seemingly no way to cast a TableAdapter or to obtain a list of TableAdapters in the form). I am presently using if statements to choose a TableAdapter but this is cumbersome for lots of tables. Please advise. The following thread indicates that there is no streamlined solution to this problem since tableadapters cannot be cast : http://forums.microsoft.c ...Show All

• SharePoint Products and Technologies Install WSS 3.0 on Vista (or only Windows Server)?

  Hi all, I thought I read somewhere that you could install WSS on Vista (I have Business Edition) - is this correct or can it only be installed on Windows Server Thanks in advance. Grant. Hi Nick, Thanks for the clarification. Cheers, Grant. ...Show All

• Visual C# Output parameters not working

  Hi All I'm trying to get somme code to work but it just won't and I can't figure it out! I'm trying to get soem information from a database using a uniqueidentifier key field. I want to take the information out of the databse using output parameters. I've created the follwoing code: string ConnectionString = WebConfigurationManager .ConnectionStrings[ "plss" ].ConnectionString; Guid UserGUID = new Guid (userID); SqlConnection conn = new SqlConnection (ConnectionString); SqlCommand cmd = new SqlCommand (); cmd.Connection = conn; cmd.CommandText = "plss_Users_AllUserData" ; cmd.CommandType = CommandType .StoredProcedure; cmd.Parameters.Add( new SqlParameter ( "@M ...Show All

• .NET Development email from window form

  i am using window project how can i send email to other with free smtp. You can use the SmtpClient class http://msdn2.microsoft.com/en-us/library/system.net.mail.smtpclient(VS.80).aspx You will need to point it to an smtp server for it to deliver your mail. ...Show All

• Visual Basic Transferring data from FoxPro dbf to Sql

  Dear All, I need all your help urgently. I wanted to write a small piece of vb code to sychronize a few FoxPro dbf tables to SQL tables that having the same structure or at least a few fields that i selected. I had tried a code which I found on the net that running row by row  and column by column to update the SQL tables but this code is too slow. In my dbf table it contains around 3000 records at least. Please help. Thanks in advance. Regards, Weoi Li ps: Happy 2006!!! I understand that I manually open both databases. What I'm having a little trouble grasping is how to move the data from the foxpro table into the SQL table. The above example shows a Select from Source and insert into Target. I'm sure that will work fine i ...Show All

• Visual Basic WebServices and Functions accepting Generic Lists

  Hey Everyone, hopefully someone can help me with a little problem I have. I've coded a webservice to update a database on a server and I call it via a small application I've created anyways the webservice contains a function that takes in a datatable containing the actually database data (which seems to pass alright) and a couple of generic lists used to create the table if it doesn't exist. Problem I have is I've declared my functions in the webservice like the following <WebMethod()>_ Public Function ServerDataDB(ByVal Job as String, ByVal ColumnNames As Generic.List(Of String), ByVal TableData As DataTable) As boolean Now when I add a reference to it in my application it tells me that ColumnNames needs to be passed as type string ...Show All

• Visual Studio VS 2003 SP1 - Error 1706

  I keep trying to install SP 1 for VS 2003 Enterprise Edition. When I browse to the vs_setup.msi file provided on the MSDN DVD's I get Error 1706 - File cannot be found and the installation rolls back. What is going on and how do I get SP 1 to install TIA try downloading and installing SP1 for VS2003: http://msdn.microsoft.com/vstudio/support/servicing/default.aspx ...Show All

• .NET Development Free Web Service Provider

  I'm new to "Web Services" and i would like to try it out remotly. Can anyone recomend a good free web service provider Can i use any free service provider which gives free asp webspace I don't wish to construct asp web pages though. i want to test out "Web Services". Thank you. Ive found one for those that are interested. http://www.brinkster.com/ They provide a free developers package. ...Show All

• Software Development for Windows Vista Accessing properties of subsequent activities (Not children) from the executing activity

  I have a large workflow with lots of parallel activities so that the workflow branches continuously as you go down the design. On a particular parallel branch I need to access the individual properties of subsequent (Not child) activities and all their children without confusing them with the activities that are in the same context but on a different branch. I need to keep the look of the workflow extremely simple (although huge) in the designer as this workflow will have simple changes to it made by users in a re-hosted designer. Where is the best place to access these properties from How do I make sure I'm only accessing the ones I want Thanks You should use dependency properties and link properties on the earlier activit ...Show All

• Smart Device Development Using VB program to open file on a CDMA device - PPC6700

  I'm trying to use the Shell command to run a .exe file on a mobile Pocket PC, but when I run/debug the program on the phone it keeps coming up with the FileNotFound error. I'm thinking it is the path that is wrong, but I can't find anywhere as to how to address the path on a mobile device.. i.e. Shell("c:\program files\calc.exe"). I have tried every combination i can think of, from My Device, to C: to just \... but nothing seems to work and I know I'm missing something. Any help would be appreciated. if using .NET 2.0 then use the Process class to launch your file. imports System.Diagnostics imports System.IO .. .. private sub button1_Click(byval sender as object, byval e as Eventargs) handles button1.clic ...Show All

• Visual C# Not finding a web proxy class that should be auto-generated

  I'm having difficulty running my web app. It was working correctly, but I had to move the project files around. After moving them, I added the web site and service back into the project. My service works perfectly but my site can't seem to find the class UserService.UserService (which I believe is auto generated by my web reference). I tried removing the web reference, closing VS, opening and cleaning the solution, closing, then adding it back in and deploying - but no luck. The disco, discomap, and wsdl files are added to the project correctly. Here is the exact error message C:\philipd\Visual Studio 2005\Projects\...\Global.asax(5,5): error CS0246: The type or namespace name 'UserService' could not be found (are you missing a using direc ...Show All

• Visual Studio Sandcastle December CTP - Member pages have no collapsible group descriptions?

  Hello All, I have been using the new ApplyVsDocModel.xsl in the December CTP instead of AddOverloads.xsl to generate the member pages, but when I look at what it  has produced I can see it has put the members into various collapsable groups, but there is no name describing the group. For example, the Public Methods group  has a - or + icon to allow the group to be collapsed or expanded, but there is no description following it so it is not immediately obvious what group of members you are looking at. In the member page that was generated for my code, it produced 5 collapsible groups (Public Methods, Protected Methods ,  Public Constructors, Public Properties and Public Events) but without the description of the group ...Show All