还是关于sql批量导入的问题，求指教！
现在报了个这样的错！！
然后这段我是这样写的
sql string 数据库 C#
private void bind(string fileName)
{
// int i = 0;
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=2;'";
OleDbConnection con1 = new OleDbConnection(strConn);
con1.Open();
DataTable sheetNames = con1.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
// string sheetname = sheetable.Rows[i]["Table_Name"].ToString();//在这一行有时报错
// MessageBox.Show(sheetname);
// String a1 = "学生基本信息表";
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * From [Sheet1$] ", strConn);
// OleDbDataAdapter da = new OleDbDataAdapter("SELECT * From [Sheet1$] ", strConn);
string[] a = new string[100];
SqlConnection coon = new SqlConnection();
coon.ConnectionString = "data source = .;initial catalog = School; user id = sa;password = 4380364054";
try
{
coon.Open();
Console.WriteLine("数据库连接成功");
button2.Enabled = false;
InData.Enabled = true;
MessageBox.Show("数据库连接成功");
}
catch (Exception ex)
{
Console.WriteLine("数据库连接失败");
MessageBox.Show("操作失败！" + ex.ToString());
}
DataSet ds = new DataSet();
try
{
da.Fill(ds);
this.dataGridView1.DataSource = ds.Tables[0];
// for (int v = 0; v < dataGridView1.Rows.Count; v++) {
string c1 = dataGridView1.Rows.Count.ToString();//获取行数
int c2 = int.Parse(c1);
c2 = c2 - 1;
c1 = c2.ToString();
string a11 = dataGridView1.Rows[0].Cells[1].Value.ToString();//获取 第一行第二列数值 ————Rows行
// ------cells列
MessageBox.Show(a11, c1, MessageBoxButtons.OK, MessageBoxIcon.Information);
int zy = 1;
for (int v = 0; v < c2 ; v++)
{
for (int v1 = 1; v1 <= 17; v1++)
{
string zx;
zx = zy.ToString();
a[v1] = dataGridView1.Rows[v].Cells[v1].Value.ToString();
// MessageBox.Show(a[v1] + "\n" + zy, c1, MessageBoxButtons.OK, MessageBoxIcon.Information);
zy=zy+1;
}
SqlConnection cocn = new SqlConnection("data source = .;initial catalog = School; user id = sa;password = 4380364054;database=School");
// string connStr="data source = .;initial catalog = School; user id = sa;password = 4380364054";
// SqlConnection conn=new SqlConnection(connStr);
//SqlConnection conn=new SqlConnection(coon);
cocn.Open();
SqlCommand cmd = cocn.CreateCommand();
cmd.CommandText= "insert into Student"+"（StuNo，StuName，ClassID，StuSex,StuBornDate,StuNation,Status,IdentityCard,StuFrom,StuPhone,FamilyPhone,StuAddress,BeginTime）"+
"values (@iStuNo，@iStuName，@iClassID，@iStuSex,@iStuBornDate,@iStuNation,@iStatus,@iIdentityCard,@iStuFrom,@iStuPhone,@iFamilyPhone,@iStuAddress,@iBeginTime)";
// SqlCommand cmdzx=new SqlCommand(sql,conn);//
// string sql1= "insert into users（Name，Age，Sex，Pwd）values (@myName，@myAge，@mySex，@myPwd)";
// SqlCommand cmd1=new SqlCommand(sql,conn);//conn请自行给出
//SqlCommand cmd = conn.CreateCommand();
cmd.Parameters.Add("@iStuNo", SqlDbType.VarChar);
cmd.Parameters.Add("@iStuName", SqlDbType.VarChar);
cmd.Parameters.Add("@iClassID", SqlDbType.Int);
cmd.Parameters.Add("@iStuSex", SqlDbType.VarChar);
cmd.Parameters.Add("@iStuBornDate", SqlDbType.SmallDateTime);
cmd.Parameters.Add("@iStuNation", SqlDbType.VarChar);
cmd.Parameters.Add("@iIdentityCard", SqlDbType.Char);
cmd.Parameters.Add("@iStuPhone", SqlDbType.VarChar);
cmd.Parameters.Add("@iFamilyPhone", SqlDbType.VarChar);
cmd.Parameters.Add("@iStuAddress", SqlDbType.Char);
// cmd.Parameters.Add( "@iImage",SqlDbType.Image);
cmd.Parameters.Add("@iStatus", SqlDbType.VarChar);
cmd.Parameters.Add("@iBeginTime", SqlDbType.SmallDateTime);
cmd.Parameters.Add("@iStuFrom", SqlDbType.VarChar);
// cmd.Parameters.Add("@iOther", SqlDbType.Text);
cmd.Parameters["@iStuNo"].Value = a[4].ToString();
cmd.Parameters["@iStuName"].Value = a[5].ToString();
cmd.Parameters["@iClassID"].Value ="1";
cmd.Parameters["@iStuSex"].Value = a[6].ToString();
cmd.Parameters["@iStuBornDate"].Value = "1992-1-1"; ;
cmd.Parameters["@iStuNation"].Value = a[7].ToString();
cmd.Parameters["@iIdentityCard"].Value = "13080219304140115";
cmd.Parameters["@iStuPhone"].Value = a[13].ToString();
cmd.Parameters["@iFamilyPhone"].Value = a[14].ToString();
cmd.Parameters["@iStuAddress"].Value = null ;
// cmd.Parameters[ "@iImage"].Value="";
cmd.Parameters["@iStatus"].Value = a[9].ToString();
cmd.Parameters["@iBeginTime"].Value = "1992-1-1";
cmd.Parameters["@iStuFrom"].Value = a[8].ToString();
// cmd.Parameters["@iOther"].Value = a[16].ToString();
cmd.ExecuteNonQuery();
cocn.Close();
;
}
}
catch (Exception err)
{
// MessageBox.Show("操作失败！" + err.ToString());
MessageBox.Show("操作失败！" + err.ToString());
}
}
