给别人打个比方,自己真有才,记下来。呵呵
// 比如做饭:煮方便面
SqlConnection myConnection = new SqlConnection(conString); //开煤气
myConnection.Open(); //点火
SqlDataAdapter adapter = new SqlDataAdapter(strSQL, myConnection); //我把方便面放到这个炉灶上煮
adapter.Fill(ds, "employee"); //煮好了倒到碗中
myConnection.Close(); //关火
// 比如做饭:做宫保鸡丁
SqlConnection con = new SqlConnection(connectString); //开煤气
con.Open(); //点火
SqlCommand cmd = new SqlCommand("dbo.bitCMS_ConvertVideo_GetList", con); //确定菜名“宫保鸡丁”
cmd.CommandType = CommandType.StoredProcedure; //大连川菜“微辣”
SqlParameter processDT = new SqlParameter("@ProcessDateTime", DbType.String); //鸡肉,辣椒等
processDT.Direction = ParameterDirection.Input;
processDT.Value = processDateTime;
cmd.Parameters.Add(processDT); //构成“宫保鸡丁”
SqlDataAdapter dataAapter = new SqlDataAdapter(cmd); //开炒
dataAapter.Fill(dsVideoList); //出锅
con.Close(); //关火