-
Archives
- March 2013
- February 2012
- January 2012
- September 2011
- May 2011
- April 2011
- September 2010
- May 2010
- April 2010
- January 2010
- December 2009
- November 2009
- October 2009
- September 2009
- August 2009
- June 2009
- May 2009
- April 2009
- March 2009
- February 2009
- January 2009
- December 2008
- November 2008
- October 2008
- September 2008
- August 2008
- July 2008
- June 2008
- May 2008
- December 2007
- July 2007
- June 2007
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
- January 2006
- November 2005
- October 2005
- September 2005
- August 2005
- July 2005
- June 2005
- May 2005
- April 2005
- March 2005
- February 2005
- January 2005
- December 2004
- October 2004
- August 2004
- July 2004
- June 2004
- December 1969
-
Meta
Monthly Archives: October 2004
Using XPath to narrow results from an XML file
// These two lines read config setting from the app.config file. filename = ConfigurationSettings.AppSettings["inputfile"]; filter = Configu rationSettings.AppSettings["filter1"]; XmlDataDocument myDocument = new XmlDataDocument(); myDocument.Load(filename); XmlNodeList myList = myDocument.SelectNodes(“//item[@class='" + filter + "']/*”); for (int i=0; i < myList.Count; i++) { … Continue reading
Posted in C# Snippets
Comments Off
Create a DataSet from a Stored Procedure
SqlConnection myConn = new SqlConnection(ConnectionString); SqlDataAdapter da = new SqlDataAdapter(); ds.SelectCommand = new SqlCommand(“GetByOffice”,myConn); da.SelectCommand.CommandType=CommandType.StoredProcedure; SqlParameter myParam = new SqlParameter(“@Office”,SqlDbType.VarChar,50); myParam.Direction=ParameterDirection.Input; myParam.Value = textBox1.Text; da.SelectCommand.Parameters.Add(myParam); DataSet ds = new DataSet(); da.Fill(ds,”results”); dataGrid1.DataSource = ds.Tables["Results"]; ds.WriteXml(“result.xml”,XmlWriteMode.WriteSchema);
Posted in C# Snippets
Comments Off