C#执行存储过程

 //连接数据库
        SqlConnection conn = new SqlConnection();
        conn.ConnectionString = "Data Source=KARL;Initial Catalog=ER;Persist Security Info=True;User ID=sa;Password=sa";
        SqlCommand command = new SqlCommand("proc_getMovieID", conn);
        conn.Open();
        command.CommandType = CommandType.StoredProcedure;
        command.Parameters.Add("@movieName", SqlDbType.NVarChar, 50);
        command.Parameters["@movieName"].Value = movieName;
        SqlDataAdapter da = new SqlDataAdapter();
        da.SelectCommand = command;
        DataSet ds = new DataSet();
        da.Fill(ds, "tables");

        //计算movieID
        Int32 movieID;
        if (ds.Tables[0].Rows.Count == 0)
            movieID = -1;
        else
            movieID = int.Parse(ds.Tables[0].Rows[0][0].ToString());
        //关闭数据库
        conn.Close();
        return movieID;

转载于:https://www.cnblogs.com/fishert/archive/2007/04/27/729969.html