private void GetSection(string sName)
{
if (ConfigObj != null)
{
MyKeyValueSetting oneSetting = ConfigObj.Section[sName];
//解析connectionstring,server=WINDYCOMPUTER\TESTDB;database=CIS_TEST;uid=sa;pwd=winning
//edtShowFields.Text = oneSetting.column;
//edtShowTable.Text = oneSetting.table;
SetConnectString(oneSetting.ConnectString);
//表格
gcShow.DataSource = null;
gcShow.RefreshDataSource();
List <TableFields> showData = new List <TableFields>();
string[] tableArray = oneSetting.table.Split(';');
string[] fieldArray = oneSetting.column.Split(';');
for (int i = 0; i < tableArray.Length; i++)
{
TableFields item = new TableFields();
item.sTableName = tableArray[i];
item.sFields = fieldArray[i];
showData.Add(item);
}
gcShow.DataSource = showData;
gcShow.RefreshDataSource();
}
}
private void btnSure_Click(object sender, EventArgs e)
{
if (comBoxLink.SelectedIndex < 0)
{
MessageBox.Show("请选择数据链接！");
return;
}
currConnection = ConfigObj.Section[comBoxLink.SelectedItem.ToString()];
this.DialogResult = DialogResult.OK;
this.Close();
}
private void btnAddDataBase_Click(object sender, EventArgs e)
{
if (edtName.Text == "")
{
MessageBox.Show("请输入链接名称");
return;
}
if (edtServer.Text == "")
{
MessageBox.Show("请输入服务名");
return;
}
if (edtDataBase.Text == "")
{
MessageBox.Show("请输入数据库名");
return;
}
if (edtUserName.Text == "")
{
MessageBox.Show("请输入用户名");
return;
}
if (comBoxLink.Properties.Items.Contains(edtName.Text))
{
MessageBox.Show("该链接名称已存在！");
return;
}
string sConnect = "server=" + edtServer.Text + ";database=" + edtDataBase.Text + ";uid=" + edtUserName.Text + ";pwd=" + edtPassWord.Text;
MyKeyValueSetting addSetting = new MyKeyValueSetting();
addSetting.ConnectString = sConnect;
addSetting.name = edtName.Text;
string[] sRetArray = GetStringArrayByList(gcDetail.DataSource as List <TableFields>);
addSetting.table = sRetArray[0];
addSetting.column = sRetArray[1];
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
DataBaseSection currSection = (DataBaseSection)config.GetSection("DataBaseSections");
currSection.Section.Add(addSetting);
config.Save(ConfigurationSaveMode.Modified);
ConfigurationManager.RefreshSection("DataBaseSections");
SetComBox();
MessageBox.Show("添加成功");
}
// 说明：如果不需要在代码中修改集合，可以不实现Add， Clear， Remove
public void Add(MyKeyValueSetting setting)
{
this.BaseAdd(setting);
}