Fiander's Q&A profile

• SQL Server SQL INSERT SELECT 2005

  With the statment below--I get a error message: INSERT INTO [SPIResConv5].[dbo].[Transactions] ([TRXNO], [RESORT_ID] ,[TRANSTYPE_ID] ,[BILLCODE_ID] ,[MAINTENANCE_ID] ,[CONTACT_ID] ,[POSTED] ,[DATE] ,[USER_ID] ,[BATCH] ,[TYPE] ,[AMOUNT] ,[PAYMENTCODE_ID] ,[BANKCODE_ID] ,[DOCNO] ,[Shift4Trx] ) Select c.cnt + row_number() over (partition by t.resort_id order by t.resort_id, t.contact_id) as trxno, t.Resort_ID, TRANSTYPE_ID, BILLCODE_ID, MAINTENANCE_ID, Contact_ID, Posted, Date, [USER_ID], BATCH, [Type], Amount, PAYMENTCODE_ID, BANKCODE_ID, DOCNO, [Shift4Trx] from TransactionsTemp t left join (select Resort_ID, count(*) as cnt ...Show All

• Visual Studio Team System Problem on TFS Installation

  Dear all, i tried to install TFS after installing SQL SP1 with latest hotfixes,the problem is the TFS health checker failed on testing my machine because of i didn't install the latest KB update for SQL 2005,the problem is the KB update which is exist on the TFS Installation DVD is not newer than what i installed from MS Site. TFS Installation DVD contains KB update : AS2005-KB914595-x86-ENU.exe the latest hotfix from MS site is : as2005-kb918222-x86-enu.exe the URL for the latest commulative hotfixes is : http://support.microsoft.com/ id=918222 i think the solution is the TFS installation is looking form the older version which is in the installation DVD. i really want to fix the compatability problem between the SQL ...Show All

• Windows Forms Terrible, Terrible issue with GridView

  I am trying to update database records via a gridview control. My environment setups is as follows: .NET 2.0 framework IIS 5 MS SQL 8 Visul Studio .NET 2005 Professional Edition I decided to create a dataset from the records I want from the database, filtered with a sql query, and set the datasource of my GridView control to the dataset. The data dispays fine. The SQL query is generated based on the values of some textbox, checkbox and dropdown controls. I have been at this project fr over 48 hours and still I cannot figure out how to update the row from the gridview. Once of the fields in he row contains a guid from the database which I do not want the user to see but I need it to update my record. Please, please please ...Show All

• Visual Basic IRunningObjectTable.Register Example?

  Does anyone have an example of how to register an automation server in the ROT (Runtime Object Table) using IRunningObjectTable.Register and how to revoke it using IRunningObjectTable.Revoke Thanks, You're probably right about .Net 2.0. That seems like the only difference. One more question... Will this work equally well with VB Are there any differences (other than the obvious syntax, of course) in doing this in VB vs C# Thanks, ...Show All

• SQL Server Fortnight Date Dimension in AS2000

  I am new to AS and currently using SQL Server 2000 (upgrading soon). I need to provide information using fortnightly dates. Ie, the user should be able to see data for a specific fortnight beginning (or ending) date. Fortnights always start on a Sunday and finish on a Saturday 2 weeks later. I can write a stored procedure to identify the fortnight start or ending date based on an input date, but how do I call this from AS (as a calculated member ) so that it can be drilled down to within a Time dimension Assuming that you already have a date dimension table for the Time dimension, you could create a User-Defined Function (UDF) like udf_fortnight(@InputDate datetime), which can be used to add a fortnight f ...Show All

• Visual Basic ongoing problem........

  Hi!! i've had an issue with my listbox for the past few days. im a complete novice in vb.net so learning as much as i can as i go on. basically i have populated my listbox with data from my database. on listbox.selecteditem, i want the info to go into separate textboxes. so on rumtime it appears - name, address1, address1, address3, postcode, phone. on listbox.selecteditem i want it to: textbox1= name textbox2=address1, address1, address3 textbox3=postcode textbox4=phone 'declare sql connection Imports System.Data Imports System.Data.SqlClient Public Class AddressBook 'connection via IP address Dim conStr As String = "Data Source=................;" Dim conClass As S ...Show All

• Microsoft ISV Community Center Forums ListBox Controls in Access 2000

  I have a listbox control on a form, which is bound to an employees table. Basically, the user can select 1 or more employees from the list and perform certain actions on them. This is all hunky dory. However, when I close the form and re-open it, the list box scroll position is where I last left it, rather than being at the top of the list. Is there any property that can effectively reset the listbox so it always displays from the top The ListIndex property looked like a potential candidate, but it's read only. Many thanks! Keith ...Show All

• .NET Development Reading streaming data from SerialPort

  Hi, I new to C#, but i need to developed data collection GUI for my company and im playing with the SerialPort class.   My problem is that i cannot read anything from it. This is my setup. Using 1 computer, i have various pairs of VIRTUAL Serial Ports, those pairs create a loopback. Lets say i open one instance of HyperTerminal with Com 4 and another with COM5, whatever i type appers in the other so the loopback works.   My GUI is very simple now, 2 comboBoxes, 2 textboxs, and 2 buttons. User picks the send and the receive port in the comboboxes ( 4 and 5 ). Textbox 1 has string to be sent and textbox2 SHOULD receive the same string. buttons are Send ( to send textbox1 string, and READ to read the buffer f ...Show All

• .NET Development Remoting application error: "This function must be called in the default domain"

  I have a remoting application under the hood is mostly unmanaged code. We have created a managed wrapper ontop of our unmanaged classes. These classes then make a transition back into a managed context to do some additional work. These additional classes are written in C++/CLI and some of them have functions that look similair to this. const CMyClass& CTest::Test(USHORT n) { static const CMyClass dbEmpty; //We end up return ALOT of these so we want to only create it once if (someconition) { return CMyClass(aaa); } return dbEmtpy; } When we enter one of these function we will always hit the following assert in _atexit_m defined in msilexit.cpp (Entire function at the end of post). MANAGED_ASSERT(AppDomain::CurrentDomai ...Show All

• SQL Server Internet Explorer Version 7.0 Beta 3 can not load Reporting Services

  Hi, all! Internet Explorer Version 7.0 Beta 3 can not load Reporting Services, please check this error. Because my company always using Reporting Services. I open report OK but when choose and click View Report. Nothing load and IE 7 using a lots resource RAM. And I check many computer set up IE 7. they still error. Please help me. Thanks. http://blogs.msdn.com/bwelcker/archive/2006/08/28/728739.aspx ...Show All

• Windows Search Technologies Should SMPFilter IFilter example from Platform SDK work with WDS 3.0?

  Hi Guys, I have recently built the SMPFilter sample IFilter from the Platform SDK and installed it on a system running WDS 3.0. (This sample filter indexes ".smp" files, treating them as text). However WDS 3.0 never successfully finds anything in any of my .smp files, although apparently the files are being indexed. My questions : (1) is the SMPFilter sample supposed to work under WDS 3.0. (2) if the answer to (1) is "Yes" then what else can I do to find out what is going wrong on my system. If the answer to (1) is "No" then where can I look to find sample IFilter source that works under WDS 3.0. (My objective is to write my own IFilter, and I using the SMPFilter as a guide). Additional Details : - I believe ...Show All

• Visual Studio Tools for Office Multi-threading in VSTO

  I have read throught many texts and i am not able to get to a conclusion. I have an excel application. The application queries various tables. After data is obtained through each table it is processes. Doing everything serially takes a lot of time. Is there any way i can put each task on a separate thread. None of the threads will be calling the Excel COM server. The tasks will perform data access/processing operations and once all the threads are done, the MAIN thread will do the writing on the workbook. In other words "Is is possible to do multi threading in VSTO solutions, assuming that threads won't interact with the office object" Thanks1!! Hi, The Windows Forms team did the world no ...Show All

• Visual Studio Contacting the VS SDK Team??

  Hello, the company I work for saw some of the personal coding that I had done for plugins into Visual Studio and are interested in possibly persuing some SDK development as a company project. However, when they saw that an individual had to sign up to a Passport account that has personal liability to the individual in the terms of use of the Passport account and couldn't sign in as the company they had some questions. Does anyone have an email address of a contact that I would be able to pass on to my company's legal department Or is there anyway to gain access to the VSIP sites and sign up without a passport account The agreement is between the person who created the Passport and Microsoft. It d ...Show All

• .NET Development FTP w CF 2.0

  Hi all, I am getting an odd error during an FTP. It happens completely randomly. I can sometimes ftp 50 files with no error, and other times 2 errors in a row with the same files. This machine can FTP via CF 1.1 without error as well as with any other FTP method I have tried. Like I said it only happens with the 2.0 and I am at a loss. Any ideas Here is the error; System.Net.WebException: The remote server returned an error: (501) Syntax error in parameters or arguments. at System.Net.FtpWebRequest.SyncRequestCallback(Object obj) at System.Net.FtpWebRequest.RequestCallback(Object obj) at System.Net.CommandStream.Abort(Exception e) at System.Net.FtpWebRequest.FinishRequestStage(RequestStage stage) at System.Net.FtpW ...Show All

• Smart Device Development Web service is very slow in device

  Hi, We have Window CE application in Device which sends some datas and signature (in byte format) to the server machine. Currently we are using web service to transfer the datas from the device to server machine using GPRS connection. It is very very slow and even sometime we get error while acessing the Web service. Is any other way to updated the datas in the server instead of using web service or any other options. Device Details : BlueBird BIP 3010. OS: Windows CE 4.2 Server Details: IIS 5.1 SQL Server 2000. Check this article, especially the chapter 'Building Interactive Server Components'. http://msdn.microsoft.com/library/default.asp url=/library/en-us/dnnetcomp/html/httpcomm.asp I built a GPRS applicati ...Show All