Craig Bye's Q&A profile

• Visual Studio Team System Please do not RTM yet!!!

  My biggest frustration when using VSTS for Database Professionals is that you still have to select one item at a time to skip if you don't want to migrate all changes. For instance, the "dt_" stored procedures don't do any good in my test or production environment and I have to click each one, one at a time, to skip them when scripting the differences between my local development copy and the test or production environments. A check box for each item, so you could apply a change to all selected rows at once, would sure help. I know you've heard this before. I know there are a lot of other problems that were identified very early on that have not been addressed as well. I guess I am just a little frustrated with the product ...Show All

• .NET Development Strange XmlSerializer error

  Dear all, I am programming in VB.NET , using the .NET Framework 2.0 on a Windows Vista machine running VS 2005 with the SP1 beta applied. I have a VB class which was derived from an .XSD schema using the XSD.exe tool. I am able to instantiate objects from this class and build by "XML" object up using it, without too much difficulty. However, when I come to serialize the output to an XML stream, it fails, with a FileNotFoundException on the serialize line, e.g.: Dim serializer As New XmlSerializer( GetType (eGov.IRenvelope)) Where eGov is my class namespace, and the IRenvelope is the class within the namespace that corresponds to my object which I am attempting to serialize. The interesting thing is, tha ...Show All

• Windows Forms Connecting to SQL Server via SQL Server Authentication

  I have a username and password (SQL Server Authentication) to connect to SQL Server from a WinForm application. Can anybody tell what are the best practices to store the username and password in a WinForm application Would there be any problem if I hard-code it in the application Thanks Basani It is a client application (WinForm) and I don't want them to see the username and password. I just want to know if there is any other way than hard coing it in the application. Storing it in the app.config file as clear text is not an option. Thanks Basani ...Show All

• Visual Studio 2008 (Pre-release) Certificate Distinguished Name

  I have configured a policy using the mutualCertificate10Security assertion and am using certificates to authenticate a client. I notice that the order in which the X509 elements appear in the findValue attribute makes a difference as to where WSE finds that certificate in the certificate store. The findType is " FindBySubjectName" For example, if the find value for a cert is E=XXX , OU=XX, O=XXX Testing Inc, L=XX, S=XX, C=US, G=IntegrationsTesting Provider, SN=Web Services, CN=IntegrationsTesting, WSE finds the cert, but if the find value is CN=IntegrationsTesting, SN=Web Services, GN=IntegrationsTesting Provider, C=US, ST=XX, L=XX, O=XXX Testing Inc, OU=XX, E=XXX, WSE complains that the cert does not exist. Please ...Show All

• Visual C++ How to hide tasks bar (start panel) of desktop by API function ?

  Hi I placed shortcut of my application in autostart. My application starts working after then windows is loaded. I have problem with start panel (tasks bar) because it is still visible. I manually selected autohide of tasks bar but when my application starts working tasks bar is visible. How to hide tasks bar by programming (visual studio C++) Please help me ! Hi May be this article is useful to you : http://www.codeguru.com/cpp/frameworks/advancedui/article.php/c3227__1 Regards. ...Show All

• Windows Forms make a control extend across splitter of splitcontainer

  Is there a way to make a control span across the to panels of a SplitContainer Just display it on top of the SplitContainer. The designer tends to get in the way, it will try to put it on a panel. Draw it above the container first, then edit the Location property by hand. ...Show All

• Windows Forms Is there a way to export a datagrid to an Excel or html format file?

  Hi all.. thanks for taking the time to help in advance!! :) I've written a win application that has a datagrid which displays certain contents from a database, is there a way to allow the user to export the contents of that datagrid to maybe an excel file or html file so they can print it out themselves I've done a lot of googling and most i could find were for web applications and not winform.. can someone point me in the right direction Thanks very much guys! :) I'm tried this, but I'm not getting data. I just get 'System.Data.DataRow written to eavery line. Can't figure it out. Using VS 2005 and .Net 2.0 ...Show All

• Smart Device Development Panel vs Form based application?

  Hello. I am going to design application for Pocket PC using Compact Framework. I dig in the internet, read articles and I am still wondering : what is the best gui design solution for mobile devices The most important thing (as always) is performance. My application will have many different forms/panels and will be switching between them many times. In desktop version of this application (unfortunately designed in java) we are using panels and state manager which enables and disables panels. But on Pocket PC we got limited memory space so I am wondering : 1. The once created panel exists in memory until I destroy it (dispose) 2. Is there any possibility to remove panel from memory or compress it when it is unused (hidden, disabled) And lo ...Show All

• .NET Development How to manage tables relations across Datasets?

  Hello, what's the best technique for managing tables, with parent (primary key) - child (foreign key) relation, that are in different Datasets Or is it necessary to integrate in one Dataset all the associated tables In this case a parent table must be in every Dataset that contains child tables that make use of this parent table. How is it possible to avoid this repetition of parent tables in Datasets Thanks. Ok, my question is about what you can read in document : "Designing Data Tier Components and Passing Data Through Tiers" from Microsoft In this document you see the database : http://msdn.microsoft.com/library/en-us/dnbda/html/f01boa03.gif The Datasets representing the database are here : http://msdn ...Show All

• Visual Studio Team System Team Site Licensing question

  We would like to create a user site underneath our Team Site so that users can post feature requests and bug reports. Will these users need a CAL in order to access this site Thanks, Ovi There is also a Team Foundation Server External Connector License that should cover this. I don't know what the criteria is for an "external connector" in the context of TFS. I believe the external connector license is for an unlimited number of external users and is about US$10,000. Depending on the number of external users it may be cheaper to get individual CALs. ...Show All

• Visual Studio 2008 (Pre-release) Base Class in xaml

  Hi, I'm trying to build a user control in xaml that would serve as base class for other user control. I searched the forum for answers but didn't find anything that was working, so if anybody has a working example or can explain it in details out to do it, would be great. Thanks in advance. I have tryed this: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=995567&SiteID=1 For current bit of WPF, you cannot subclass from xaml generated class, but you can work around this by doing something like the following: First off, create an custom WPF control library project, and then declare your custom window this way: namespace CustomControlLib { public class CustomWindow ...Show All

• .NET Development Excute an SQL Function in c#

  Hello All, How to execute an SQL function in C#, where I tried to give: return ExecuteNonQuery(); Where it gives me an exception.Any answers please.. Thanks in Advance Well hi, This is the reference: http://msdn2.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx If you have further problem pls feel free to let us know, thanks. ...Show All

• Windows Live Developer Forums Lat long from FindLoc()

  I have a very simple page that displays a map and has a search field on it using: function FindLoc() { map.FindLocation(document.getElementById('txtWhere').value); } Is there any way to capture the results from the search Are they returned in Lat Long I would like to some how get the lat and long from the search results. Thanks! Why are you using the findlocation method The purpose of this method is to center the map on a particular location. That being said, you could just use the find method to get the location, and then setcenterandzoom method to zoom into the latlongs of your results ...Show All

• .NET Development why doesnt System.Drawing work on Console Application?

  hi all i wanna do a project with openGL in console application.but System.Drawing doesnt work.what must i do i'm waiting for ur replies. There's no problem working with bitmaps in a console application. You just need to add the right references. Project + Add reference, select System.Drawing. In your source code file: using System.Drawing; Your code needs work, you can't save the bitmap back like you do. GDI+ keeps a lock on the file. You'll have to make a copy and dispose the original. Here's an example: using System; using System.Drawing; class Program { static void Main(string[] args) { try { Bitmap bmp = new Bitmap(args[0]); Bitmap cpy = (Bitmap)bmp.Clone(); bmp.Dispose(); cpy.SetRe ...Show All

• Visual Studio Tools for Office How to populate Word 2003 ComboBox / Dropdown list using VSTO C#

  Hi, I am creating dynamic OLE Control ComboBox in Word 2003 using VSTO C#. After creating ComboBox I want to populate it with some values. If I use VBA then I can populate using following codelines. Dim myarray(3) As String myarray(0) = "US" myarray(1) = "AUS" myarray(2) = "UK" ComboBox1.List = myarray But in VSTO when I use following code lines: object objClass = "Forms.ComboBox.1" ; object objMissing = Type .Missing; Word. Shape myShape; myShape = Globals .ThisDocument.Shapes.AddOLEControl( ref objClass, ref objMissing, ref objMissing, ref objMissing, ref objMissing, ref objMissing); // OLE Control is a floating control on document. Embeded Control is not accepted. ...Show All