我的一个把数据库的内容读出到一个txt文件的代码,你可以参考下,写入文件主要看button2_Click_1这个类
static void insert(string name, int score)
{
using (SqlConnection conn = new SqlConnection(@"Data Source =DESTINY-PC;Initial Catalog=ADO.NET;Integrated Security=true"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
//cmd.CommandText = "Select Id from T_Users where UserName = '" + username + "' and PassWord='" + password + "'";
//cmd.CommandText = "Select Id from T_Users where UserName = @username and PassWord = @password";
cmd.CommandText = "Insert into dbo.T_NameAndScore (Name,Score) values (@name,@score)";
cmd.Parameters.Add(new SqlParameter("name", name));
cmd.Parameters.Add(new SqlParameter("score", score));
cmd.ExecuteNonQuery();
}
}
}
static int count()
{
using (SqlConnection conn = new SqlConnection(@"Data Source =DESTINY-PC;Initial Catalog=ADO.NET;Integrated Security=true"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
//cmd.CommandText = "Select Id from T_Users where UserName = '" + username + "' and PassWord='" + password + "'";
//cmd.CommandText = "Select Id from T_Users where UserName = @username and PassWord = @password";
cmd.CommandText = "select COUNT(*) as number from T_NameAndScore";
//cmd.Parameters.Add(new SqlParameter("name", name));
//cmd.Parameters.Add(new SqlParameter("score", score));
SqlDataReader dr = cmd.ExecuteReader();
int i = 0;
while (dr.Read())
{
i = Convert.ToInt32(dr["number"]);
}
//string str = dr["number"].ToString();
//int i = Convert.ToInt32(str);
//int i = dr.GetInt32(dr.GetOrdinal("number"));
return i;
}
}
}
static string[] select()
{
//string[] str = new String[20];
//StringBuilder[] str = new StringBuilder();
using (SqlConnection conn = new SqlConnection(@"Data Source =DESTINY-PC;Initial Catalog=ADO.NET;Integrated Security=true"))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
//cmd.CommandText = "Select Id from T_Users where UserName = '" + username + "' and PassWord='" + password + "'";
//cmd.CommandText = "Select Id from T_Users where UserName = @username and PassWord = @password";
cmd.CommandText = "select Name,Score from T_NameAndScore";
//cmd.Parameters.Add(new SqlParameter("name", name));
//cmd.Parameters.Add(new SqlParameter("score", score));
SqlDataReader dr = cmd.ExecuteReader();
//int a = dr.GetSchemaTable().Rows.Count;
int a = count();
string[] str = new String[a];
int i = 0;
//string name, score;
while (dr.Read() && dr != null)
{
//string name = dr.GetString(0);
//name = dr["Name"].ToString();
//string score = Convert.ToString(dr.GetInt32(1));
//score = dr["Score"].ToString();
//str[i] = name + "|" + score;
str[i] = dr["Name"].ToString() + "|" + dr["Score"].ToString();
//Console.WriteLine("Str是{0}",str[i]);
i++;
}
return str;
}
}
}
int number = 0;
private void button1_Click(object sender, EventArgs e)
{
if (ofd1.ShowDialog() == DialogResult.OK)
{
using (FileStream fs = File.OpenRead(ofd1.FileName))
{
using(StreamReader sr = new StreamReader(fs))
{
string line = null;
while ((line = sr.ReadLine()) != null)
{
string username = line.Split('|')[0];
int score = Convert.ToInt32(line.Split('|')[1]);
insert(username, score);
number++;
}
MessageBox.Show(string.Format("操作成功,共插入了{0}条数据", number));
Application.Exit();
}
}
}
}
private void button2_Click_1(object sender, EventArgs e)
{
if (sfd1.ShowDialog() == DialogResult.OK)
{
using (FileStream fs = File.OpenWrite(sfd1.FileName))
{
using (StreamWriter sw = new StreamWriter(fs))
{
string[] str = select();
for (int i = 0; i < str.Length; i++)
{
//MessageBox.Show(str[i]);
sw.WriteLine(str[i]);
}
Application.Exit();
}
}
温馨提示:答案为网友推荐,仅供参考