private void button1_Click(object sender, EventArgs e)
{
FileDialog sfd = new SaveFileDialog();
if (sfd.ShowDialog() == DialogResult.OK)
{
using (FileStream fstream = File.OpenWrite(sfd.FileName))
{
StreamWriter sw = new StreamWriter(fstream, System.Text.Encoding.GetEncoding("GB2312"));
using (SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=PhoneBook;Integrated Security=SSPI"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "select * from Phone3";
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int id = reader.GetInt32(reader.GetOrdinal("编号"));
string users = reader.GetString(reader.GetOrdinal("用户"));
string group = reader.GetString(reader.GetOrdinal("分组"));
string name = reader.GetString(reader.GetOrdinal("姓名"));
string company= reader.GetString(reader.GetOrdinal("工作单位"));
string number = reader.GetString(reader.GetOrdinal("联系电话"));
string email = reader.GetString(reader.GetOrdinal("电子邮件"));
sw.WriteLine(number + "|" + users+"|"+group+"|"+name+"|"+company+"|"+number+"|"+email);
}
sw.Flush();
sw.Close();
}
}
conn.Close();
}
MessageBox.Show("数据导出成功!");
}
}
}
}
}
从端点调试来看好像是 string users = reader.GetString(reader.GetOrdinal("用户")); 这句没有正常执行。求大神们明示啊~