protected void btnDatabaseMigration_Click(object sender, EventArgs e)
{
string str = string.Empty;
DataSet ds1 = new DataSet();
DataView dv;
foreach (ListItem li in TableCheckBoxList.Items)
{
if (li.Selected)
{
MySqlConnection myconn3;
string abc = "";
abc = "Data Source=localhost;Initial Catalog=" + lblMySqlDB.Text + ";user id=root;password=root";
myconn3 = new MySqlConnection(abc);
myconn3.Open();
str = li.ToString();
string query = "Select " + str + " from " + lblMySqlDB.Text + "." + Label5.Text + "";
MySqlDataAdapter mydata = new MySqlDataAdapter(query, myconn3);
DataTable dTable = new DataTable();
mydata.Fill(ds1, str);
dv=ds1.Tables[0].DefaultView;
DataTable table = ds1.Tables[0];
dv.Sort = "" + str + " DESC";
myconn3.Close();
}
foreach (DataTable dt in ds1.Tables)
{
}
if (ds1.Tables.Count > 0)
{
string strForSqlServer = string.Empty;
DataSet dsForSqlServer = new DataSet();
foreach (ListItem listOFSQL in CheckBoxIntellectTableData.Items)
{
if (listOFSQL.Selected)
{
SqlConnection sqlconForMigration;
foreach (DataRow dr in ds1.Tables[0].Rows)
{
sqlconForMigration = new SqlConnection(strIn);
sqlconForMigration.Open();
strForSqlServer = listOFSQL.ToString();
string query = "insert into " + lblSqlTableName.Text + "(" + strForSqlServer + ") values ('" + dr[0].ToString() + "')";
SqlCommand cmd = new SqlCommand(query, sqlconForMigration);
cmd.ExecuteNonQuery();
sqlconForMigration.Close();
}
}
}
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "alertMessage", "alert('Record Added In MSSQL Table')", true);
}
}
}