tssweb's Q&A profile

• SQL Server Generate documentation of tables and columns?

  Is this possible the tables has a field called description and so does the columns. I need to generate a data dictionary. yes, you can either pull back the description via fn_listextendedproperty (or via SMO). Alternatively if you're just looking to document the schema, then perhaps you can use the free codesmith version and this template Cathal ...Show All

• Visual Basic Conversion from .Net 2003 to .Net 2005 using VB.Net

  We've just received .Net 2005 upgrade and are in the process of converting two projects. Both Projects have User Controls and we are having some issues with them. 1st, one of the user controls has 2 classes in it and the conversion moved the declarations from the class into another file, but not the code. Is there a way to convert a user control that has two classes without it doing this 2nd, We are getting errors on all the user control names. This error comes up: "Type uc_mc_btn_footer is not defined." Can anyone please tell me why we are getting this error when it seems all the user controls (except the one with 2 classes) seemed to convert correctly - adn how to fix it 3rd, where did the bin directory get moved to ...Show All

• Windows Forms How to get or read the last letter from a text box? - Vb.net or VS 2005

  Hi I have a TextBox in a windows form to enter 10 digit number followed by 2 letters. (Ex: 304528929 GH ) I have a code (got from my other thread) to calculate the total of the above digits(3+0+4+....) and dividing the total by someother value to get the reminder . IT ALL WORKS FINE Also I have list of alphabets with equivalant value like below A = 3 B = 7 C = 1 H = 12 ........ ........ Z = 22 My question: If the reminder matches one of the above list , for example reminder from the above calculation is 12. So it matches with H = 12 . So If H is the last letter of 304528929 GH , then the user input is right. In Short : HOW DO I GET THE LAST LETTER (ex. 'H' in the above case) From the textbox and check w ...Show All

• Visual Studio Team System Workgroup vs Domain or both?

  I hope that someone will be able to advise me on a VSTS installation scenario we are considering We have 4 remote sites that we would like to connect to the main central repository, geographically the sites are in 2 different continents. The main VSTS install we would like to host in a secure datacentre with the 4 sites connecting via proxy servers hosted in the local offices. We will not have connection to an AD domain in the datacentre so this will have to be installed as a workgroup but the local office proxy servers will be connected AD domains, what is the best way to handle permissions, is there a way we can enable the domain accounts to create projects etc What are the potential pitfalls with this scenario Or would the best w ...Show All

• SQL Server Mirroring and replication

  Hi MSSQL friend, We have a SQL2005 server which contains some replicated databases. We use merge replication and the publications are all local. In order to make the server failsafe we need some kind of mirroring. Is this possible with replication Any ideas how to accomplish a failsafe scenario with replication Sincerely Edward You can start by searching SQL Server Books Online, I searched for "replication mirroring" and found this: Replication and Database Mirroring - http://msdn2.microsoft.com/en-us/library/ms151799.aspx ...Show All

• Visual Studio Express Editions VB 2005 Exp - Running exe file on other PC

  Hi, I was triyng to run my application on other computer and when I start the exe file, the following error ocours: "To run this application, you first must install one of the following versions of the .NET Framework v 2.0.50.727" What can I do Regards, Pedro there would be a problem with the application itself in that case, perhaps its looking for something or couldnt load some files, perhaps you were using some 3rd party plugin or SDK which was not installed on the machine. ...Show All

• Visual Studio Tools for Office Excel 2003 using VSTO

  Hi, Is it possible to check if there is a running instance of Excel and load a workbook into it, or if not invoke a new instance Also, it would be good to have some error-handling in case whatever running instance of Excel is tied up (e.g. printing for example or doing some large operation). I am using VS2005, VSTO, and Excel 2003. Thanks! Cindy Meister wrote: This part is early binding and you'd need to change it for late-binding. But you should take this discussion to another group to pursue the topic. Thanks! Any suggestions where exactly ...Show All

• Silverlight (formerly WPF/E) find a bug of "getParent"

  if i use getParent to get the parent of source object, it will be can't in safari. remove:function(s,e){ var _w=s.getParent.getParent.getParent.getParent; ui.get("desktops_windows").children.remove(_w); } and if I set a name to parent object at first, and get the parent of source object by it's name, it will be ok remove:function(s,e){ var wid=s.Name.split("_")[0]; var _o=ui.get(wid); ui.get("desktops_windows").children.remove(_o); } This bug is just in Safari. yes! it works! Thanks very much. But it just happened in SAFARI... Is there also need () in the method of wpf/e ...Show All

• Visual Studio 2008 (Pre-release) Load Xaml from C#2.0 runtime

  I create xaml file which has just UI and save it to some folder.Now i need to load the XAML UI from c#2.0 windows Application.say on a button Click i need to show the another form which is a XAML file. Pls help me. There is support for hosting WPF controls in a WinForms app. Here's a good place to get started with that task: http://msdn2.microsoft.com/en-us/library/ms742215.aspx ...Show All

• Visual C++ trouble getting started

  I have no programming experience and I have just installed microsoft visual studio 2005. I have a book on C++, it a few years old but i thought it would give me a start on learning c++. I want to compile one of the examples out of the book. How do I do that The book is teach yourself C++ by Al Stevens. Can anyone please help me out it says there were build errors. would you like to continue and run the last sucessful build i clicked on yes and it says, unable to start program c:\documents and settings\user\my documents\visual studio 2005\projects\01\debug\01.exe The system cannot find the path specified. ...Show All

• .NET Development Dialogs in ASP.NET using server-side-blocked-calls

  Hi, I have created a true MVC-pattern for ASP.NET that allows dialogs windows in ASP.NET just like you would do when using WinForms. I am using a technique called server-side-blocked calls (server-side AJAX). On my website there are four demos online and also a recording of a live-coding-example (executable desktoprecording). The framework is freeware and is currently being applied in several projects. For more information visit http://www.inchl.nl   Here is a code sample of a small demo that contains: 1. A page containing a button and a textbox. The button shows a searchwindow. The search result is put into the textbox when the searchwindow closes. 2. A page representing the search window containing two buttons&n ...Show All

• .NET Development Errors after successful install of .net framework 3.0

  I am a consumer, not a programmer.    On 1/29/2007 I went to Microsoft Update and got two items from the software(optional) pane, they were as listed below.  After I got the updates the computer did not ask me to reboot as it had advised me I might have to before the update.  So after the successful download and install of these items and waiting a good while after the Microsoft Update website said success and I had closed it, I rebooted the computer using the start menu restart.  After the restart the computer would not access the internet whatsoever, even though my ISP said I had a valid IP number and my IP phone from Comcast was working fine.  I called McAfee because their software was not able to run and t ...Show All

• Visual Studio 2008 (Pre-release) How to get the name of client machine inside OperationContext Object?

  Hi Everyone, Does anyone know where to get the name of client machine inside OperationContext.Current object I try to use OperationContext.Current.IncomingMessageHeaders.From property but it’s always null. Regards, Jdang Hello Jdang, The NetTcpBinding wraps a TCP socket as a channel and sockets don't have any built-in feature for for providing the sender's machine-name. In other words, it isn't povided by the underlying transport so we don't have a way to surface it to you. Do you have the option of modifying your contract so it includes the client's machine-name as one of the parameters Alternately, you could add a message-inspector that adds the machine-name as a custom header ...Show All

• SQL Server Linking two SQL Server Express Servers

  Hello all! How do I go about linking two SQL Server Express servers I can't seem to find information on this. Also, I need to import data from MSDE. Is there anyway to do this Regards, Andrew Cappella-Pakos You can use this article to find out more about linking servers, and doing remote queries from one to the other: http://www.informit.com/guides/content.asp g=sqlserver&seqNum=150&rl=1 On your second question, you can just back up the database on MSDE with the BACKUP DATABASE command, and restore it on the Express edition with the RESTORE DATABASE command. It will automatically upgrade it for you. Buck Woody ...Show All

• Smart Device Development How to create List like Setting Screen native List in for smartphone.

  I have a form in which there are number of items.Which control I will use on this form to get native setting screen list like behavior. Please provide me sample. I am using windows mobile 5.0 with compact framework 2.0 and C# Hi. I'm using VB in VS2005 with WM5 and CF2, writing for Smartphones and doing the same as you require as follows... Add a ListView control to the form, set its View property to Details, and the FullRowSelect property to true. In the Form Load event populate the ListView with columns and data… ' Create the ListView items Dim ltvitmItem1 As New ListViewItem("1") ltvitmItem1.SubItems.Add("Item 1) Dim ltvitmItem2 As New ListViewItem("2") ltvitmItem2 ...Show All