private void convert(String tableName)
{
//get row count
///-------------------------------------------------------
using (var sqlCon = new SqlConnection(Connection.PropConnString)) {
sqlCon.Open();
var com = sqlCon.CreateCommand();
com.CommandText = "select * from " + tableName;
using (var reader = com.ExecuteReader()) {
//here you retrieve what you need
}
com.CommandText = "select @@ROWCOUNT";
int totalRowa = Convert.ToInt32(com.ExecuteScalar());
totalrow.setv(totalRowa);
sqlCon.Close();
}
// MessageBox.Show(">> " + totalRow);
///-----------------------------------------------------------------------
//write(tableName,
// "SET SQL_MODE = \"NO_AUTO_VALUE_ON_ZERO\";" +
// "\nSET time_zone = \"+00:00\";");
write(tableName, string.Format("\nCREATE TABLE IF NOT EXISTS `{0}` (", tableName));
//this will creating the table
List <string> columnsANDTypes = ColumnNamesANDTypes.getColumnNameANDType(tableName);
int size = columnsANDTypes.Count;
int inc = 0;
foreach (string column in columnsANDTypes)
{
inc++;
write(tableName, "\t" + column + ((inc < size) ? "," : ""));
}
FileManagerTask.writeFile(fileLocation_txt.Text, tableName, ");");
//this will inerting data into a created table
List <string> names = ColumnNames.getColumnName(tableName);
write(tableName, string.Format("INSERT INTO `{0}` (", tableName));;
inc = 0;
foreach (string name in names)
{
inc++;
write(tableName, "\t`" + name + "`" + ((inc < size) ? "," : ""));
}
write(tableName, ") VALUES");
int row = AllData.getAllDAta(backgroundWorker, fileLocation_txt.Text, names, tableName, tableName, ColumnTypes.getColumnTypes(tableName));
}
private static void write(string dir, string fi, string towrite)
{
FileManagerTask.writeFile(dir, fi, towrite);
}
private void write(string fileName, string towrite)
{
FileManagerTask.writeFile(fileLocation_txt.Text, fileName, towrite);
}