استدعاء قيم من البروسيدجر ووضعها فى 2 تيكست

وعليكم السلام

جربى الكود

    	private void btnFind_Click(object sender, System.EventArgs e)
    	{
        	SqlDataReader rdr = null;
        	SqlConnection con = null;
        	SqlCommand cmd = null;

        	try
        	{
            	// Open connection to the database
            	string ConnectionString = "database=laws;data source=.;integrated security=true;";
            	con = new SqlConnection(ConnectionString);
            	con.Open();

            	// Set up a command with the given query and associate
            	// this with the current connection.
            	string CommandText = "SELECT Name, Description  FROM Yourtable  WHERE  id = @id)";
            	cmd = new SqlCommand(CommandText);
            	cmd.Connection = con;

            	// Add LastName to the above defined paramter @id
            	cmd.Parameters.AddWithValue("@id", txt_id.Text);


            	// Execute the query
            	rdr = cmd.ExecuteReader();

            	// Fill the list box with the values retrieved

            	while (rdr.Read())
            	{
                	textbox1.text=  rdr["Name"].ToString();
                	textbox2.text = rdr["Description"].ToString();
            	}
        	}
        	catch (Exception ex)
        	{
            	// Print error message
            	MessageBox.Show(ex.Message);
        	}
        	finally
        	{
            	// Close data reader object and database connection
            	if (rdr != null)
                	rdr.Close();

            	if (con.State == ConnectionState.Open)
                	con.Close();
        	}
    	}