public CDB()
{
ConnString = Properties.Settings.Default.ConnectString;
Adocon = new SqlConnection(ConnString);
}
/// <summary>建立基本联接，失败置ENABLE为FALSE </summary>
/// <returns>建立连接过程返回的布尔值(True/False)</returns>
private bool ConnectDB()
{
bool LoopEr = true;
do
{
try
{
if (Adocon.State != System.Data.ConnectionState.Open)
{
Adocon.Open();
}
}
catch (SqlException e)
{
for (int i = 0; i < e.Errors.Count; i++)
{
ErrInfo += "错误序号：" + i + "\n" + "出错信息：" + e.Errors[i].Message + "\n" + "出错来源：" + e.Errors[i].Source + "\n" + "程序：" + e.Errors[i].Procedure;
}
DialogResult ReturnButton = MessageBox.Show(ErrInfo+"连接数据源失败！是否重试？" , "提示", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (ReturnButton == DialogResult.Yes)
{
LoopEr = true;
}
else
{
LoopEr = false;
ClassEnable = false;
return ClassEnable;
}
}
}
while (LoopEr !=true );
ClassEnable = true;
return ClassEnable;
}
/// <summary>关闭链接</summary>
public void DisconnectDB()
{
if( Adocon.State !=ConnectionState.Closed )
{
Adocon.Close();
}
}
/// <summary>校验连接,成功返回TRUE，失败返回FALSE</summary>
private bool CheckConnect()
{
DialogResult ReturnButton;
if (ClassEnable == true && Adocon.State == System.Data.ConnectionState.Open)
{
return true;
}
else
{
if (ClassEnable == false)
{
ReturnButton = MessageBox.Show("数据库连接已经被禁用，是否重新启用它？\n\n【注意】该连接未知原因被禁用，重新启用可能造成危害性后果！", "提示", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (ReturnButton == DialogResult.Yes)
{
ClassEnable = true;
//return Enable; 不可以返回
}
else
{
ErrInfo = "数据库连接已经被禁用！";
return false;
}
}
if (Adocon.State != ConnectionState.Open)
{
switch (Adocon.State)
{
case ConnectionState.Broken:
ErrInfo = "与数据源的连接中断！";
ReturnButton = MessageBox.Show(ErrInfo +"是否重新打开它？", "请您确定", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (ReturnButton == DialogResult.Yes)
{
return ConnectDB();
}
else
{
return false;
}
case ConnectionState.Closed:
ErrInfo = "数据源的连接处于关闭状态！";
ReturnButton = MessageBox.Show(ErrInfo + "是否连接它？", "请您确定", MessageBoxButtons.YesNoCancel, MessageBoxIcon.Question);
if (ReturnButton == DialogResult.Yes)
{
return ConnectDB();
}
else
{
return false;
}
case ConnectionState .Connecting:
ErrInfo = "连接对象正在与数据源进行连接！";
ReturnButton = MessageBox.Show(ErrInfo+"暂无法执行此操作。", "提示", MessageBoxButtons.OK , MessageBoxIcon.Question);
return false;
case ConnectionState.Executing:
ErrInfo = "连接对象正在执行其他命令！";
ReturnButton = MessageBox.Show(ErrInfo+"暂无法执行此操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
return false;
case ConnectionState.Fetching:
ErrInfo = "连接对象正在执行其他命令！";
ReturnButton = MessageBox.Show(ErrInfo + "暂无法执行此操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
return false;
default:
ErrInfo = "发生数据源连接的未知异常！";
ReturnButton = MessageBox.Show(ErrInfo + "暂无法执行此操作。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Question);
return false;
}
}
else //不可能。
{
MessageBox.Show("应用程序逻辑错误！请与程序供应商联系！【类名】——" + Caption , "提示信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
return false;
}
}
}
public void FillGridView(DataGridView DataGridView1,string TableName) //用于表格绑定
{
ConnectDB();
Dad = new SqlDataAdapter(SqlString, Adocon);
Ds = new DataSet();
Dad.Fill(Ds,TableName);
DataGridView1.DataSource = Ds.Tables[TableName].DefaultView;
}
