呼叫儲存過程

SqlDataAdapter sda = new SqlDataAdapter(); //DataSet
//查詢呼叫儲存過程 需要先準備一個命令物件
SqlCommand cmd=new SqlCommand("PR_selectNew",conn);
cmd.CommandType = CommandType.StoredProcedure;
//設定介面卡SqlDataAdapter 將準備號的命令物件 放入介面卡中執行
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
//填充
sda.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();

//操作

SqlCommand cmd = new SqlCommand("PR_insertLogs",conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Tittle", SqlDbType.NVarChar, 100));
cmd.Parameters.Add(new SqlParameter("@CreateTime", SqlDbType.DateTime)).Value = time;
cmd.Parameters.Add(new SqlParameter("@Number", SqlDbType.Int)).Value = 0;
cmd.Parameters[0].Value=Tittles.Text.Trim();