كيف استدعي SELECT stored procedure مع براميتر

تم حلها :)

الحل

string query = "dbo.GetInfo";

            using (SqlConnection conn = new SqlConnection(connectionString))
            {
                using (SqlCommand comm = new SqlCommand(query, conn))
                {
                    conn.Open();
                    comm.CommandType = System.Data.CommandType.StoredProcedure;
                    comm.Parameters.AddWithValue("@ID", id);


                    using (SqlDataReader reader = comm.ExecuteReader())
                    {
                        while (reader.Read())
                        {


                            StudentID = Convert.ToInt32(reader["ID"]);
                            StudentName = reader["Name"].ToString();
                            Date = Convert.ToDateTime(reader["Date"]);


                        }
                    }

                    conn.Close();