Hi All I am trying to generate code from one of my xml schema using Xsd.exe. it throws the following error: C:\>xsd C:\statement.xsd /c /l:cs Microsoft (R) Xml Schemas/DataTypes support utility [Microsoft (R) .NET Framework, Version 2.0.50727.42] Copyright (C) Microsoft Corporation. All rights reserved. Error: Error generating classes for schema 'C:\statement'. - Group 'value' from targetNamespace='http://www.xyz.com/statement' has invalid definition: Circular group reference. If you would like more help, please type "xsd /?". Is there any solution for the problem with Circular group reference?

Gokulan

Hi All, Is there any open source tool like Castor(for java) to convert XML/Schema to C# classes in .NET other than xsd.exe? Thanks in Advance.

Gokulan

Hi All, Is there any open source tool like Castor(for java) to convert XML/Schema to C# classes in .NET other than xsd.exe? Thanks in Advance.

Gokulan

Hi all How to insert an EMF file in to the MS EXCEL Sheet by drag and drop. What's the appropreate dataformat for SetData method. Iam able drop Bitmap images in to the sheet but could not do it using DataFormats.MetafilePict. Gokul

Hi, First get the active word application and iterate thru the Documents. private void IterateWordDocs() { //Iterate docs foreach (Microsoft.Office.Interop.Word.Document doc in WordApp.Documents) { //Your doc name doc.Name == "YourDocName" } } Regards Gokul

I think there is some problem in ur conn string. Connection string must contain SERVER=myIP;user id=myuserid;password=myPwd;DATABASE=MyDatabaseName Gokul

Hi It will be helpful if you provide the exact xml format you want. You can use the XmlTextWriter and loop thru the dataset for creating the exact structure and data. Gokul

You can load the xml in to a XmlDocument object and do the changes in it by using the Select single node method. And finally save the document. Gokul

You can iterate thru the Selected ListViewItem Collection and add/ remove items Here is the code to remove the selected items. foreach(ListViewItem li in lstViewResultSet.SelectedItems) { li.Remove(); } hope this will help you. Gokul

Hii You can use Update method of the DataAdapter and AcceptChanges method of DataSet to update the data source.

I have some problem with smart tags. In my Smart tag action I am loading an XmlDocument with more than 100 KB of data. When the event is fires the system is not responding. Is there any limit for the Response packet? I am using Visio/Word as my Host application. It works fine when the size is below 50 K. Any idea? Thanks in advance. Gokulan Venat:(

Hii, Here the piece of code all you need. You must the same DataSet and DataAdapter for the update operation. private void UpdateData() { if (myDataSet.HasChanges()) { adapter.Update(ds.Tables[0]); myDataSet.AcceptChanges(); } } private void LoadData() { conn = new OleDbConnection(ConnectionString); conn.Open(); selCommand = new OleDbCommand("SELECT * FROM EMP",conn); adapter = new OleDbDataAdapter(selCommand); builder = new OleDbCommandBuilder(adapter); myDataSet = new DataSet(); adapter.Fill(myDataSet); dataGrid1.DataSource = myDataSet.Tables[0]; } You can pass the OleDbDataAdapter,DataSet to your DAL method. Regards, Gokulan

:)Hi, Hope this piece of code will help you. //Add the Microsoft Word 11.0 Object Library Reference using System.Runtime.InteropServices; using Microsoft.Office.Interop.Word; //Fields private object objSave = false; private object objOrgFormat; private object objRouteDoc; private void IterateWordDocs() { //Get the active Word Application GetWordApplication() //Iterate docs foreach (Microsoft.Office.Interop.Word.Document doc in WordApp.Documents) { if(doc.Name == "YourDocName") doc.Close(ref objSave,ref objOrgFormat,ref objRouteDoc); } } public void GetWordApplication() { Type typeVisioApp = Type.GetTypeFromProgID("Word.Application"); object objWord = Marshal.GetActiveObject("Word.Application"); this.WordApp = (Microsoft.Office.Interop.Word.Application) Marshal.CreateWrapperOfType (objWord, typeVisioApp); } Regards Gokulan -- modified at 2:03 Wednesday 28th December, 2005

Hi all, Is there a way to disable a treenode ?, by 'disable' i mean mean that the node a should not be able to perform any kind of operation on the tree node. Thanks in advance, Gokul.