private void ExportCSV(string tableName) { string constr = SingleConnection.Connect(txt_ServerName.Text, txt_Database.Text, txt_UserName.Text, txt_Password.Text); string csv = string.Empty; using (SqlConnection con = new SqlConnection(constr)) { using (SqlCommand cmd = new SqlCommand("SELECT * FROM " + tableName)) { using (SqlDataAdapter sda = new SqlDataAdapter()) { cmd.Connection = con; sda.SelectCommand = cmd; using (DataTable dt = new DataTable()) { sda.Fill(dt); foreach (DataColumn column in dt.Columns) { csv += column.ColumnName + ','; } csv += "\r\n"; foreach (DataRow row in dt.Rows) { foreach (DataColumn column in dt.Columns) { csv += row[column.ColumnName].ToString().Replace(",", ";") + ','; } csv += "\r\n"; } } } } } WriteIntoFile("Tables", tableName, csv, "csv"); }
private void Cmd_Start_Click(object sender, EventArgs e) { txt_Log.Clear(); if (ConnectionValidation()) { cmd_Clear.Enabled = false; connectionString = SingleConnection.Connect(txt_ServerName.Text, txt_Database.Text, txt_UserName.Text, txt_Password.Text); using (connection = new SqlConnection(connectionString)) { try { connection.Open(); SqlCommand cmd = new SqlCommand(";WITH ROUTINES AS ( SELECT o.type_desc AS ROUTINE_TYPE ,o.[name] AS ROUTINE_NAME ,m.definition AS ROUTINE_DEFINITION FROM sys.sql_modules AS m INNER JOIN sys.objects AS o ON m.object_id = o.object_id ) SELECT * FROM ROUTINES", connection) { CommandType = CommandType.Text }; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { WriteIntoFile(reader.GetString(0), reader.GetString(1), reader.GetString(2)); } } WriteLog("Process completed"); } catch (Exception ex) { connection = null; WriteLog("Connection failed. Pleasecheck the inputs"); } finally { if (connection != null && connection.State == ConnectionState.Open) { connection.Close(); } } } WriteTables(); WriteLog("OverAll Completed"); cmd_Clear.Enabled = true; MessageBox.Show("OverAll Completed"); Application.Exit(); } }
private void FillTablesList() { chk_TableList.Items.Clear(); connectionString = SingleConnection.Connect(txt_ServerName.Text, txt_Database.Text, txt_UserName.Text, txt_Password.Text); using (connection = new SqlConnection(connectionString)) { try { connection.Open(); SqlCommand cmd = new SqlCommand("SELECT DISTINCT NAME FROM SYS.TABLES WHERE TYPE = 'U'", connection) { CommandType = CommandType.Text }; SqlDataReader reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { chk_TableList.Items.Add(reader.GetString(0)); } } WriteLog("Table list added"); } catch (Exception ex) { connection = null; WriteLog("Connection failed. Pleasecheck the inputs"); } finally { if (connection != null && connection.State == ConnectionState.Open) { connection.Close(); } } } }
private bool ConnectionValidation() { if (!string.IsNullOrEmpty(txt_ServerName.Text) && !string.IsNullOrEmpty(txt_Database.Text) && !string.IsNullOrEmpty(txt_UserName.Text) && !string.IsNullOrEmpty(txt_Password.Text)) { try { cmd_Clear.Enabled = false; txt_Log.Clear(); connectionString = SingleConnection.Connect(txt_ServerName.Text, txt_Database.Text, txt_UserName.Text, txt_Password.Text); connection = new SqlConnection(connectionString); connection.Open(); WriteLog("Connected."); cmd_Clear.Enabled = true; isConnected = true; return(true); } catch (Exception ex) { connection = null; WriteLog("Connection failed. Please check the connection inputs"); } finally { if (connection != null && connection.State == ConnectionState.Open) { connection.Close(); } cmd_Clear.Enabled = true; } } else { WriteLog("Connection failed. Please check the connection inputs"); } return(false); }