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);