ANB_149's Q&A profile

• SQL Server Using "IN" for Output

  In T-SQL 2005, is it possible to put an "in" clause into the output portion of a select statement, rather than the predicate (the condition portion)   I ask because I want to have an output column that is true when the "in" clause finds a match, and false (or null) otherwise. Aha, perfect! I did not know you could use an "IN" clause inside of Case When. Now I just need an answer to my other post: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1087040&SiteID=1&mode=1 ...that tells me how the "IN" clause can use a paramter from a stored procedure, or how it itself calls a stored procedure (to get the set of values for checking). In other words, I need the clause to be dynamic, but I am not ...Show All

• Windows Forms ADD A LIST OF TABLES FROM SQL Database

  Hi Everyone Does anybody know of a way to get a list of tables from a SQL Database using a selct statment or a stored procudre Thanks James Murray Hi, select * from Sysobjects WHERE type = 'U' This works for MS SQL (which is whatI assume you use since you don't mention otherwise). BTW, took me less than a minute to Google for this and find the answer. Luc ...Show All

• Visual Studio 2008 (Pre-release) LINQ to SQL DataContext too slow with large databases

  I've discovered that LINQ to SQL is currently too slow for real applications once you've got more than a few dozen tables in a typed DataContext. I presume this is purely a CTP thing but am mentioning it anyway so it doesn't get overlooked. The problem is with the AttributedMetaModel classes - they totally rebuild (essentially static) type information for every table class each time a DataContext is instantiated. Because in a distributed application a fresh DataContext must be instantiated for each middle tier request, this is a killer. My (so-far) successful workaround is to write a custom meta model with two MetaTable collections - a static dictionary for table-attributed classes, in addition to the existing instance collection for proje ...Show All

• SQL Server how to set column name dynamically?

  HI chaps my scenario is that, i have a table in which i have column such as col01,col02,col03....col31 i want to retrieve the records related to that column by specifying the name dynamically (by using loop) as fist three character are same ( 'col ' ) and i have to do integer increment in last two character ( 01... 31). Is it possible that I can use variable for column name , if yes how or is there any other way to achieve this task waiting for your reply regards   fafnir wrote: Something like the following will work for you: create table DynCols (col01 int, col02 int, col11 int, col12 int) -- and so on, fo all 30 columns declare @query varchar(255) set @query = 'select ' declare @counter int ...Show All

• Software Development for Windows Vista Question About SideShow Gadget

  Hi Is here right place to question about SideShow Gadget Does anyone know where is the place to question about SideShow Gadget programming Hi, Thanks for responding. My Question is What is right way to update SideShow contents periodicaly(like a clock). For example, Media Player gadget "Play View", current position in music is display periodicaly. I tried following psude code in gaget, (after create SideShow Sessin, get Content Manager and add initial content) Loop { sleep(x) ISideShowContentManager::Remove(old_content) ISideShowContentManager::Add(updated_content) } It's just running. But, is it right way I don't understand when SideShow devi ...Show All

• SQL Server Inserting with UpdateGrams

  Hello. I'm triing to use UpdateGrams to save data: XML: <updg:sync> <updg:before> </updg:before> <updg:after> <Image ProductList="11" ObjectType="3" MimeType="image/png" Content="AAAAAAAAAAQAC" EditDate="08/31/2006 14:27:16" AuthorID="5"></Image> </updg:after> </updg:sync> XSD: < xml version="1.0" encoding="utf-8" > <xsd:schema xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:sql="urn:schemas-microsoft-com:mapping-schema"> <xsd:annotation> <xsd:appinfo> <sql:relationship name="ImageProduct" parent="Images" parent-key="ID&q ...Show All

• SQL Server Can we send a blob in a message.

  Say i want to send a blob in a message from queue A to queue B. These locations can be geographically different. How can i implement this Also anything which i want to send as a message should be stored in the database. and then I should store it in a variable. this can be used as the message body. am I right Hi Remus, From what you have said before that SSB cannot use HTTP. But the following statement from BOL says the opposite: An endpoint is a SQL Server object that represents the capability for SQL Server to communicate over the network. Each endpoint supports a specific type of communication. For example, an HTTP endpoint lets SQL Server process specific SOAP requests. A Service Broker end ...Show All

• Visual C# Capture Streaming Video

  Hi, I want to create a program that is able to save a (unprotected) video file from a mms-server. I tried different ways to get the stream and write it to the harddisk but I failed each time. Is there a way in C# to do this Thanks in advance. I would also like to know this. Though I do believe there is a featurein windows media player to save the viewed file . file>save > in the full version. ...Show All

• Visual Studio Team System Network type in Web Test vs. Network type in Load Test

  I have following question: what is the relation between network conditions in my recorded Web Test and defined network conditions in the Load Test For example, I record Web test using DSL connection and then I use this Web test in the Load Test, in which I define network = LAN. Does this LAN make sense at all since my Web test runs through DSL Should Web Test and Load Test contain corresponding to each other network connections The network setting in use while a Web test is being recorded as no impact on the resulting Web test. In fact, there is nothing stored in a Web test regarding network simulation. The load test contains configuration options for simulating different network speeds when running a web ...Show All

• .NET Development The root element is missing

  I have xml coming in as a string to a web service which I then try to get to eventually having as a validating xml reader. Here is a code snippet with some of my former attempts commented out:: StringReader strReader = new StringReader(strXMLData); //XmlTextReader textReader = new XmlTextReader(strReader); //XmlValidatingReader valReader = new XmlValidatingReader(textReader); //valReader.ValidationType = ValidationType.Schema; //valReader.Schemas.Add(cache); GC_COMP_DS tempCompDS = new GC_COMP_DS(); //tempCompDS.ReadXml(valReader); tempCompDS.ReadXml(strReader); This works with the comments in, but as soon as I try to even uncomment out the creation of XmlTextReader class, not even using it, I get an error, "T ...Show All

• SQL Server MsAccess to Sqlserver Transfering at regular intervals ?

  I am having Access database in my local system . Values in the access database will be updated for every 5 min . I am also having Sqlserver database online with the same structure database of Access in my local system . What i want is my Access database values must be updated in my online sqlserver at every 5 min automatically . Create a linked server and a stored procedure which pulls out the data from the access database on a scheduled basis (With SQL Server Agent Jobs). HTH , Jens K . Suessmeyer . --- http :// www . sqlserver2005 . de --- ...Show All

• Windows Forms How to create a multi-selection list view for a touch screen?

  I am currently developing an application meant to run on a terminal with a touch screen. I have a list view and I would like to modify it so that every time the user touches an item it becomes selected. If the user touches the selected item again, the item is unselected. It should also support ‘multi-selection’ meaning that if the user touches items 5, 7, 9 and 10 they should all be selected and then if the user touches item 7 only 5, 9 and 10 should remain selected. How can I modify the list view to achieve that Thanks, Dom. I forgot to mention that I am developing in C# ... here is my 'translation' of the code you provided. using System; using System.Collections ...Show All

• SQL Server SQL Server not visible

  I can't seem to make the SQL Server visible to anything other then SQL Server Tools. (management Studio, etc.) Neither Visual Studio 2005, or Administrative Tools/Data Sources can view or connect with my SQL Server. I need help, Thank you. Hi, I have the same problem I have Visual Studio 2005 and the 2005 SQL Server Express ed. installed. I can’t see the SQL server from any other tools than the configuration tools for the server and the SQL Server management studio. In Visual studio, i can’t see the SQL server at all! When selecting SQL Connection, there are no servers to select from and no databases either I don’t know if the databases are empty, when they were installed with ...Show All

• Software Development for Windows Vista How to get the connector object in design time!

  hi all, In flowchart sample, how to get the connector object in design time many thanks, I have got the answer from the subject " FreeformActivityDesigner and Connectors question... " ...Show All

• Visual Studio Express Editions Sending Data between forms not working!

  This simple example below does work. But, I am doing the same thing in my app and Form2 is not getting the string from Form1! Public Class Form1 Public str As String Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load str = "hey" Form2.ShowDialog() Close() End Sub End Class Public Class Form2 Private Sub Form2_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load MsgBox(Form1.str) Close() End Sub End Class Hi, You have created an overloaded constructor in Form2 Add the following base constructor to Form2 Public sub new() end su ...Show All