You searched for the word(s): userid:780234

More Search Options

RSS Available

• Windows SDK console session

  How do you start a Windows SDK console session? I don't see CMD Shell under Start, All Programs, Microsoft Windows SDK v6.0A, Tools.

  Posted to Visual Studio 2008 (Forum) by MJ20 on 10/25/2008

• Populate Multiple Ctrls From Multiple Resultsets

  I'm populating multiple controls from an xml file that contains multiple resultsets. The controls are only being populated with the first record in each resultset. How do I get the controls to be populated with the rest of the data in the resultsets? public DALClass myDAL; myDAL = new DALClass (); string myobject = myDAL.GetXmlDataMultTbls(); //returns xml resultsets XmlDocument doc = new XmlDocument (); doc.LoadXml(myobject); doc.Save(Server.MapPath( "myXMLFile.xml" )); XmlNodeList

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 8/12/2008

• Re: Load XML file From Sproc

  Is it possible to return multiple result sets using the FOR XML to fill an xml file in my app? It works fine when returning only one result set. I've tried: object obj = com. ExecuteNonQuery (); object obj = com. ExecuteReader (); object obj = com. ExecuteXmlReader ();

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/15/2008

• Re: Load XML file From Sproc

  That's it, thank you!!!!

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/15/2008

• Re: Load XML file From Sproc

  Here's the GetXml method: public DataSet GetXml() { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(strConn); con.Open(); SqlCommand sc = new SqlCommand(); sc.Connection = con; sc.CommandType = CommandType.Text; sc.CommandText = "dbo.GetCustNames"; SqlDataAdapter myReader = new SqlDataAdapter(sc); myReader.Fill(ds); ds.WriteXml(HttpContext.Current.Server.MapPath("NamesXml.xml")); con.Close(); con = null; return ds; } myDAL = new DALClass(); string NamesDs

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/11/2008

• Re: Load XML file From Sproc

  I set a break point on the following line: doc.Save(writer); and I'm getting the following value for NamesDs: "<?xml version=\"1.0\" standalone=\"yes\"?><db><dbname name=\"ReportServer\"/><dbname name=\"ReportServerTempDB\"/><dbname name=\"Reporting\"/></db>" I'm not getting the escape keys when I run the sproc in SQL Server. SELECT custname as "@name" FROM CustomerNames FOR XML PATH

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/10/2008

• Re: Load XML file From Sproc

  The value of NamesDS is: "<?xml version=\"1.0\" standalone=\"yes\"?><db><dbname name=\"ReportServer\"/><dbname name=\"ReportServerTempDB\"/><dbname name=\"Reporting\"/></db>" even when I use the .Replace method below to try to remove the \ I'm getting the error Root element is missing. myDAL = new DALClass (); string NamesDs = myDAL.GetXml(); //returns xml resultset NamesDs = "<?xml version

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/9/2008

• Re: Load XML file From Sproc

  How do you include the following in the query? <? xml version = " 1.0 " standalone = " yes " ?>

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/8/2008

• Re: Load XML file From Sproc

  Thank you! That's really cool. The only thing is... how do I use it to populate my xml file in my application?

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/8/2008

• Load XML file From Sproc

  Hi. I know how to load a GridView from an xml file that already has data in it. How do you load data from a stored procedure into the xml file? Thanks

  Posted to XML and XmlDataSource Control (Forum) by MJ20 on 5/8/2008