周道格的部落格

string strConn = "server=XXXXXX;database=qingkuan;User ID=XXXXXX;Password=XXXXXX;Trusted_Connection=True;";
        SqlConnection myconn = new SqlConnection(strConn);

        SqlCommand dlcmd = new SqlCommand(string.Empty, myconn);
        myconn.Open();
        dlcmd.Parameters.Clear();
        dlcmd.CommandType = CommandType.StoredProcedure;
        dlcmd.CommandText = "qingkuan.dbo.sp_aaa";

        dlcmd.Parameters.Add("@type", SqlDbType.Int).Value = 1;
        SqlDataReader reader = dlcmd.ExecuteReader(CommandBehavior.SingleRow);
        if (reader.HasRows)
        {
            reader.Read();
            Label1.Text = reader["DL_Detail"].ToString();
        }