static void Main(string[] args)
{
int count = 0;
string sql = "insert into Exe3.newStudent(stuName, stuSex, stuBirthdate, stuStudydate, stuAddress, stuEmail, stuPhone, stuIsDel, stuInputtime, classId) values(@stuName, @stuSex, @stuBirthdate, @stuStudydate, @stuAddress, @stuEmail, @stuPhone, @stuIsDel, @stuInputtime, @classId);";
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
// 准备参数模板
SqlParameter[] ps =
{
new SqlParameter("@stuName", SqlDbType.NVarChar, 5), // 0
new SqlParameter("@stuSex", SqlDbType.Char, 1), // 1
new SqlParameter("@stuBirthdate", SqlDbType.DateTime),
new SqlParameter("@stuStudydate", SqlDbType.DateTime),
new SqlParameter("@stuAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@stuEmail", SqlDbType.NVarChar, 50),
new SqlParameter("@stuPhone", SqlDbType.NVarChar, 20),
new SqlParameter("@stuIsDel", SqlDbType.Bit),
new SqlParameter("@stuInputtime", SqlDbType.DateTime),
new SqlParameter("@classId", SqlDbType.Int)
};
// string[] colNames = "stuName,stuSex,stuBirthdate,stuStudydate,stuAddress,stuEmail,stuPhone,stuIsDel,stuInputtime,classId".Split(',');
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddRange(ps);
conn.Open();
using (StreamReader reader = new StreamReader("student.txt", Encoding.Default))
{
string temp = null;
while ((temp = reader.ReadLine()) != null)
{
string[] temps = temp.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
// 用for循环,将结果的第1项与数组的第0项赋值
for (int i = 1; i < temps.Length; i++)
{
ps[i - 1].Value = temps[i];
}
count += cmd.ExecuteNonQuery();
}
}
}
}
Console.WriteLine("{0}行受影响", count);
Console.ReadKey();
}
{
int count = 0;
string sql = "insert into Exe3.newStudent(stuName, stuSex, stuBirthdate, stuStudydate, stuAddress, stuEmail, stuPhone, stuIsDel, stuInputtime, classId) values(@stuName, @stuSex, @stuBirthdate, @stuStudydate, @stuAddress, @stuEmail, @stuPhone, @stuIsDel, @stuInputtime, @classId);";
string connStr = @"server=.\sqlexpress;database=HeiMa8;uid=sa;pwd=123;";
// 准备参数模板
SqlParameter[] ps =
{
new SqlParameter("@stuName", SqlDbType.NVarChar, 5), // 0
new SqlParameter("@stuSex", SqlDbType.Char, 1), // 1
new SqlParameter("@stuBirthdate", SqlDbType.DateTime),
new SqlParameter("@stuStudydate", SqlDbType.DateTime),
new SqlParameter("@stuAddress", SqlDbType.NVarChar, 50),
new SqlParameter("@stuEmail", SqlDbType.NVarChar, 50),
new SqlParameter("@stuPhone", SqlDbType.NVarChar, 20),
new SqlParameter("@stuIsDel", SqlDbType.Bit),
new SqlParameter("@stuInputtime", SqlDbType.DateTime),
new SqlParameter("@classId", SqlDbType.Int)
};
// string[] colNames = "stuName,stuSex,stuBirthdate,stuStudydate,stuAddress,stuEmail,stuPhone,stuIsDel,stuInputtime,classId".Split(',');
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = new SqlCommand(sql, conn))
{
cmd.Parameters.AddRange(ps);
conn.Open();
using (StreamReader reader = new StreamReader("student.txt", Encoding.Default))
{
string temp = null;
while ((temp = reader.ReadLine()) != null)
{
string[] temps = temp.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
// 用for循环,将结果的第1项与数组的第0项赋值
for (int i = 1; i < temps.Length; i++)
{
ps[i - 1].Value = temps[i];
}
count += cmd.ExecuteNonQuery();
}
}
}
}
Console.WriteLine("{0}行受影响", count);
Console.ReadKey();
}