class2.cs

数据库断开式连接

using System;
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApplication1
{
	/// <summary>
	/// Class2 的摘要说明。
	/// </summary>
	public class Class2
	{
		public static void Main()
		{
			DataTable dt = new DataTable();

			DataColumn dc1 = new DataColumn("name",typeof(string));
			dt.Columns.Add(dc1);

			DataColumn dc2 = new DataColumn("password",typeof(string));
			dt.Columns.Add(dc2);

			DataRow dr = dt.NewRow();
			dr[0] = "Guilee";
			dr[1] = "Lily";
			dt.Rows.Add(dr);

			SqlConnection conn = new SqlConnection("server=.;uid=sa;pwd=sa;database=dbtest");
			SqlCommand cmd = conn.CreateCommand();
			cmd.CommandText = "insert into account values(@name,@pwd)";
			cmd.Parameters.Add("@name",SqlDbType.NVarChar,50,"name");
			cmd.Parameters.Add("@pwd",SqlDbType.NVarChar,50,"password");

			SqlDataAdapter adapter = new SqlDataAdapter();
			adapter.InsertCommand = cmd;
			adapter.Update(dt);

		}
	}
}