S Tonstad's Q&A profile

• Visual Studio 2008 (Pre-release) Navigate

  Hi, Using the August CTP-bits I tied executing the following statement: Query<Category> categories = db.GetQuery<Category>("SELECT VALUE c FROM Categories AS c WHERE NAVIGATE(c, NorthwindLib.Category_Product).ProductName LIKE 'A%'"); Which results in a mapping exception: The Member or Property 'Category' on the 'C' side is not present on the 'O' side. Why Regards, Jesper Jesper, I assume you want to get the categories that have products starting with ‘A’. If you want to do that at the object layer using ObjectQuery<T>, here’s how: ObjectQuery < Category > categories = db.CreateQuery< Category >( "SELECT VALUE p F ...Show All

• Visual Studio Express Editions Getting data out of a database column

  I've got a database connection via VB code and i've got my filter ... Does anyone know how to get the data out of record 1 and out of a certain column As you dont say whether you've actually populated your dataset, you mention you have a filter but without seeing code and vague description is difficult to tell what stage your at. A dataset comprises of one or more datatable which comprises of columns and rows collections. To access the value in the first table, first row Dim s As String = x.Tables(0).Rows(0).Item( "Col2" ).ToString Item can be either the column name or you can use an integer value as this is a zero based collection. Dim s As String = x.Tables(0).Rows(0).Item(1 ).ToString     ...Show All

• .NET Development What is the difference between AppDomain.CreateInstanceFrom and AppDomain.CreateInstanceFromAndUnwrap ?

  I'm new to appdomain programming and I have no experience with COM+. Could you please tell me what "unwrap" is Thank you very much. From the MSDN documentation for ObjectHandle: "The ObjectHandle class is used to pass an object (in a wrapped state) between multiple application domains without loading the metadata for the wrapped object in each AppDomain through which the ObjectHandle travels. Thus, the ObjectHandle class gives the caller control of when the Type of the remote object is loaded into a domain." ...Show All

• .NET Development Creating List<> at runtime

  I am trying to create a List<> at runtime as the type of the list is known only at runtime. I am unable to use a typeof() or TYPE within List<>. I understand that it is meant for a StronglyType scenario but i was wondering if it can be done in any way Thanks Suraj Guptha wrote: I am trying to create a List<> at runtime as the type of the list is known only at runtime. I am unable to use a typeof() or TYPE within List<>. I understand that it is meant for a StronglyType scenario but i was wondering if it can be done in any way Thanks If you don't know the type you can't create a List<> variable to directly use the List<> methods. It kinda defeats the purpose of generics; b ...Show All

• SQL Server Granting UPDATE for only certain columns in a table

  I have tried using the SQL statement shown below to grant UPDATE permissions for a single column in a single table to a user with db_datareader privileges. grant update (col_1 ) on trs . dbo.table_1 to calc When I then run a SQL script that has an UPDATE for col_1 on trs.dbo.table_1, I get an error message Msg 230, Level 14, State 1, Line 2100 UPDATE permission denied on column 'col_2' of object 'table_1', database 'TRS', schema 'dbo'. Why is the error message referring to "col_2" when my SQL statement is trying to update "col_1" When I performed the "grant" I did it with an account that has db_owner, db_securityadmin, and db_ddladmin privileges. This worked in SQL Server 20 ...Show All

• Visual Studio Team System publish permissions full control for share?

  Why does one need full control share permission to publish test results to the build server I would thing that "change" share permissions would suffice. Hi Jason, Sorry for not being clear in my last answer. Users not only publish (write) and view results (read) in a TFS server, but they can also delete, and full control makes all these options possible. Thanks, David Gorena Elizondo [MSFT] VSTS ...Show All

• Windows Forms DataGridView Row Selector box - can it be hidden?

  I have a DataGridView set up in read-only mode such that clicking a cell causes the complete row to be selected. Is there some way to hide the row selector column that is shown in the far left column of the grid I don't need it and would like to hide it, or set it's width to 0. Thanks, Al G. ITJ wrote: This helped me, but its a shame it is so poorly named, don't you think thanks, anyway i agree... i also spent a fair amount of time trying to find this property to remove Row Selector column. thanks also! ...Show All

• Visual Studio Life without source safe?

  I have used source safe in the past and it was very helpful. I don't have a copy of it in the place i work right now. It's going to be a while before we get that in. I just want to know that if 2 developers work on the same project (saved at a shared location) and ALWAYS work in different forms. Will this cause any problems Thanks for your time!! VSS 2005 uses the same diff/merge engine as TFS...and it also supports 3rd-party merge tools using the exact same syntax as seen here: http://blogs.msdn.com/jmanning/articles/535573.aspx ...Show All

• Visual Basic Global Declaration

  hi, generally we'll declare global variables to b used in all forms of our Proj.,in a Module. bt hw do declare global nos. that is.,95 for freight. 69 for discount. even though i'll b using only in Invoice,as new schemes hav to b added in future i cant giv in the Invoice form codings.i need to add separately. Help me.... These globals you refer to are called constants - the values do not change. Public Const Discount As Integer = 69 Public Const Frieght As Integer = 95 However you could also define these in some form of enumeration Public Enum ItemCodes Discount = 69 Freight = 95 End Enum This may be useful if they are related - say if they are all different line Item type codes. You can simply refer to ...Show All

• SQL Server Sql Server 2005 and Sql Server 2005 Express Edition

  I have Sql Server 2005 and Reporting Services 2005 installed in my machine. Can I install besides this products Sql Server 2005 Express and Reporting Services 2005 Express. Can they be both in the same machine Will I get any problem doing this Thanks, Marco Yes, both the Engine, Reporting Services, and Analysis Services are instance aware components, thus you can install them more than once on the same machine without any problems, as long as you give them a distinct instance name. Integration Services, Notification Services, and client components (tools) are the opposite. They can only have one copy per machine. Thanks, Sam Lester (MSFT) ...Show All

• Visual Studio Express Editions NullReferenceException was unhandled

  Hello, I am having a problem with a NullReferenceException problem, in the following code: Private Shared completedTrialQueue As ArrayList .... .... Private Sub saveTrialImages( ByVal t As Trial, ByRef timestamps As ArrayList, ByRef results As ArrayList) If Not (threadImage.IsBusy) Then threadImage.RunWorkerAsync( New Object () {t, timestamps, results}) Else If Not (t.Equals( Nothing )) Then completedTrialQueue.Add(t) 'Error occurs here' End If End If End Sub I explicitly check that t is not Null and yet it returns that (i believe) t is null the next line. I am trying to save images to the hard drive and if the last batch has not been saved then I ...Show All

• .NET Development Web Service Input Always 0

  Ok, i am basically just trying to create a very simple web service in C# and consume it with an application written in Delphi. The problem is that for some reason, the web service always receives a 0 for the integer input no matter what i send it. I have accessed services on the net correctly, but mine seems to not want to work. Here is an example: using System; using System.Web; using System.Web.Services; using System.Web.Services.Protocols; [WebService(Namespace = "tony")] [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)] public class Service : System.Web.Services.WebService { public Service () { //Uncomment the following line if using designed components //InitializeComponent(); } [WebMethod(Descripti ...Show All

• Visual Studio Express Editions accessing file on disk

  I want to access file on disk without getting it onto ram. i guess i'll hv to get it on virual memory and do it. Am i right if yes how do i do that language preffered: c# or c++ The mapped view of file is fixed size, the only way to change it is to remap a view of the file by calling UnmapViewOfFile and MapViewOfView with the new size. I'm not sure that using mapped files is a good idea for your project. While you can always read a specific portion of a file by using normal file I/O (ReadFile, fread etc.) with memory mapped files there are some restrictions. The main one in this case is that the offset in file where a view can start must be a multiple of system allocation granularity which on current systems is 65536. This basic ...Show All

• Software Development for Windows Vista How to get Replicator data in Parallel

  When using a replicator with replicatorActivity1.ExecutionType = ExecutionType .Sequence; I can query the replicator data for the current executing activity in this way replicatorActivity1.CurrentChildData[ replicatorActivity1.CurrentIndex] When using replicatorActivity1.ExecutionType = ExecutionType .Parallel; replicatorActivity1.CurrentIndex is always the last index ( the replicator InitialChildData collection length -1) The question is: How can I query for the current data instance of a replicator in an activity that is running under the Parallel ExecutionType. Thanks in advance Hi angel, thanks for your time I don't want to predict the o ...Show All

• Smart Device Development Problem when creating a menu bar in WM 5.0 smartphone

  Hi, I was trying to use VC++ VS 2005 to create a menu bar in a modal dialog box. I am using DialogBox() function to create. And in the WM_INITDIALOG: I used SHCreateMenuBar() to do the creation for menubar. But I got a "false" return value, and also, in SDK, I found: If the specification passed to SHCreateMenuBar function contains images or more than 2 top level menu items, the behavior is as follows. SHCreateMenuBar will fail for a Windows Mobile 5.0-based Smartphone I dont quite get what this means, it means we can't use SHCreateMenuBar to create the Menubar in WM5.0 Smartphone If we can't is there anyway we can create a menu bar in WM 5.0 Smartphone platform Thanks a lot! Hi It is possible to create men ...Show All