public static bool ContrastColumns(DataColumnCollection co1, DataGridViewColumnCollection co2)
{
bool aa = false;
if (co1.Count == co2.Count)
{
for (int i = ; i < co1.Count; i++)
{
if (co1[i].Caption != co2[i].Name)
{
aa = false;
break;
}
else
{
aa = true;
}
}
return aa;
}
else
return false;
}
public static string DataGridViewToDB(DataGridView DGV, string connstr, string Tablestr)
{
int aa = ;
string mycmd = "select * from " + Tablestr;
DataTable dt = SqlHelper.SQLCommand<DataTable>(mycmd, connstr);
if (ContrastColumns(dt.Columns, DGV.Columns))
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into " + Tablestr + "(");
for (int i = ; i < DGV.ColumnCount; i++)
{
if (i == DGV.ColumnCount - )
{
sb.Append(DGV.Columns[i].Name + ") values (");
}
else
{
sb.Append(DGV.Columns[i].Name + ",");
}
}
foreach (DataGridViewRow dgvRow in DGV.Rows)
{
StringBuilder mysb = new StringBuilder();
mysb.Append("select * from " + Tablestr + " where ");
StringBuilder sb2 = new StringBuilder();
for (int i = ; i < dgvRow.Cells.Count; i++)
{
if (i == )
{
mysb.Append(DGV.Columns[i].Name + "='" + dgvRow.Cells[i].Value + "'");
}
else
{
mysb.Append(" and " + DGV.Columns[i].Name + "='" + dgvRow.Cells[i].Value + "'");
}
if (i == dgvRow.Cells.Count - )
{
sb2.Append("'" + dgvRow.Cells[i].Value + "')");
}
else
{
sb2.Append("'" + dgvRow.Cells[i].Value + "',");
}
}
string sqlcmd = sb.ToString() + sb2.ToString();
try
{
DataTable mydt = SqlHelper.SQLCommand<DataTable>(mysb.ToString(), connstr);
if (mydt.Rows.Count == )
{
SqlHelper.SQLCommand<int>(sqlcmd, connstr);
aa++;
}
}
catch (Exception ee)
{
ee.ToString();
}
}
return "迁移成功:共" + aa.ToString() + "条记录";
}
else
return "迁移失败:表头不匹配";
}