Tompom's Q&A profile
SQL Server UDF parameter truncated
I have a problem with a NVARCHAR(MAX) parameter being truncated. The signature of the UDF is: [ SqlFunction (FillRowMethodName = "SplitFillRow" ,IsPrecise= true ,IsDeterministic= true , DataAccess = DataAccessKind .None,TableDefinition = "pos INT, token NVARCHAR(10) " )] public static IEnumerable SplitText ( SqlChars input , SqlString strDelimiter) {... and deployed as: CREATE FUNCTION [dbo] . [SplitText] ( @input [nvarchar] ( max ), @strDelimiter [nvarchar] ( 10 )) .... But it is still being truncated to 8000 characters. I tried using a sqlstring or using ([ SqlFacet (MaxSize = -1,IsFixedLength= false )] on the parameter and a bunch of other things, but it is still truncated to ...Show All
Visual Studio 2008 (Pre-release) Changing default editor for XAML
How do I change the default editor for XAML That is I want to edit them with XML editor rather than Cider. Thanks. Right click the the xaml file in the solutions explorer, and select the "Open with" option from the context menu, in the "Open with" dialogue, you can select the XML editor from the list box, and set it as default by pressing the "Set as Default" button in the right side of the pane. Sheva ...Show All
Game Technologies: DirectX, XNA, XACT, etc. Where do I start
Hello fellow gamers, I am the newb next door and I need someone to tell me where to start. Where is the best starting point in the road to a professional game designer Do I start with 2D games Or 3D Simply search the forums for Tutorials for more info and read the XNA docs that came with GSE, the XNA team spent a lot of time getting usfull stuff in there. For 2D start over at http://www.xnaresources.com/blog.asp , good 2D tuts for 3D head over to http://www.riemers.net/eng/Tutorials/xnacsharp.php for 3D tuts. Lots more links on the forums and my blog site (which remind me I have a few more to add) Dave "LetsKillDave" Weller has also posted a humongous link page on his blog whi ...Show All
Windows Forms datagridview
hi, i have a datagridview(vid=sual basic 2005 and sql server 2000 thru dsn im working). i want to 1)display data from a table to datagridview 2) add new rows 3)delete 4)update. i added a datagridview and added 15 columns to that ans set name and columnheader for each. i also want some of the columns to be calender etc...(i added genericdatagrid user control.dll) i have the following code in the form load but no data is coming. can u please help con.ConnectionString = "dsn=alphasql" con.Open() da = New OdbcDataAdapter( "Select * from Company" , con) 'da.SelectCommand = New OdbcCommand("Select * from Company", con) da.Fill(ds, "Company" ) DataGridVi ...Show All
Windows Forms Dataview row Filter issue
When we use something like this to filter the dataview we get some error.....what could be the reason... filter=" [FieldName] LIKE 'adfasdfsd*asdfasdfasd%' "; dataview.RowFilter= filter; Could anyone explain the reason why * char is treat in special manner...... it act as a wild character if we simply do filter=" [FieldName] LIKE '*%' "; dataview.RowFilter= filter; it doesnot display entry starting from * , rather it display all the data without any filter applied. Eagerly waiting for the reason..... Thanks in advance... ok thanks a lot ......it does work placing the * in the [] (Square bracket).. incredible!!!!!!! How to find the string that contains % character within it But to ask you ...Show All
Visual Studio Tools for Office Error when trying to install ClickOnce Application
Howdy, I'm trying to install a clickonce application from IIS on my development machine which has .NET 3.0 installed and VS2k5 sp1 installed. When I navigate to the site and click the Install button I get the download dialog and all is well until I select run from the the setup dialog. I then get the error below: The following error occurred attempting to install 'http://luke/ArlTexAjax/AddressBook.application': "Application not found " I have set the MIME types for .application, .manifest and .deploy extensions. As I was working trying to solve this issue I noticed if I clicked on "launch" link on the installation page, the install is accomplished successfully. It seems as though the setup.exe file ca ...Show All
SQL Server Report Server Windows Service
Hi everyone, I am not able to access my report server. Here is the message i get when i try to configure it. System.InvalidOperationException: Cannot start service ReportServer on computer 'Machine-9JP5R91'. ---> System.ComponentModel.Win32Exception: The service did not start due to a logon failure --- End of inner exception stack trace --- at System.ServiceProcess.ServiceController.Start(String[] args) at System.ServiceProcess.ServiceController.Start() at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start) It says log on failure but i dont know how to change the settings... Please let me know.... Thanks!! SqlNew The Report Server S ...Show All
Software Development for Windows Vista Network Traffic Monitor?
Hey there, I'm trying to monitor network activity via the SnmpExtensionQuery API function within inetmib1.dll. This is something that was working in XP but for some reason it is no longer working within Vista. Have the designations for inbound and outbound traffic changed from XP to Vista or can I get that information now via different means than making a call to SnmpExtensionQuery and then doing a compare via SnmpUtilOidNCmp. Any help would be appreciated, as always. Regards, Daniel So it has been roughly 6 months and still no response to this Any ideas as to what I might be doing wrong would be GREATLY appreciated. - Daniel ...Show All
Audio and Video Development Menus not showing up on WinDVD HD (Toshiba Qosimo)
Hi all, this maybe isn't the right place to discuss compatibility with players but maybe somebody tried to get things to work on a software player before. My project is working fine on Microsofts iHDSimulator and the Toshiba HD-A1 standalone player. But when I try to run it with WinDVD on the Toshiba laptop (the one with HD DVD Rom drive) the software either crashes or just plays the menu video without the graphics. Any ideas Are there any known issues for the WinDVD software Cheers, Gunnar Not sure if this is related or not (seems to be), but ever since installing the new iHDSim (plus WMP11 and IE7) I cannot get menus to display in my copies of Million Dollar Baby or Serenity. Gunnar - are you getting me ...Show All
Visual Studio Team System coding of web test
HI I am a Software Tester with not a very good hand at programming.How ever i feel to do effective web testing i should be able to code my web test acording to what i intend to achieve.How ever i need to know what languages i need to learn as the applications that i would be testing is developed in asp.net so do i need to learn c# if yes considering me a beginner how much detail should i go into learning this language as i need to do functionality testing.Kindly Advice. Thanks in advance! aashta You are able to generate VB and C# coded web tests. The coded tests that you generate are fully functional and would not require any additional changes to run. So you do not need to start from scratc ...Show All
Windows Live Developer Forums Add-in API is never ever enabled in Messenger 8.0 and 8.1?
I can see the add-in UI after the registry tweak, but can't make the add-in works ever. In 8.1 beta, Messenger could load the add-in but never call the event handler I registered. In 8.1 release version, the add-in is never loaded. It doesn't matter whether I register my add-in to the GAC or not... Hi, never had problems you're describing, 8.1 also works fine for me. Is this about a plugin you developed yourself, or somebody else Are you using "Add to messenger" button in the Add-In messenger page to add your plugin Andrej ...Show All
Visual C# Cloning - include event handlers
Hi there: I need to create at runtime an exact copy of one of the objects I'm using, so I created a "Clone" method for it -- same as other clone methods: NewObject newObject = oldObject.Clone(); Now, to copy property values I either have to code every single newObject.Property = oldObject.Property; or use reflection (GetType, GetProperties and loop). Either way is fine, the bit of a block comes when I also try to "copy" the event handlers: let's assume my oldObject implements a "clicked" event. When I create oldObject I add the event handler for the clicked event: this .oldObject.clicked += new EventHandler (myClickedHandler); What I want is newObject (the object that is clone ...Show All
Visual Studio Error: BuildComponent
This is the error message I get (by using Sandcastle Help File Builder ): [...] Info: SharedContentComponent: Loading shared content file 'shared_content.xml'. Error: BuildComponent: An error occured while initializing the type 'Microsoft.Ddue.Tools.SharedContentComponent' in the component assembly 'C:\Program Files\Sandcastle\ProductionTools\BuildComponents\BuildComponents.dll'. The error message and stack trace follows: System.Xml.XmlException: ' ' is an unexpected token. The expected token is ';'. Line 34, position 45. at System.Xml.XmlTextReaderImpl.Throw(Exception e) at System.Xml.XmlTextReaderImpl.Throw(String res, String[] args) at System.Xml.XmlTextReaderImpl.ThrowUnexpectedToken(String expectedToken1, String ex ...Show All
Visual Studio 2008 (Pre-release) WCF and legacy applications
I currently have a web service that is being used by a number of different web applications and console applications, all written in VB.Net and ASP.Net 2005. Is there a way that I can re-write the web service using WCF and still allow the other applications to reference the new web service without breaking them The WCF methodly is new to us but we are wanting to start implementing it in our organization. Thanks Never mind, I think I found my answer at http://windowssdk.msdn.microsoft.com/en-us/library/ms751433.aspx ...Show All
.NET Development Datatable and commmandbuilder()?
I have a Datatable i create in my class and i want to save the values that i type in my columns that i create to my sql db and I wanted to know if i can use the CommandBuilder() object....I am not using a dataset or dataadpater with this...is this the best to do this or the better question maybe can i get this done by doing this a command builder is used really with a DataAdapter to generate the INSERT/UPDATE/DELETE commands. have you read about it http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommandbuilder.aspx the command builder will generate the command if the DataAdapter has a select command already I believe. AFAIK in this situation, you would have to create your own commands by going through the ...Show All