string quest=comboBox1.SelectedText;
         sqlCommand1.CommandType = CommandType.StoredProcedure;

         sqlCommand1.CommandText = "dbo.price_for_client1";
         sqlCommand1.Parameters.Add("@Surname", SqlDbType.NChar,  10 , "Фамилия");
         sqlCommand1.Parameters["@Surname"].Value = quest;
            sqlDataAdapter1.SelectCommand = sqlCommand1;
            dataSet1 = new DataSet();
            sqlDataAdapter1.Fill(dataSet1);
            dataGridView1.DataSource = dataSet1;
            dataGridView1.DataMember = "Price";

SqlConnection sqlconnection1=new SqlConnection("Data Source=JULU;Initial Catalog=Hotels;Integrated Security=True");
         sqlConnection1.Open();
         string quest = textBox1.Text;
         SqlCommand sqlCommand1 = new SqlCommand("dbo.price_for_client1",sqlConnection1);
        sqlCommand1.CommandType = CommandType.StoredProcedure;

SqlParameter workParam=new SqlParameter("@Surname", SqlDbType.NChar, 10 );

SqlParameter workParam1=null;
SqlParameter workParam2=null;
SqlParameter workParam3=null;
workParam = sqlCommand1.CreateParameter();
workParam= sqlCommand1.Parameters.AddWithValue("@Surname", DBNull.Value);
workParam.Direction = ParameterDirection.Input;
sqlCommand1.Parameters["@Surname"].Value = textBox1.Text;
workParam1 = sqlCommand1.Parameters.Add(new SqlParameter("@days_to_stay", SqlDbType.DateTime));
workParam1.Direction = ParameterDirection.Output;
workParam2 = sqlCommand1.Parameters.Add(new SqlParameter("@price_for_client_facilities", SqlDbType.Money));
workParam2.Direction = ParameterDirection.Output;
workParam3 = sqlCommand1.Parameters.Add(new SqlParameter("@price_for_accom", SqlDbType.Money));
workParam3.Direction = ParameterDirection.Output;
SqlDataAdapter sqlDataAdapter1 = new SqlDataAdapter(sqlCommand1.CommandText,               Source=JULU;Initial Catalog=Hotels;Integrated Security=True");
dataSet1 = new DataSet();
sqlDataAdapter1.Fill(dataSet1);
dataGridView1.DataSource = dataSet1;//на этом шаге ошибка
dataGridView1.DataMember = "Price";