综合

  public   void  GetAllInfoRead()
     {
        SqlConnection conn = new SqlConnection(pubfunc.sConn);
        string container = Request.QueryString["containerID"].ToString();
        System.Guid guid = new System.Guid(container);
        SqlCommand com = new SqlCommand();
        com.Connection = conn;
        SqlParameter containerId = com.Parameters.Add("@id", SqlDbType.UniqueIdentifier, 50);
        containerId.Value = guid;
        com.CommandText = "sp_job_selectjobsecontainer";
        com.CommandType = CommandType.StoredProcedure;
        conn.Open();
        SqlDataReader sdr = com.ExecuteReader();
        if (sdr.Read())
        {
            SetListSelected(sdr["consize"].ToString());
            TextBox2.Text=sdr["conno"].ToString ();
            TextBox3.Text = sdr["sealno"].ToString();
            TextBox4.Text=sdr["billno"].ToString ();
        }
        conn.Close();
    }

set  ANSI_NULLS  ON
set  QUOTED_IDENTIFIER  ON
go

ALTER   proc   [ dbo ] . [ sp_job_selectjobsecontainer ] ( @id   UniqueIdentifier )
as
begin
     select   *   from  job_se_container  where  id = @id ;
end ;    

转载于:https://www.cnblogs.com/simhare/archive/2007/09/10/888875.html