C#

<asp:TemplateColumn HeaderText="Part Type"><br />
						<ItemTemplate><br />
							<asp:DropDownList ID="PartType" Runat="server" DataSource = '<%# getDescriptions2 ((string)DataBinder.Eval(Container.DataItem, "PartNumber"))%>' DataTextField = "Description"><br />
							</asp:DropDownList><br />
						</ItemTemplate><br />
					</asp:TemplateColumn>

public object getDescriptions2 (string _PartNumber)<br />
		{<br />
						string SQLString = "SELECT pt.Id, pt.Description, p.ID FROM PartTypes pt INNER JOIN Parts p on pt.ID = p.PartTypeID WHERE p.PartNumber = _PartNumber ORDER by Description";<br />
SqlCommand cmd = new SqlCommand();<br />
			cmd.Connection = new SqlConnection(strConnectSQL);<br />
			cmd.CommandText = SQLString;<br />
			SqlDataAdapter adapter = new SqlDataAdapter(cmd);<br />
			DataSet ds = new DataSet();<br />
			adapter.Fill(ds);<br />
			//Returns entire dataset<br />
			return ds;<br />
//What goes here to say 'this is what is stored in the db?<br />
<br />
		}

Mark Nischalke wrote:

PageSize: Gets or sets the number of records to display on a page in a GridView control.

using System.IO;<br />
<br />
XmlDocument xml = new XmlDocument();<br />
// do important stuff<br />
<br />
using(FileStream fileStream = File.OpenWrite(@"C:\temp\fun.xml"));<br />
{<br />
  xml.Save(fileStream);<br />
  fileStream.Close();<br />
}<br />
// a while later<br />
File.Delete(@"C:\temp\fun.xml"); // crash

XmlDocument xmldoc = new XmlDocument();<br />
            xmldoc.Load(@".\ConfigurationXML.xml");<br />
            ...do some operation<br />
            xmldoc.Save(@".\ConfigurationXML.xml");<br />
<br />
            xmldoc = null;<br />
<br />
            File.Delete(".\\ConfigurationXML.xml");