JoeMcCreary's Q&A profile

• SQL Server changing schema owner through SMO

  I'm getting the can't drop user error. Is there a way to change the schema owner via smo I've tried the following code to change the schema owner back to a different user. I don't get an error or exception but the schema owner doesn't change. Database database = new Server ( "my server" ).Databases[ "my Database" ]; database.Schemas[ "db_owner" ].Owner = "db_owner" ; John, giving that your question is SMO related, I split it from the thread you posted it in and I moved it to the SMO forum. Thanks Laurentiu ...Show All

• Visual Studio 2008 (Pre-release) A few Dlinq bugs

  I run into a few issues while testing Dlinq out. Here is a simple program that demonstrates them. Not sure if all of them are real bugs as some could be caused by my mistakes. using System; using System.Collections.Generic; using System.Text; using System.Query; using System.Xml.XLinq; using System.Data.DLinq; using Microsoft.VisualStudio.TestTools.UnitTesting; namespace LINQConsoleApplication { class Program { static void Main ( string [] args) { DlinqDemo db = new DlinqDemo ( @"Data Source=localhost\sqlexpress;Initial Catalog=DlinqDemo;Integrated Security=True" ...Show All

• Visual C# Unable to find designer generated c# code

  Hello all, I'm looking for a way to display the code that VS2005 generates when you add a new web form to a web project. Usyally in VS2003 the button "show all files" displayed all I needed. But now that button is called "Nest Related Files". Tha button just displays the .cs files you can modify but thoose files does not contain designer generated code. I'm sure that during a Microsoft event (in the VS2005 beta time) there was a way to display that part of code, but now it seems all information about that function is removed from help. Am I missing something obvious Thanks for help ...Show All

• SQL Server Setting Passwords In Connections Using Script Task

  I have a situation where I have to read an encrypted password from a table and set the password and userID for the connections. I wrote functions to retrieve the data from a table, decrypt the password and UserID, and set the connection string for the connection. What happens, though, is that the connection string I wrote to the connection gets changed when reading it back so that the password is no longer included. Also, in testing the connection, it fails, telling me login fails. Can anyone shed any light on this Does anyone have sample code to show the setting of a password for a connection in a script task All of the examples I find are ...Show All

• Windows Forms Best way to setup a UDL file?

  I have converted a VB.NET app from 2002 to 2003. Once converted, I am recieving build errors on my connection command. Me.OleDbConnection1.ConnectionString = "file name=rass.udl" Err: Unable to load the UDL file. I have the UDL file created in the same folder that my project is located. If I put the full path for the file, the error is removed, but onc ...Show All

• Windows Forms Is it possible to use the PhotoListView outside of this application?

  I'd like to be able to use the PhotoListView in another application, but so far I haven't had much luck in trying to decouple it from FotoVision. I don't know if it's an artifact of VB.Net or just the way the application was architected, but the best way to describe the relationship between PhotoListView and the rest of the application is high&nbs ...Show All

• Visual C++ What happened to io.h?

  I'm using Visual C++ 2005 version 55537-000-0000016-00168 and the only place I can find io.h is in C:\Program Files\Microsoft Visual Studio 8\VC\crt\src\io.h.  Is that intentional Thanks, Keith MacDonald Hi Keith, It was fixed after that. I verified this on build 050215. Ronald ...Show All

• Windows Forms Resizing a control problem in design mode

  I have created a UserControl and a designer for it and I am having problems with the adornments drawing incorrectly when resizing the control in design mode. When resizing the control, the adornments are drawn to the original control bounds and not to the resized control bounds. If I select something else, and reselect the control, the adornments draw correctly. Here is how I am declaring the UserControl: [ Designer ( typeof ( UserControl1Designer ))] public partial class UserControl1 : UserControl { public UserControl1() { InitializeComponent(); } } Here is the designer code: class UserControl1Designer ...Show All

• .NET Development using sax to parse large xml files

  I am trying to use SAX for the first time. I got as far as this: this .fileStm = new FileStream(path, FileMode.Open, FileAccess.Read); reader = SaxReaderFactory.CreateReader( null ); reader.Parse( new StreamInputSource(fileStm)); and i have no idea how to actually get the data from the reader... If anybody has a sample code to parse the document and put data into some kind of a structure like hashtable or an arraylist - I would really appreciate it ! Thanks! Forcing XmlReader through a SAX layer is possible but adds overhead that makes the comparison somewhat unfair.  You should be comparing real customer code - one writ ...Show All

• Windows Forms Run-time,design-time component

  I am interested in dividing my components into run-time and design-time components. I want to do this so that code I only need for design time is not included in the run-time component, which is shipped to an end-user. The design time component would only be needed by the programmer when making use of the design-time capabilities of my component, such& ...Show All

• Software Development for Windows Vista My Vista problems - please help

  When i try to install the "Windows 'Longhorn' Professional x64 Edition Beta 1" on my PC I get an "setup.exe is not a valid Win32" error. When I try to boot from the CD, it wont! Just some specs on my PC which may/may not be relevent: Athlon 64, SATA Raid array, Asus K8V-X motherboard. You need to format the partition with NTFS with XP's installer.  Vista's format is not working well right now. ...Show All

• Windows Forms Two DataGridViewComboBoxColumn one of which is filtered by the other's value

  Let me give you the scenario first. I want to setup a datagridvew connected with database, for example Products table in Northwind. I wnat to display the fields in this order: CategoryID, ProductID..... First: I have a DataGridViewComboBoxColumn. This combobox fetches all the category ids from the Category Table. Second: I have another DataGridViewComboBoxColumn. This combobox displays only those products that match the CategoryID selected by user. Can anybody help me to implement this Thanks and regards. Kutty Yes, I know that. But I wnat the grid to display all the categories and corresponding products. Actually my ...Show All

• .NET Development Reading mail from gmail or yahoo

  hi is there any way to read mail from mailbox of yahoo or gmail. or read mail from any mailserver. plz help me. thanks and regards kavita Following blog post includes c# code for downloading emails from gmail: HOWTO: Download emails from a GMail account in C# ...Show All

• Visual Studio Express Editions keypress......please help

  hi guys I have asked this question before with no satisfactory response....... can anyone please explain this to me ........................................................................ I am making a simple animation in vb express.............yes...I know vb is not ideal for game making...but I dont know c++ or c sharp..........so I am stuck with vb.... my problem is this.... when I press a key to move a graphic everything is fine....but if I hold the key down everything else on the screen freezes.....except my little animation ... which flies across the screen........ so how do I stop the keys from repeating ...Show All

• Windows Forms PictureBox ImageChange Event???!!

  Hi All, I was wondering if there is an event I can use other than 'Paint' to capture when a picturebox has had a image loaded or changed any help appreciated. Carl. Adding an image causes Invalidate() to be called.Hence,call the InValidated event to get the change in image. Hope this helps ...Show All