private void FrmProgramParameterSub_Load(object sender, EventArgs e)
{
string tempvar;
MyModules.applyGridTheme(dGrid);
dGrid.Columns[0].Width = 50;
dGrid.Columns[1].Width = 60;
for (int h = 1; h <= mlevel; h = h + 1)
{
dGrid.Rows.Add();
dGrid[0, dGrid.Rows.Count - 1].Value = h;
int g = mPercentageStr.IndexOf(",");
if (g > 0)
{
tempvar = MyModules.GetIt4Me(mPercentageStr, ",");
dGrid[1, dGrid.Rows.Count - 1].Value = tempvar;
mPercentageStr = MyModules.Mid(mPercentageStr, g + 1, -1);
}
else
{
dGrid[1, dGrid.Rows.Count - 1].Value = mPercentageStr;
}
}
}
private void cmdAttach_Click(object sender, EventArgs e)
{
try
{
string connectStr = null;
if (string.IsNullOrEmpty(txtDBName.Text.Trim()))
{
MessageBox.Show("Pls. select the database", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
if (chkWinAuthen.Checked)
{
connectStr = "workstation id=" + cboServerName.Text + ";packet size=4096;data source=" + cboServerName.Text + ";Integrated Security=True;initial catalog=master";
}
else
{
connectStr = "workstation id=" + cboServerName.Text + ";packet size=4096;user id=" + txtUserID.Text + ";pwd=" + txtPassword.Text + ";data source=" + cboServerName.Text + ";persist security info=False;initial catalog=master";
}
SqlConnection SqlCn = new SqlConnection(connectStr);
SqlCn.Open();
if (txtAttachName.Text.Trim().Length == 0)
{
MessageBox.Show("Pls. choose a valid data file", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
// ERROR: Not supported in C#: OnErrorStatement
//'Dim myTrans As SqlTransaction
//'myTrans = SqlCn.BeginTransaction(IsolationLevel.Serializable, "MyTrans")
SqlCommand myCommand = new SqlCommand("FetchUserAccessByPwd", SqlCn);
//'myCommand.Transaction = myTrans
myCommand.CommandText = "EXEC sp_detach_db @dbname = '" + cboavaliableDB.Text + "'";
myCommand.ExecuteNonQuery();
// ERROR: Not supported in C#: OnErrorStatement
myCommand.CommandText = "EXEC sp_attach_db @dbname = N'" + txtAttachName.Text + "',@filename1 = N'" + txtDBName.Text.Trim() + "',@filename2 = N'" + MyModules.Mid((txtDBName.Text.Trim()), 1, Microsoft.VisualBasic.Strings.InStr(txtDBName.Text.Trim(), ".") - 1) + ".ldf" + "'";
myCommand.ExecuteNonQuery();
//'myTrans.Commit()
myCommand.Connection.Close();
myCommand.Dispose();
SqlCn.Close();
SqlCn.Dispose();
MessageBox.Show("Successfully Attached", MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
catch (Exception er)
{
MessageBox.Show(er.Message, MyModules.strApptitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
