if (ofdImport.ShowDialog() == DialogResult.OK)
{
using (FileStream filestream = File.OpenRead(ofdImport.FileName))
{
using (StreamReader streamreader = new StreamReader(filestream))
{
string line = null;
while ((line = streamreader.ReadLine()) != null)
{
string[] str = line.Split('|');
string name = str[0];
int age = Convert.ToInt32(str[1]);
using (SqlConnection conn = new SqlConnection(@"Data source=.\SQLEXPRESS; AttachDBFilename=|DataDirectory|\Database2.mdf;Integrated Security=true;User Instance=true"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_Persons (Name,Age) values(@Name,@Age)";
cmd.Parameters.Add(new SqlParameter("Name", name));
cmd.Parameters.Add(new SqlParameter("Age", age));
cmd.ExecuteNonQuery();
}
}
}
}
}
}
为什么运行成功但是数据却无法插入表中呢
{
using (FileStream filestream = File.OpenRead(ofdImport.FileName))
{
using (StreamReader streamreader = new StreamReader(filestream))
{
string line = null;
while ((line = streamreader.ReadLine()) != null)
{
string[] str = line.Split('|');
string name = str[0];
int age = Convert.ToInt32(str[1]);
using (SqlConnection conn = new SqlConnection(@"Data source=.\SQLEXPRESS; AttachDBFilename=|DataDirectory|\Database2.mdf;Integrated Security=true;User Instance=true"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "insert into T_Persons (Name,Age) values(@Name,@Age)";
cmd.Parameters.Add(new SqlParameter("Name", name));
cmd.Parameters.Add(new SqlParameter("Age", age));
cmd.ExecuteNonQuery();
}
}
}
}
}
}
为什么运行成功但是数据却无法插入表中呢
三层结构也要体现清楚呀!