William Vaughn's Q&A profile

• SQL Server How can I generate xsd files from existing tables?

  I would like to generate xml schema files for my data model for later use with testing tools such as ndbunit. I realize that Visual Studio datasets can be used to do this, however, Visual Studio does not automatically determine table realtionships. I do not want to manually specify these relationships. I also do not have the luxury of using TeamServer for DB professionals. The Database Diagrams feature of SQL Server Management Studio seems capable of determining the table relationships on its own. However, I don't see any way to simply export a databse diagram to an xml schema definition. I realize I could write code to do this myself using the nice APIs under the Microsoft.Sqlserver.management and System.xml namespace, but I'm trying to a ...Show All

• Windows Forms Replace string

  i have a string "12:12:2006" and i wanted to remove ":" in the string. I tryed stringname.Replace(":","") but it dosen't work.Can any one help me in this. Hi Shankar, I think you are not assigning the return value of the String.Replace method to a new string. That is why your code is not working. Strings are immutable. YOu cannot change any characters of a string. The 'Replace' method returns a new string variable after replacing the characters (or strings). Use the following code. i am sure it will work. string newString = oldString.Replace(':', ','); Regards,Siddhartha ...Show All

• SQL Server Setting access permissions Iusr_Servername to access SQL Help please!

  I need some help I have a 2003 MS Small business server with MS SQL 2005. I have a access front end database and SQL server back end. I need to connect a web site form in iis on the same server to the sql tables . I am generating errors in the event log when I submit the form data from the web, “Login failed for user SERVERNAME\IUSR_SERVERNAME! (CLIENT:192.168.1.37) ! Can anyone direct me to a paper that will step me through setting up this access Here is the full error. 2006-11-15 10:20:39.28 Logon Error: 18452, Severity: 14, State: 1. 2006-11-15 10:20:39.28 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 69.58.133.164] 2006-11-15 10:21:22.56 Logon Error: 17 ...Show All

• Visual Basic I Have a new question?????

  I have 3 classes that are my companies ok 1 works fine with no problems or quams ok, the other two if I remove the references to the other working class they work fine, However if I add reference to the first class and try to use it I am inundated with messages to send to MIcrosoft so that they can tnker and find the root cause, all I am compiling are classes there are no heavy graphics or aspx pages. these are classes that are migrated from 2K3 where it works fine no warnings no nothing... Now the first class i mention is a comment class, companynameComment, which references CompnayNameutilites, and runs no sweat. CompanyNameUtilities references CompanyNameComment and does not run until I remove this reference, I thought it had something ...Show All

• Windows Forms Pressing Escape in a DataViewGrid throws an 'System.NullReferenceException'

  Has this problem been fixed Is there a work around Jeff https://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx FeedbackID=197067 Keep a track on the entry at the connect site to see when it has been fixed. I did some quick test with VS2005 SP1 on Vista and I can not reproduce it. Not sure if it is fixed or if I am just not able to create similar situation. I tried with an empty datatable as datasource and with an unbound gridview with a single column. No exceptions when I cancel new row with escape. ...Show All

• Visual Studio 2008 (Pre-release) DataBinding ListBox.ItemTemplate = (DataTemplate)FindSource???

  I would like to DataBind the ListBox with the Existing <DataTemplate x:Key=" "> Template ok,i'm trying to DataBind the Current ItemTemplate that currently Exists in Xaml first here is the C#:: ListBox.ItemTemplate = ( DataTemplate )FindResource( ResourceKey .Equals(StackPanel.GetBindingExpression( BindingMode .OneWay, System.Xml.XPath. XPathExpression .Compile( XPath=@version )))); The Xaml DataTemplate:: < DataTemplate x:Key = " itemTemplate1 " > < StackPanel x:Name = " StackPanel1 " > < TextBlock x:Name = " TextBlock1 " Text = " {Binding Mode=OneWay, XPath=title} " /> < TextBlock x:Name = " TextBlock2 " Text = " ...Show All

• .NET Development Error with Typed DataSet and InfoPath

  I created a new WebService in VS2005 where the new WebMethod "GetResults" uses a Typed Dataset "DataSet1.xsd" to return the contents of a SQL Table. When I begin to design a new form in InfoPath 2003 or 2007 and use the "GetResults" operation I receive the following error: "The data contained a DataSet DiffGram which has a DataSet with a different name than the associated schema indicates." Any ideas Even though it's incredibly convenient to do so, it's not best practice to return a DataSet through a web service. The reasons for this are that the DataSet represents itself as a DiffGram or as a document depending on its state, is arbitrarily reshapeable at r ...Show All

• Visual Basic How to use .NET class from VB6?

  I Created DLSBPM.Model and want to use it from VB. But, it doesn't work.. How can I use .NET dll from VB6 Dim crh As CorRuntimeHost Dim ad As AppDomain Dim oh_model As ObjectHandle Dim model As Object Set crh = New CorRuntimeHost crh.Start crh.CurrentDomain ad ' Thows Error Set oh_model = ad.CreateInstance("DLSBPM.Model", "DLSBPM.Model.Parameter") Set model = oh_model.Unwrap model.UserId = "my user id" ad.CreateInstance throw Error: Run-time error '-2147024894 (80070002)': Could not load file or assembly 'DLSBPM.Model' or one of its dependencies. The system cannot find the file specified. I added the dll to GAC regasm DLSBPM.Model.dl gacutil /i DLSBPM.Model.dll Thank you. ...Show All

• SQL Server Can I build a cube using a SQL data source and a DB2 data source

  We are trying to build a cube using data from SQL and DB2. Is this possible and if so, how db1 - SQL Server 2005 db2 - DB2\AIX64 We are using the Microsoft OLE DB Provider for DB2. On issue is encountered when defining the DB2 connection; AIX is not an option for the OS, so we are using DB2\NT. I can get both Data Sources defined and the connections test successfully. I can get both Data Views defined just fine. When I build the Dimension using the DB2 Data Source, the only way to get it to process was to Check the box in the SQL Data Source definition that read something like 'Maintain a references to another object'. That actually changes the Provider in the connection string to DB2OLE ...Show All

• Visual Studio Tools for Office Toolbox weird behavior!!! - My Solution

  I am using VSTO 2005. I am working on an Excel Template. Suddenly the toolbox becomes disabled and prevents me from adding controls to the Excel sheet but it is enabled in regard to the taskpane. I reinstalled VSTO and it was enabled but now disabled again. Do you have any idea this is very urgent.... Thank you........ Hello, I thought I would add how I fixed this problem, and what I suspect might have been the cause. As everyone else, I had the same problem and it occured after I created a setup project for my VSTO Excel Application and then tried to test it on a computer with Visual Studio and VSTO currently installed. Every computer that I tested my project on, subsequently, had this prob ...Show All

• Visual Studio Visual Stuiod 2005 Causes Crashes????

  Occasionally when I open a profile in AIM or try to watch a video with IE or Firefox I get a dialogue that says ________________________________________________________________ | "VISUAL STUDIO Just-In-Time Debugger" | | "An unhandled Win32 exception occurred in IEXPLORER.EXE[3292]. | | | | "Possible Debuggers:" | | "New Instance of Visual Studio 2005" | | () - Set the currently selected debugger as the default | | () - Manually Choose the debugging engines" | | ...Show All

• Windows Forms DataGridViewRow - why does it require a default property?

  This code in VS05 : Private Sub ProjectGrid_CellClick( ByVal sender As Object , ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles ProjectGrid.CellClick Dim currentProject As DataGridViewRow = ProjectGrid.CurrentRow Debug.WriteLine(currentProject( "ProjectID" )) End Sub ProjectGrid is a DataGridView control bound to a bindingsource connected to a table in a dataset. ProjectID is a valid column name in the grid and the bindingsource. The user has clicked on a cell in the control to activate this handler. Produces this error in the debug.writeline statement with reference to the variable currentProject: Class 'System.Windows.Forms.DataGridViewRow' cannot be indexed because it has ...Show All

• Windows Forms Setup bootstrapper ByPassIf question

  Hi guys I've built a custom bootstrapper that installs some prerequisites of my application. It simply copies 3 .NET assemblies to the GAC. I want to skip installing this if the prerequisites are already installed. In other words, if the 3 dlls are already in the GAC, there's no need to run my boostrappter package. To achieve this, I created the bootstrapper package.xml file with some install conditions: [create the custom properties here to indicate whether the dls are installed in the GAC...] <BypassIf Property="IsMshtmlInstalled" Compare="ValueEqualTo" Value="true" /> <BypassIf Property="IsMsOfficeCoreInstalled" Compare="ValueEqualTo" Value="true" /> ...Show All

• .NET Development .net object browser

  I've been working on .Net development. I was wondering if the object browser (the one that comes with Visual Studio.Net 2005) shows the protected fucntions, events etc. I'm not seeing it and so was curious if there is any configuration setting. Thanks, Vivek   Yes, those settings ara available in the object browser itself. Look at its toolbar (within object browser's tab) - the drop-down button on the far right allows you to choose some options of what gets displayed... Andrej ...Show All

• Visual FoxPro problem with class

  i get the error ole error class is not registered...... what does this mean and how do i fix it i read the vfp help files on it but it was too confusing for me. First, you need to know what ActiveX control is causing the OLE error. Then determine what file its contained in, its usually an OCX or DLL file, i.e. COMCTL32.OCX. Then run the following command either using Start->Run or using the command prompt - REGSVR32 COMCTL32.OCX ...Show All