Marlon Smith's Q&A profile
Windows Forms MIME settings
Hi, I want to deploy a ClickOnce application through my site. The site is hosted at a web hosting company and I want to ask them to set up the MIME type for .application, .manifest and .deploy extensions. The problem is I coudn't find exactly what are the required MIME settings for these extensions in Beta 2. From the documentation it seems: .application -> application/x-ms-application .manifest -> application/x-ms-application .deploy -> application/octet-stream Can somebody confirm this Regards, Valentin Iliescu It should be the following (according to the MSDN Library ): File name extension Content type .application application/x-ms-application .manifest applicati ...Show All
Windows Live Developer Forums BUG: GetRoute - VEDistanceUnit is forgotton if select placename dialog is shown.
When the VEDistanceUnit is Kilometers this is not remenbered. Example: <html> <head> <title></title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <script src=" http://dev.virtualearth.net/mapcontrol/v4/mapcontrol.js"></script > <script> var map = null; function GetMap() { map = new VEMap('myMap'); map.LoadMap(); map.GetRoute('EAUZE, France', 'Panjas, Gers, France', VEDistanceUnit.Kilometers, null, onGotRoute); } function onGotRoute(route) { var routeinfo="Route info:\n\n"; routeinfo+="Total distance: " ...Show All
SQL Server Inserting Values to Identity column.
Hi all, I have a Table Which only have one column, and that column is also an Identity column. Does anybody know how to insert values to this table. I know that if I change the table and add another column I can solve this problem. But because I can't change the of the Database design provided to me by my architect, I have to find a solution for this. Please help me...... Regards, Sandarenu you could use the statement "SET IDENTITY_INSERT ON" before the insert statement. you can read about the usage from books online ...Show All
Visual Studio Team System rig testing and a dedicated PC
My rig test contains both an upload test and a menu test. I would like to use a dedicated PC to only run the upload test and use the other rigs to run the menu test. Is it possible to configure the rig test to do so Yes I do like to have two agents running my two tests. One of these agents must always run the upload test. In the Administrator Test Controller - Agents I select the Agent name that should run the upload test. In the properties of this Agent I add an Attribute Name - Attribute Value pair. (e.g. aName - aValue) Then in the localtestrun.testrunconfig file - Controller and Agent - Name Value box I use the same aName - aValue as name-value pair. This seems to work fine: the upload test ...Show All
Visual Studio 2008 (Pre-release) ArgumentOutOfRangeException in SubmitChanges
Hi, I receive the following exception when trying to submit changes made in a database backed class. Test method UserManagerTest.MyTest threw exception: System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index. at System.Collections.BitArray.Get(Int32 index) at System.Data.DLinq.SimpleTrackedObject.HasChanged(MetaDataMember mm) in C:\Program Files\LINQ Preview\Bin\Disasm\System.Data.DLinq.il:line 106219 at System.Data.DLinq.SimpleTrackedObject.<GetDataChanges>d__0.MoveNext() in C:\Program Files\LINQ Preview\Bin\Disasm\System.Data.DLinq.il:line 105226 at System.Data.DLinq.SimpleChangeDirector.GetUpdateCommand(TrackedObject tracked) in ...Show All
SQL Server using Output clause and return timestamp and return value
I am trying to bring my stored proc's into the 21st century with try catch and the output clause. In the past I have returned info like the new timestamp, the new identity (if an insert sproc), username with output params and a return value as well. I have checked if error is a concurrency violation(I check if @@rowcount is 0 and if so my return value is a special number.) I have used the old goto method for trapping errors committing or rolling back the transaction. Now I want to use the try,catch with transactions. This is easy enough but how do I do what I had done before I get an error returning the new timestamp in the Output clause (tstamp is my timestamp field -- so I am using inserted.tstamp). Plus how do I check for co ...Show All
Visual FoxPro FORM HELP
HI I AM A NEW IN THE VFP SO PLEASE HELP ME OUT I AM CREATING A NEW PROJECT FOR INVOICE AND IN THAT I HAVE TWO TABLES ONE FOR COUSTMER INFORMATION AND THE 2ND FOR "ORDER DETAILS" BUT I NEED THIS ALL IN ONE FORM WHICH I HAVE DONE BUT AS I AM TRYING TO ADD ROWS ITS NOT LETTING ME IN THE "ORDER DETAILS " GRID. I ALSO WANT TO ADD THE CALCULATOR AND A CALENDER IN THE SAME FORM. NILKAMAL THANKS FOR THE QUICK REPLY BUT IT STILL NOT WORKING AS IN THE GRID BUT IT IS STILL NOT LETTING ME ADD ANOTHER ROW IN THE GRID AND ALSO WHEN I ADD A NEW RECORD A POP-UP WINDOW COMES UP WITH FOUR OPTIONS : 1) DO YOU WANT TO ADD A RECORD IN THE PARENT TABLE ONLY 2) DO YOU WANT TO ADD A RECO ...Show All
SQL Server Can't delete database that has been part of replication
I had a publication (merge) setup for a database. Deleted the publication and tried to delete the database. Sql server says it can't be deleted because it's has replication setup. Bug Found the answer. I had to run a stored procedure to get all replication objects removed from my db. sp_removedbreplication @dbname = 'dbname', @type = 'merge' /Magnus ...Show All
SQL Server Multi-part Identfier could not be found (with SQL Script)
Hi all, I have attached the following script from which the error message come from. Please help me out. use PatientCare go select pr . PatientId , p . FirstName , p . LastName , m . Name from Prescription as pr inner join Patient as p inner join Medicine as m on p . PatientId = pr . PatientId on pr . MedicineCode = m . MedicineCode ; Error message got is as below: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "pr.PatientId" could not be bound. Thanx in advance. Ronald hi ronald looks like you got a syntax error and adamus is right i deleted you other post cause it looks identical to this one ragards ...Show All
Windows Forms DataGridView Dispose Leak?
Hi, 1- When I change the DataSource property to a not null and new DataSet in a loop asking for a new search criteria which searched the databse with the new criteria entered by the user, does the garbage collector disposes the old DataSource(old DataSet containing old search results) of the DataGridView 2- When the DataGridView is disposed, does it also disposes its DataSource Thanks for all the answers from now on. ...Show All
Visual Basic Running isnumeric on array textbox (Help needed)
hi, this is what i wrote : Private sub text1_change(index as integer) Dim A as boolean, b as boolean for index = 0 to 2 if a = true then msgbox "ok", vbok if b = true then a = true if isnumeric(text1(index).text) then b = false else : b = true End if if text1(index).text = "" then b = false End if Next index End sub My form has 3 textboxes in an array. The first box adhere to the above, i.e. when i type numbers in,it is okie, however any alphabets will result in error msg. 2nd and 3rd text boxes however displays an error msg wheneva i type anything in. Is there something wrong in what i have done thanks~!! Rather urgent The only problem with this si ...Show All
SQL Server Easy NOOB question
Hi, I'm trying to pass a parameter into a procedure and not getting the results I want. There's probably better ways to write the procedure, and if you want to suggest one, that's ok, but I'm most interested in just getting the stupid thing to work. I'm trying to search a bit field in a table with the bit field being the parameter that isn't working. In the code I include below, @category is the parameter that isn't working. For this case, "category" is a bit field in a table and I want to be able to pass in different fields and find out if they're set. When I use the parameter @category, the result isn't right. If I hard code the field name (for the case below, "Compensation" is the DB field name), i ...Show All
Software Development for Windows Vista Workflow in MOSS 2007 does not receive event when using MOSS / Sharepoint APIs
I have used the Sharepoint Dersigner to build a workflow and successfully published it to a MOSS 2007 Infopath 2007 forms library. I have a step that waits for a document property to equal a value. When I use the User Interface (edit in data grid or via the InfoPath form itself) to set this property, then the workflow detects the equality and continues the workflow. However, when I use SPFile objects to update the properties (and I can see the property in the forms library is displaying the exact value) the workflow does not proceed. Why is my workflow not detecting a change to this property when done so via SPFile.Update() but does when modified via the UI Since this is a Sharepoint related question, ...Show All
SQL Server Date format - Parameter/Field
Hi, I have some difficulties to format a Date value in my reporting service. As you know you can use this kind of expression: =DateTime.Parse(Parameters!ReportingDate.Value).ToString("dd/MM/yyyy") But it does not work, and when I just want to use the format property of the textbox content such as " dd/MM/yyyy ", it displays "dd/MM/yyyy", not the real formatted data, this property works for " =Today() " but not for parameters and fields. What is the diffrence Have you an idea to format a Parameter/Field of Date type such as dd/MM/yyyy Many thanks! Vin, You can make your parameter of data type DateTime, this would eliminate the need to parse ...Show All
SQL Server Incremental updates query not working for proactive chaching
Hi all, I'm trying to set up Proactive caching on a large dimension with incremental updates. I have read all the info on MSDN and followed what seems like a straight forward process but am still having difficulties. I've enabled proactive caching on the dimension with the following settings... Update the cache when data changes: Silence Interval - 10 secs Silence Override - 10 mins Scheduled Polling: Polling Interval - 10 secs Enabled Incremental Updates - TRUE Polling Query; Select Max (DocumentKey) As MaxDocumentKey From DIMENSION_Documents Processing Query; Select DocumentKey, DocumentBaseTypeName, DocumentTypeNa ...Show All