public partial class MainFrm : Form
{
public MainFrm()
{
InitializeComponent();
}
private void btnSelectDataFile_Click(object sender, EventArgs e)
{
using (OpenFileDialog ofd = new OpenFileDialog())
{
ofd.Filter = "文本文件|*.txt";//只允许选择打开文本类型文件
if (ofd.ShowDialog() == DialogResult.OK)
{
this.txtFilePath.Text = ofd.FileName;
ImportData(ofd.FileName);//创建声明一个函数
MessageBox.Show("OK");
}
}
}
private void ImportData(string fileName)//函数具体定义部分
{
string temp = string.Empty;
using (StreamReader reader = new StreamReader(fileName, Encoding.UTF8))
{
reader.ReadLine();
//string connStr = "server=.;uid=sa;pwd=123456;database=itcastdb";
string connStr = ConfigurationManager.ConnectionStrings["sqlConn"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
using (SqlCommand cmd = conn.CreateCommand())
{
conn.Open();//报错
while (!string.IsNullOrEmpty(temp = reader.ReadLine()))
{
var strs = temp.Split(',');
string sql = string.Format(@"
insert into tblStudent
(stuName,stuSex,stuBirthDate,stuPhone)
values('{0}','{1}','{2}','{3}')", strs[1], strs[2], strs[3], strs[4]);
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
}
}
}
}
}
}
配置文件中的地址没有写错
请问导致这种问题的原因主要是什么,该如何解决呢?
这个异常大概率是连接字符串写的有问题,建议再检查调试一下。