Albert Dillon's Q&A profile

• SQL Server Dataset Results

  I have created adataset to make a drop down list for a parameter. As shown: SELECT distinct [Table] FROM [Database] The results i get back are A, B & C. What i am trying to do is show a result as a different word. i.e instead of displaying A is shows in drop down list as Apple, B shows Banana. etc. Can anyone help please. Thanks Ok got it working. select distinct case [COLUMN NAME] when 'A' then 'Apple' when 'B' then 'Banana' else 'Unknown' end from [TABLE NAME] where [COLUMN NAME] in ( 'A' , 'B' , 'C' ) ...Show All

• Visual Studio 2008 (Pre-release) Setting Up a Publc MSMQ for access through internet (using NetMsmqBinding)

  Iam trying to setup a public MSMQ between two enterprises so that they can exchange messages. Iam planning to use NetMsmqBinding. Any suggestions or recommendations to consider. Thanks, T.Ramesh. Setting QueueTransferProtocol to Srmp (or SrmpSecure) is enough to trigger MSMQ over HTTP in WCF. This is supported on Vista (MSMQ 4.0) and Windows XP / Windows Server 2003 (MSMQ 3.0). Internally WCF will convert your Uri to the MSMQ HTTP direct format name: net.msmq://machine.domain.com/private/queue -> Formatname:DIRECT=http://machine.domain.com/msmq/private$/queue ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Bad Lines Appear with Sprite.Draw with Redist. but not with SDK

  Hello Everyone, I am working on an isometric game pseudo 3D but using Direct3D. Primarily I am using one call to draw everything... (Sprite.Draw). Infact I even use only one sprite to draw all the images to the screen and have written all other collision detection and transforms myself using surface level operations... The only real hardware accelerated feature I am taking advantage of is color and alpha blending. Everything has been going fantastic and I am getting ready for a preview release in a few weeks but then I decided to test it on two more machines to make sure everything worked. Almost everything did... but some images are not being drawn to the screen correctly they will have shaded lines under or around them that were no ...Show All

• Visual Studio Team System Migrating Visual C# .net from Visual Studio 2002 to Visual Studio 2003?

  I have 2 Visual Studio installations: Visual Studio 2002 using .net framework 1.0 with Visual C# installed and Visual Studio 2003 using .net framework 1.1 with Visual Basic .net installed. Is their a way to intergrate both Compilers to the Visual Studio 2003 and .net framework http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=90922&SiteID=1 ...Show All

• SQL Server execute sql task resultset

  hi all, in my execute sql task, i have a try catch statement to catch error code if there's an error... begin try insert into person.contact (contactid) values ('1') end try begin catch select @@error as ErrorCode end catch this ErrorCode will be mapped to a user variable. my problem is the value for ResultSet. in order to assign ErrorCode to the variable, i have to set the ResultSet value to Single row, but if this task does not fail, i need to set ResultSet value to None in order for it to run successfully. How do i go about solving this problem Please help. thanks! Well, I am not quite sure, but I think when you don't use the try....catch and a error occurs; the variable will ...Show All

• Smart Device Development app won't exit when main form closed

  CF 2.0, VB 2005 I have a forms app with a login form which is closed before the main dashboard form appears using application.run(dashboard) The problem I have is when the user closes the dashboard form the app won't exit (the form dissapears but the vb 2005 debug session stays running). I don't have any other forms loaded. Please help. Cheers, Kenny. it's ok I've sorted it - it was to do with the smart minimize feature. I changed the 'minimizebox' property on the form to false and it's ok now. ...Show All

• Visual FoxPro using tow field index with codebase

  Hi, I'm using codebase to create table and index and i use VFP 9.0 to open the table and execute querys. when i'm creating an index for one feild : "CREATE INDEX ind ON person(age)" every thing works fine and there the index is working well. when i'm creating an index for two fields or more: "CREATE INDEX ind ON person(age,name)" VFP cant open the table. what seems to be the problem thanks ishay I opened the database created with vfp 7 and I used the option export to (from file menu tab), to change format in foxbase+ (it was the only format who worked). I re-create a new cdx index file (compound index file).I did not spent to much time with this because I was ...Show All

• Visual Studio Team System TF30162: Fails portal creation when creating Team Project

  Attempting to create a new Team Project gives the following error. We're using the release version of TFS and MSF for Agile template. Following the instructions in another thread: https://forums.microsoft.com/MSDN/ShowPost.aspx PostID=150809&SiteID=1&mode=1 I think I've been able to find the issue. When I try to add a top level site to the "Default Web Site", I get an error that says: "The virtual server that is referenced here is not in the config database." Anyone have an idea what I'm missing here I do find the server in the STS_CONFIG_TFS database in Servers and VirtualServers. 2007-02-19 08:32:58Z | Module: Internal | Team Foundation Server proxy retrieved | Completion time: 0 seconds 2007-02-19 08:32:59 ...Show All

• Visual Studio Tools for Office Reading Excel From C#

  You can read data from Excel using the JET OLEDB provider. See the URL below for the necessary connection string, and a link to a KB article with further information ... http://www.carlprothman.net/Default.aspx tabid=87#OLEDBProviderForMicrosoftJetExcel -- Brendan Reynolds wrote in message news:9226766e-a1d5-400c-8d3c-8ffc566bec50@discussions.microsoft.com... > Hi > > Can anyone help me how to read values in Excel in C# . So that Once I > read I can send them to DataBase. My excel file Test.xls in ("C:\") > > Thanks > Doss > His Doss, Create a reference in your project to Excel Objects Library.  The excel object library can be added in the COM tab of adding reference d ...Show All

• Smart Device Development time function

  Hi, I'm new to C++ and I am writing a project in it that I want to build on both Windows CE and VxWorks, so I am compiling the project in both MS Visual Studio and Wind River Workbench. There are a number of places in the app where I want to get the current date and time (number of seconds since 1/1/1970) but I can't figure out how to make it work! From what I can tell, time(time_t * timer) is the way to go, but while this compiles fine for VxWorks, when I compile it for Windows I get a strange linker error which says that there are unresolved externals in the function that contains the call to time(). Help! (Thanks in advance!) Rachel I am using the VS2005 time.h header file. But if it is POSIX-c ...Show All

• SQL Server Changing column length of a replicated table

  Can I increase the length of a varchar column of table involved in transactional replication without dropping and recreating publication/subscription Any help/short-cuts/undocumented features greatly appreciated. Regards Opal Sorry there is no easy workaround in SQL Server 2000. The only alternative is that you can use sp_repldropcolumn then sp_repladdcolumn to drop and re-create the column, but that way you will lose all the data for that column. Thanks, Zhiqiang Feng ...Show All

• SQL Server script to take backup of a database

  Hi, I am trying to create a script that takes backup of a sql database. The script is failing with message "backup failed with message..." Option Explicit Dim server Dim backup Set server = CreateObject( "Microsoft.SQLServer.Management.SMO.Server" ) Set backup = CreateObject( "Microsoft.SQLServer.Management.SMO.Backup" ) backup.Action = 0 backup.Database = "test_old" backup.SqlBackup(server) I think this is failing because i did not specify the backup file name. Can u please let me know how can i specify it Also it would be great if you can point me to some relevant documentation which shows how to use SMO with vb script. Regards Aseem Bansal ...Show All

• .NET Development Update Command and the use of IsDBNull!! ???

  Hi all. I have a number of records in an access db and would like to update various rows by using one sql statement.  I would like to replace an empty field with a set value but do not know the correct wording, or functions.  For example: sql = "Update SourceTable set EmptyFieldName = '" & strNewValue & "' Where IsDBNull(EmptyFieldName)" As a work around I have had to do this: Dim Adap As New OleDbDataAdapter("Select * from SourceTable Order By EmptyFieldName", Cn) Dim Dataset1 As New DataSet() Dim DView As New DataView() Adap.Fill(Dataset1) DView.Table = Dataset1.Tables(0) If Dataset1.Tables(0).Rows.Count > 0 Then Dim RowView As DataRowView Dim I As ...Show All

• Windows Forms update code works for modify but not add new

  I have these 2 lines of code for both saving new record and modifying existing record,             this.staffBindingSource.EndEdit();             this.staffTableAdapter.Update(this.hPMDataSet.staff); however, it only works for modifying new record, but not saving the new record, seems that it does update the actual database for the changes made to existing records, but doesn't update database with the new record. please help well, i have 2 buttons, "add new" and "save" buttonAddNew has code " this.staffBindingSource.AddNew(); " buttonSave has those 2 lines of code. btw, i set my d ...Show All

• Visual FoxPro help? textbox

  Hi I am new to vfp and my syntax knowledge is not very good actually its quite bad. I was wondering. How do you recieve user's input through a keyboard in a textbox (cmdtxtbox) and then use that input and save it as a variable (userInput) Thanx for the help Bobby Bobby110uk wrote: I am new to vfp and my syntax knowledge is not very good actually its quite bad. Then I suggest that you go to http://www.hentzenwerke.com/catalog/fund6.htm and grab a copy of Fundamentals: Building Visual Studio Applications on a Visual FoxPro 6.0 Foundation. It will help with your learning curve. ...Show All