日期:2014-05-17 浏览次数:20836 次
myCon.Open();
for (int i = 0; i < count; i++)
{
string _selectValue = dataGridView1.Rows[i].Cells[0].EditedFormattedValue.ToString();
if (_selectValue == "True")
{
dr = dt1.Rows[i];
insertToSql(dr, myCon);
}
}
myCon.Close();
private void insertToSql(DataRow dr, OracleConnection myCon)
{
string KC_ShStatus = dr["KC_ShStatus"].ToString();
string KC_INStatus = dr["KC_INStatus"].ToString();
string KC_BOStatus = dr["KC_BOStatus"].ToString();
string KC_POStatus = dr["KC_POStatus"].ToString();
string KC_SAStatus = dr["KC_SAStatus"].ToString();
string GoodsID = dr["IS