Randy Young's Q&A profile

• SQL Server CLR Trigger

  Hi,       I want to call webservice in the Trigger.  How to call the webservice from CLR Triggers .If anybody knows teh detail let me know.   And i worked out  the following Example code for CLR Trigger. using System.Data; using System.Collections.Generic; using System.Text; using System.Data.Sql; using System.Data.SqlTypes; using System.Data.SqlServer; namespace CLR {     public class Class1     {         public static void InsertTrigger()         {  &nbs ...Show All

• Smart Device Development Webbrowser Control - .net cf 2.0

  Hello, I’m having a problem with an application i’ve been developing with VS.NET 2005 beta 2 and currently being developed under VS.NET 2005 Professional Edition (both with Windows Mobile 5.0 SDK). Compact framework 2.0 seems to have some differences between its beta 2. Now, links ("<a>") on the webbrowser control don’t work anymore with my pocket pc 2003 device. I don’t even get the navigating event (it does work on emulator on windows mobile 5.0). It seems WebBrowser is validating the href input since my href is a number. I tried using http:// and file:// and it did work with valid files/urls only. I want to use numbers only (no http ...Show All

• SQL Server Extracting month, day, year from dates

  I need help in building a Select statement for an ODBC connection to an AS400 DB2 system. I am using this Select statement for SQL Reporting Services. Unfortunately 15 years ago one of the main datatables on the AS400 was set up splitting the transaction date into THREE FIELDS! One for Month, one for Day and then one for Year. I need to take yesterday's date and somehow use this in my WHERE statement to connect the transaction records that are in this AS400 table. This is what I have now that is not working: WHERE QS36F.BRDMST."BREED#" = QS36F.DOGOWNR.BRDCOD AND (QS36F.DOGOWNR.TMONTH = "MONTH"(GETDATE() ) AND ( ...Show All

• Visual Studio 2008 (Pre-release) Repeate Count in the MediaElement tag

  I'm using the MediaElement tag to play a video, in previous releases I used the RepeateCount property to keep the video playing, but some how I can't find it or any related properties in the Decemeber CTP. in the December CTP you need to trap the MediaEnded event of the MediaPlayer, and in the handler, do the following: media.Stop(); media.Position = TimeSpan.Zero; media.Play(); ...Show All

• Visual C++ Linking the microsoft platform SDK to VS 2005 express

  Hi, i have read through various threads regarding methods to link the microsoft platform SDK to visual studio 2005 express beta 2. Personally i have tried changing the express.dll.config file to "C:\Program Files\Microsoft Visual Studio 8\..." where I include the path to where my microsoft platform SDK is located. Well that doesnt work. So i tried the "create a PlatformSDK folder under VC folder" method. N ow afxwin.h is located in C:\microsoft platform SDK\include\mfc so basically i changed the folder name to PlatformSDK and put it in the VC folder. Well that didn't work as well. What happened is i will still receive an error message saying ...Show All

• Visual C# How to encrypt a string in C#

  Specifically, I want the encrypted string to contain only numbers and letters (no special characters). Thank you! It's not encryption, but a way to get rid of special characters: string s = "Foo bar"; string s1 = Convert.ToBase64String(Encoding.Unicode.GetBytes(s)); ' And back... string s2 = Encoding.Unicode.GetString(Convert.FromBase64String(s1));   ...Show All

• .NET Development Remoting Events Sample

  Hello, I have a sample project that uses remoting and events to inform clients of data changes. It works with the .NET Framework 1.1 but not with 2.0. Can someone please help I wasn't able to post the zip with the project, I can send it to you. Thanks. Reese What error messages are you getting If they're "System.Security.SecurityException" or "System.Runtime.Serialization.SerializationException", check the TypeFilterLevel and change it to "Full", if applicable. I had a similar problem and re-reading IngoRammer's RemotingFAQ helped isolate problem. General guidelines when remoting events: ...Show All

• SQL Server Script generation for Objects - Management Studio

  How do I generate a single script for each object - table, view, index, trigger, sp, function etc.... in SQL Server. The script that is generated from SQL Server wizards is in a single file. I want to have separate file for each of the objects. In EM, you right-click on the object, select 'all tasks', then 'Generate SQL Script'. I do not have access to Management Studio right now, so this may or may not be much help. Do you have access to Enterprise Manager You can run SQL Server 2000 and 2005 side by side, so it may be worthwhile installing if you cannot do this in MS. Clarity Consulting ( http:// ...Show All

• Visual C# Where can I find good tutorials in creating user controls in win forms?

  I can't find anything in my search.. i found one @ FirstControl ...Show All

• SQL Server Changing SQL-command with a script

  Hello I want to change the sql-command that is behind a ole db datasource with a script So that first the script is run and that the sql-command is changed Somebody who has any idea You cannot access object or change their properties from Script in SSIS, a somewhat dramatic change from DTS. First choice would be to use an Property Expression on the SqlCommand property, but unfortunately this property has not been exposed as an expression. Next choice would be to use the "SQL Command from variable". You can use a script to set the variable, and the source can be set to use that variable, so job done. I woud ...Show All

• SQL Server Remove rtf code from text

  Hi guys, here I am again, Now with a different question. I succesfully converted the binary code to plain text. The text however was put into the database as RTF. Can anyone tell me how to remove the RTF code from the plain text. Thanx Gabs This will be not too simple ;) First of all read: http://www.c-sharpcorner.com/Code/2005/June/CustomAssemblyinRS.asp This is for RS2000, but works for RS2005 also. What you have to do: -Create a class library project (I used vb.net express) -Add a reference to System.Windows.Forms -paste the following code: Public Class General Public Shared Function stripRTF(ByVa ...Show All

• Visual Studio Team System Still Error 32000 Report Server although browsing works

  I am trying to install this now for days and it still does not work. Browsing Reports and ReportServer is working, AppPool Settings are different from sharepoint and excluding ReportServer is done. Error: Error 32000.The Commandline '"C:\Program Files\Microsoft Visual Studio 2005 Enterprise Server\BISIISDIR\uninstall\createds.exe" " http://VSTEAMSRV1/ReportServer/ReportService.asmx " TfsReportDS "Data source=VSTEAMSRV1;initial catalog=BisDWDB" "NGROUP\administrator" "01000000d08c9ddf0115d1118c7a00c04fc297eb01000000f1c8b0bd1425fe418b0f966dc2bc369300000000220000005500730065007200200049006e0066006f0072006d006100740069006f006e00000003660000a8000 ...Show All

• Visual C# Visual C# Look and Feel nice in XP, ordinary in 2000, why?

  Hi, I downloaded and am running Visual C# Express on my Windows 2000 machine. At first, I was slightly taken aback by the clumsy, clunky look of some of the dialogs in the IDE itself. That is, some of the buttons were strangely large and the size of some dialogs just didn't come anywhere near the professional, smart look of say, Office 2000. For example the "Edit Rows and Columns..." dialog if you right-click on a TableLayout panel. I'm not being picky here, I'll send a screenshot when I get home - it looks quite unproportioned and particularly ugly ;-) I have 1152x864 resolution. I was guessing that it was something to do with the ...Show All

• Visual FoxPro Additional fields in table exported to txt

  Hello, I need to output from a VFP 6 table to a text file. When I use "copy to mytext.txt delimited with ," I get an additional field before and after each of the original fields from the table. This means that in my new text file, fields 1,3,4,6,7,9,10,12,13 etc are empty fields that were not present in the table and fields 2,5,8,11,14 etc are the fields with data. Can anyone tell me how to avoid these "extra" fields please Thanks in advance, Paul. It sounds Like ypu want as CSV File... Why not use " copy to mytext.txt type csv " Dave ...Show All

• Visual Studio Express Editions Visual C++ 2005 Express Edition with OpenGL -- Can't get started

  I'd like to get started using OpenGL with Visual C++ 2005 Express Edition. I've installed VC++ and the PSDK. I've tried to start a new Win32 application, and here's the exent of my code: // OpenGL Stuff 2.cpp : Defines the entry point for the console application. // #include "stdafx.h" #include <GL/gl.h> int _tmain( int argc, _TCHAR* argv[]) { return 0; } The error returned when I try to "Build -> Build OpenGL Stuff 2" is as follows: c:\documents and settings\mfunke\my documents\visual studio 2005\projects\opengl stuff 2\opengl stuff 2\opengl stuff 2.cpp(5) : fatal error C1 ...Show All