private void button1_Click(object sender, EventArgs e)
{
Globals.Sheet1.namedRange1.Validation.Delete();
System.Text.StringBuilder Sql = new StringBuilder ("");
string Sqlcheck="";
CheckBox[] myCheck = new CheckBox[8];
myCheck[0] = chcek50;
myCheck[1] = checkALUK;
myCheck[2] = checkHL828;
myCheck[3] = checkDQ;
myCheck[7] = checkHJ;
myCheck[5] = checkXY802;
myCheck[6] = checkXY828;
myCheck[4] = checkBox7;
for (int i = 0; i < 8; i++)
{
if (myCheck[i].Checked )
{
Sql.Append("(xilie = '" + myCheck[i].Text + "') OR ");
}
}
try
{
Sqlcheck = Sql.ToString().Substring(0, Sql.Length - 3);
} catch
{
MessageBox.Show("定料提醒框", "数据有效性已成功清除"); //需要在这里加一条事件结束语句,不在执以下语句直接跳出此事件过程,不要GOTO,.Exit().Close()试过不行,谢谢
}
StringBuilder sItem = new StringBuilder();
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\db1.mdb";
connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0";
OleDbConnection con = new OleDbConnection(connectStringBuilder.ConnectionString);
con.Open();
OleDbCommand com = con.CreateCommand();
com.CommandText =
"SELECT xincaiID FROM [型材列表] WHERE"+Sqlcheck ; OleDbDataReader thisReader = com.ExecuteReader();
while (thisReader.Read())
{
sItem.Append(thisReader.GetValue(0));
sItem.Append(",");
}
String s1 = sItem.ToString().TrimEnd(','); Globals.Sheet1.namedRange1.Validation.Add(Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle.xlValidAlertStop, Excel.XlFormatConditionOperator.xlBetween, s1, Type.Missing); thisReader.Close();
con.Close();
}
}
}
{
Globals.Sheet1.namedRange1.Validation.Delete();
System.Text.StringBuilder Sql = new StringBuilder ("");
string Sqlcheck="";
CheckBox[] myCheck = new CheckBox[8];
myCheck[0] = chcek50;
myCheck[1] = checkALUK;
myCheck[2] = checkHL828;
myCheck[3] = checkDQ;
myCheck[7] = checkHJ;
myCheck[5] = checkXY802;
myCheck[6] = checkXY828;
myCheck[4] = checkBox7;
for (int i = 0; i < 8; i++)
{
if (myCheck[i].Checked )
{
Sql.Append("(xilie = '" + myCheck[i].Text + "') OR ");
}
}
try
{
Sqlcheck = Sql.ToString().Substring(0, Sql.Length - 3);
} catch
{
MessageBox.Show("定料提醒框", "数据有效性已成功清除"); //需要在这里加一条事件结束语句,不在执以下语句直接跳出此事件过程,不要GOTO,.Exit().Close()试过不行,谢谢
}
StringBuilder sItem = new StringBuilder();
OleDbConnectionStringBuilder connectStringBuilder = new OleDbConnectionStringBuilder();
connectStringBuilder.DataSource = System.AppDomain.CurrentDomain.SetupInformation.ApplicationBase + "\\db1.mdb";
connectStringBuilder.Provider = "Microsoft.Jet.OLEDB.4.0";
OleDbConnection con = new OleDbConnection(connectStringBuilder.ConnectionString);
con.Open();
OleDbCommand com = con.CreateCommand();
com.CommandText =
"SELECT xincaiID FROM [型材列表] WHERE"+Sqlcheck ; OleDbDataReader thisReader = com.ExecuteReader();
while (thisReader.Read())
{
sItem.Append(thisReader.GetValue(0));
sItem.Append(",");
}
String s1 = sItem.ToString().TrimEnd(','); Globals.Sheet1.namedRange1.Validation.Add(Excel.XlDVType.xlValidateList, Excel.XlDVAlertStyle.xlValidAlertStop, Excel.XlFormatConditionOperator.xlBetween, s1, Type.Missing); thisReader.Close();
con.Close();
}
}
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货