I am trying to populate a dataset with the results of an SQL Query...then...display those results in a browser, using XML and HTML.
public
static void naming()
{
string query = "SELECT * FROM tbl_File_Health_Check " + //@Sql statement stored in variable query
"WHERE (File_Name LIKE '%~%' " +
"or file_name Like '%#%'" +
"or file_name Like '%&%'" +
"or file_name Like '%*%'" +
"or file_name Like '%{%'" +
"or file_name Like '%}%'" +
"or file_name Like '%\\%'" +
"or file_name Like '%:%'" +
"or file_name Like '%<%'" +
"or file_name Like '%>%'" +
"or file_name Like '%?%'" +
"or file_name Like '%/%'" +
"or file_name Like '%+%'" +
"or file_name Like '%|%'" +
"or file_name Like '%[%]%')"+
"ORDER BY File_Name";
using (SqlConnection conn = new SqlConnection("Server=ServerName;Database=File_Health_Check;Trusted_Connection=True;")) //constructs SqlConnection object and stores Database Connection string
{
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
/*SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Console.SetWindowSize(100, 59);
Console.SetWindowPosition(0, 0);
Console.WriteLine(String.Format("{0}, {1}, {2}, {3}, {4}, {5}, {6}",
reader[0], reader[1], reader[2], reader[3], reader[4], reader[5], reader[6]));
}
Console.WriteLine("");*/
try
{
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
adapter.Fill(ds);
ds.DataSetName =
"Queries";
ds.Tables[0].TableName =
"Naming Conventions";
DirectoryInfo tempDir = new DirectoryInfo("C:\\");
tempDir.CreateSubdirectory(
"tempWeb");
XmlDataDocument Xmldoc = new XmlDataDocument(ds);
XslCompiledTransform Xmltransform = new XslCompiledTransform();
FileInfo tempFile = new FileInfo(@"C:\tempWeb\Queries.xsl");
if (tempFile.Exists)
{
tempFile.Delete();
}
tempFile.Create();
FileStream FileStore = tempFile.Open(FileMode.OpenOrCreate, FileAccess.ReadWrite, FileShare.Read);
FileStore.Close();
StreamWriter writer = new StreamWriter(@"C:\tempWeb\Queries.html");
writer.Close();
Xmltransform.Load(
@"C:\tempWeb\Queries.xsl");
Xmltransform.Transform(Xmldoc,
null, writer);
//reader.Close();
conn.Close();
}
catch (DirectoryNotFoundException e)
{
Console.WriteLine(e.Message);
}
catch (IOException e)
{
Console.WriteLine(e.Message);
}
catch (XsltException e)
{
Console.WriteLine(e.Message);
}
}
Console.WriteLine("Database Read...");
}
The break occurs when trying to load the.Xsl file with this statement.
Xmltransform.Load(@"C:\tempWeb\Queries.xsl");
I've tried closing "tempFile" after creation...however there is no method definition for Close(); with FileInfo.
To achieve some form of File closure...I stored "tempFile" within Filestream. this however did not work.
any help would be great.