Skip to content

C# SQL Server Howto

· 技术 · 1 分钟阅读

为项目组写了几个Howto的Case。

本文描述了一个用C#实现的简单的SQL Server查询。 功能是每次执行插入一行记录，然后输出全部记录。

Program.cs

using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient;

namespace SQLServerHowto { class Program { static void Main(string[] args) { SqlConnection myConnection = new SqlConnection("Data Source=itsdbserver;user id=its;password=its;database=ITSTestDB"); myConnection.Open();

        string sql = "insert into news (news) values (@value)";
        SqlCommand sc = new SqlCommand(sql, myConnection);
        SqlParameter param = new SqlParameter("value", "现在是" + DateTime.Now.ToString() + "，但毛君还是垃圾");
        sc.Parameters.Add(param);

        int count = sc.ExecuteNonQuery();
        Console.WriteLine("Line inserted: " + count.ToString());

        string sql2 = "select * from News";
        SqlCommand sc2 = new SqlCommand(sql2, myConnection);
        SqlDataReader reader = sc2.ExecuteReader();

        while (reader.Read())
        {
            Console.WriteLine(String.Format("ID={0}, news={1}", reader, reader));
        }
    }
}

}

下载：用Visual Studio 2008打开 http://download.nocoo.us/Download/Archive/CSharpHowto/SQLServer.rar

C#