public bool insertScoreToDB(string departmentName, int classId, DataGridView dgv)
{
//存储过程 proc_InsertScore (@TABLENAME VARCHAR(30),@ColumnNames varchar(300),@Values varchar(300))
//获取全部列名
string dgvHeadText = string.Empty ;
for (int i = 0; i < dgv.Columns.Count; i++)
{
//跳过姓名列
if (dgv.Columns[i].HeaderText == "姓名")
continue;
dgvHeadText += dgv.Columns[i].HeaderText + ",";
}
//由于数据库内班级设定不能为空 故添加班级 反之若无任何数据 则
//dgvHeadText = dgvHeadText.Remove(dgvHeadText.length-1) 扣除最后一个逗号 ‘,’
dgvHeadText += "班级";
using (SqlConnection conn = new SqlConnection(connString))