rendered paste bodyprotected void Page_Load(object sender, EventArgs e)
{
this.torrentResults = new SearchQuery();
this.searchQuery = Request.QueryString["query"];
if (searchQuery != null)
{
XmlSerializer resultSerializer = new XmlSerializer(typeof(SearchQuery));
String mySelectQuery = "call search(\"" + this.searchQuery + "\")";
MySqlConnection myConnection = new MySqlConnection(myConnString);
MySqlCommand myCommand = new MySqlCommand(mySelectQuery, myConnection);
myConnection.Open();
MySqlDataReader searchResultReader = myCommand.ExecuteReader();
try
{
while (searchResultReader.Read())
{
String torrentID = searchResultReader.GetString(0);
String fileID = searchResultReader.GetString(1);
Debug.WriteLine(torrentID + " file: " + fileID);
this.torrentResults.AddResult(this.PopulateTorrent(Int32.Parse(torrentID), fileID));
}
}
finally
{
searchResultReader.Close();
myConnection.Close();
}
resultSerializer.Serialize(new FileStream("test.xml", FileMode.Create), this.torrentResults);
if (XMLWriteToBuffer("test.xml"))
{
return;
}
}
else
{
SearchQueryNotFound(this.searchQuery);
return;
}
}