SqlCommand command = connection.CreateCommand(); 

SqlCommand command = new SqlCommand();

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;//必须
using System.Data.SqlClient;//必须
namespace Command
{
 class Program
 {
  static void Main(string[] args)
  {
    SqlConnectionStringBuilder conStr = new SqlConnectionStringBuilder();
    conSt.DataSource=@".\SQLEXPRESS";
    conStr.IntegratedSecurity=true;
    conStr.InitialCatalog="db_Test";
    StringBuilder strSQL = new StringBuilder();
    for(int i=0;i<=100;i++)
    {
     strSQL.Append("insert into tb_Test");
     strSQL.Append("values('");
     string name = "test"+i.ToString();
     strSQL.Append(name);
    }
    using(SqlConnection con = new SqlConnection(conStr.ConnectionString))
    {
     con.Open();
     SqlCommand cmd = new SqlCommand(strSQL.ToString(),con);
    int impactedNumber = cmd.ExecuteNonQuery();//返回受影响的行数
    object firstData = cmd.ExecuteScalar();//返回执行结果中的第一行第一列,此方法可用于获取插入数据的ID,(int lineNumber =(int)cmd.ExecuteScalar();)
    }
  }
 }
}

 SqlConnection connection =new SqlConnection(""))
 {
  SqlCommand cmd = connection.CreateCommand();
  cmd.CommandText="";
cmd.Parameters.Add("@name",SqlDbType.NVarChar).Value = "deng";//方法一
cmd.Parameters.AddWithValue(@"name","deng");//方法二
SqlParameter[] parameters = new SqlParameter[]
 {
 new SqlParameter("@name",SqlDbType.NvarChar,100){Value="deng"},
 };
 cmd.Parameters.AddRange(parameters);//可以放一个参数数组，包含多条参数，在此只举一个例子
}

SqlConnetion con = new SqlConnection("")
{
 con.Open();
 SqlCommand cmd = con.CreateCommand();
 cmd.CommandText="";
 SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)
 {
  While(dr.Read())
  {
   string str = dr.GetSqlString(0).ToString();
  }
 }
}

SqlConnection con = new SqlConnection(strCon);
con.Open();
SqlTransaction transaction = con.BeginTransaction();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = ""
cmd.Transaction = transaction;
transaction.Save("transaction point");
transaction.Rollback("transaction point");

DataSet dataSet = new DataSet();
SqlConnection con = new SqlConnection("");
con.Open();
SqlCommand cmd = con.CreateCommand();
cmd.CommandText="select xxx from tb_xxx";
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
dataAdapter.Fill(dataSet);

SqlConnection con = new SqlConnection(ConnectionString();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("select xxx from tb_xx");
DataSet ds =new DataSet();
da.Fill(ds);
SqlCommandBuilder cmdBuilder = new SqlCommandBuilder(da);
DataRow row = ds.Tables[0].NewRow();
row[0]="a";
row[1]="b";
ds.Tables[0].Rows.Add(row);
da.Update(ds);