qoo942's Q&A profile
SQL Server Storing images in sql server 2005
Hi There I have not had much luck finding info in BOL. I have a directory with many images, i need to load these images into sql server.We want to staore them in the database instead of the file server. What is the best way to do this TSQL (i am hoping), .NET code or maybe even SSIS I have been reading what i can find in BOL basically all i know so far is that image data type will be no more in the future and i should use a varbinar ...Show All
SQL Server Concatenating 2 text boxes
Hi, How do we concate a normal text with an underlined text eg: I would like to concate : textbox1 = my email address: and textbox2 = xxx@hotmail.com into a new textbox3. expected result: textbox3 : my email address: xxx@hotmail.com Really appreciate your help. Thanks You will not be able to do this with a single textxox, because we do not currently support rich text (mixing fonts and font styles) within te ...Show All
Windows Forms Maintaining the selected row after sorting a DataGridView
Hi, Simple question, hopefully there's a simple answer: How can I maintain the same selected row even after a sort on a DataGridView In other words, after new items have been added to the binding source and a sort has been forcefully been carried out (in the custom BindingList), how can I ensure that the selected row is the same row as the one selected before the sort Bear in mind, I'm doing the sorting in a custom Bin ...Show All
Visual Studio Team System TFS Beta 3 Access from NT Domain
I cannot add users from a trusted NT domain to the TFS groups, and so cannot connect to TFS from a client machine logged in under an NT domain account (except by entering the TFS setup account id and password). Is this by design If I missed this issue in the documentation or an earlier thread, please point me to it. Here is our environment: TFS was setup in single-server mode on an AD machine. The account used to set it up is an AD account. The ...Show All
Windows Forms Move the Directory
sSource = "W:\Current\" & sSelectedEvent sSourceFile = "W:\Current\" & sSelectedEvent & ".nbalert.xml" sdestination = "W:\Dismissed\" & ...Show All
SQL Server Logging from a custom source adapter
I'm having alot of trouble figuring out the proper way to log from inside my custom source adapter. I couldn't find my useful information in MSDN, it mostly applies to logging from inside a script task. I'd like to log my messages along with all the other SSIS package log entries, which I have going to the dts log table. I'm assuming I should be using some functionality from Microsoft.SqlServer.Dts.RunTime, probably the LogProvider. Can anyone a ...Show All
Windows Live Developer Forums Suggestions for XML-RPC API
Hello! I have recently started using the Spaces XML-RPC API for a project of mine (thanks for putting it up, guys!) but I still feel some things are missing (sometimes rather obvious things, as well). I hope they can be added in future releases of the API. First, when using the getRecentPosts method, I think we should get some more information. Comments would be nice (nr of comments, comment content, who posted comments, etc), but what ...Show All
Visual Studio Express Editions Keyed Collection Class Question
Hello All, I have a question about the Keyed Collection Class. I am using the Keyed Collection Class as the basis for a Collection in my VB application. I chose they Keyed Collection Class because it appears to allow you to store the objects in your Collection with a Key Value that can be used to retrieve remove or find them latter. However when I try to execute the add method of the Key Collection Class it says that I have too many arguement ...Show All
Visual C++ Structs and CArrays
I have the following bits of code typedef CArray <CPoint, CPoint> POINTS_ARRAY; struct MY_STRUCT { int a_stored_integer; POINTS_ARRAY points; }; typedef CArray<MY_STRUCT , MY_STRUCT> MY_STRUCT_ARRAY; All that code is in a header file, then in a cpp file i have the following MY_STRUCT_ARRAY my_array; MY_STRUCT my_struct; my_array.Add(my_struct); and it throws this error error C2664: 'CArra ...Show All
Visual Basic Create, Query, Delete and Edit Windows Registry
How can i modify my windows registry using Visual Basic 2005... Thanks:) ...Show All
.NET Development Remoting from GINA
Our app needs the services of remote objects during the logon process (say, to log invalid log on attempts). We have a replacement GINA in place and it uses COM to invoke a COM-enabled CLR object. This object in turn does the remoting stuff. All the objects are connected up and working but during initialisation, the CLR object performs a RemotingConfiguration .Configure(...) call which throws an exception (apologies, its a a lengthy one) and ...Show All
Windows Forms Strange Errors in VS.NET
Have any of you experienced the following error while compiling a windows forms application: The application fails to compile and the errors are on lines numbered 16707566 +/- . If you click on the error in the task list it doesn't take ...Show All
Visual Studio Team System How to clean up a database after test recording and also after test has run and start with fresh database?
How to clean up a database after test recording and also after test has run and start with fresh database I have a form in which there is a data grid on it.During recording i add some values in that field so as a result those values get added in the data grid and i got a string saying that record has been saved.When i ran this test those values were already in the data base so the test passed but in test results details in the browser window ...Show All
SQL Server Replicating Schema only
Hi, I have a database that is being set up for merge replication (Sql 2005), but there is one table that I only want the schema replicating, not the data - I never want the data to be replicated in either direction. I can see from sp_addmergearticle that you can do something like this for sp's or functions but is it possible to do this for tables Regards Graham I'd just script out the object to a file a ...Show All
Windows Forms Add design time support to wrapped user controls
I have my own ControlLibrary where I wrap a 3rd party StatusBar. I made my own collection of "Panels". Creating items in the collection at design time is not a problem. Also, runtime creation is not an issue. But if I create items&nbs ...Show All
