public static void ExportEachNumberOccurencesToMathematicaMatrix(SQLUtils.ConnectionString con, string Path, int Rows, int Columns)
{
StringBuilder sb = new StringBuilder();
int k = 1;
sb.Append("{");
for (int j = 0; j < Rows; j++) //rows
{
for (int i = 0; i < Columns; i++) //columns
{
if (i == 0)
{
sb.Append("{");
}
sb.Append(SQLQueries.procedure_CountEachNumberOccurencesOutput(con.ToString(), k++));
if (i != Columns - 1)
{
sb.Append(", ");
}
else
{
sb.Append("}");
}
}
if (j != Rows - 1)
{
sb.Append(",");
}
}
System.IO.StreamWriter file = new System.IO.StreamWriter(Path);
sb.Append("}");
file.WriteLine(sb.ToString());
file.Close();
}
public ExportDrawsToSQL(string serverName, string databaseName, bool trustedConnection, string tableName)
{
if (tableName == null)
{
throw new ArgumentException(string.Format("Class {0} requires a SQLUtils.Connection string with non-null tableName.", "ExportDrawsToSQL"));
}
this.connectionString = new SQLUtils.ConnectionString(serverName, databaseName, trustedConnection, tableName);
}
// Constructors
public ExportDrawsToSQL(SQLUtils.ConnectionString ConnString)
{
if (ConnString.tableName == null)
{
throw new ArgumentException(string.Format("Class {0} requires a SQLUtils.ConnectionString with non-null tableName.", "ExportDrawsToSQL"));
}
this.connectionString = ConnString;
}
