这个是c#连接数据库成功的示例，还有一些读写操作。主要是我写了两次都没有保存住，郁闷了。
using System;
using System.Data;
using System.IO;
using System.Data.SqlClient;
namespace ConsoleApplication1
{
class IntIndexer
{
static void WriteToFile()
{
StreamWriter sw;
sw = File.CreateText("f:/aa.txt");
sw.WriteLine("God is greatest of them all");
sw.WriteLine("this is second line");
sw.Close();
Console.WriteLine("File Created SuccessFully");
}
static void ReadFromFile(string filename)
{
StreamReader sr;
string s;
sr = File.OpenText(filename);
s = sr.ReadLine();
while(s!=null)
{
Console.WriteLine(s);
s = sr.ReadLine();
}
sr.Close();
}
static void AppendToFile()
{
StreamWriter sw;
sw = File.AppendText("F:/aa.txt");
sw.WriteLine("THIS LINE IS APPENDED");
sw.Close();
}
private static void OpenSqlConnection()
{
string connectionString = GetConnectionString();
SqlConnection connection = new SqlConnection(connectionString);
SqlDataReader rdr = null;
try
{
connection.Open();
SqlCommand cmd = new SqlCommand("select * from Customers",connection);
rdr = cmd.ExecuteReader();
while(rdr.Read())
{
Console.WriteLine(rdr[2]);
}
}
finally
{
if(rdr!= null)
{
rdr.Close();
}
if(connection!=null)
{
connection.Close();
}
}
connection.Close();
}
static private string GetConnectionString()
{
// To avoid storing the connection string in your code,
// you can retrieve it from a configuration file, using the
// System.Configuration.ConfigurationSettings.AppSettings property
return "Data Source=(local);Initial Catalog=Northwind;Integrated Security=SSPI";
}
public static void Main(string[] args)
{
// WriteToFile();
// ReadFromFile("f:/aa.tx");
// AppendToFile();
// Console.WriteLine("File Created SuccessFully");
OpenSqlConnection();
}
}
}
扫一扫
评论 1
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
查看更多评论
添加红包
