Отобразить в TextBox цену выбранного в ComboBox товара

            private ShopDatabaseEntities sbe = new ShopDatabaseEntities();
...
            comboBox1.DataSource = pbe.tblGoods;
            comboBox1.DisplayMember = "GoodsName";
            comboBox1.ValueMember = "GoodsID";

void change_cash(string s)
{
    string var = s;
    switch (var)
    {
        case "Marllboro" : textBox1.Text = "60 руб.";
            break;
        case "Winston" : textBox1.Text = "47 руб.";
            break;
    }
}
 
private void comboBox1_SelectedIndexChanged( object sender, EventArgs e )
{
    change_cash( comboBox1.Text );
}

private void comboBox1_SelectedIndexChanged( object sender, EventArgs e )
{
    switch ( comboBox1.Text )
    {
        case "Marllboro": textBox1.Text = "60 руб.";
            break;
        case "Winston": textBox1.Text = "47 руб.";
            break;
    }
}

public string[,] Dbase = new string[,]
                                       {
                                           {"0","1","2"},
                                           {"1","11","22"},
                                           {"2","111","222"},
                                           {"3","1111","2222"},
                                           {"4","11111","22222"},
                                           {"5","111111","222222"},
                                           {"6","1111111","2222222"}
 
 
                                       };
        public Form1()
        {
            InitializeComponent();
        }
 
        private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            int SelecIndex = comboBox1.SelectedIndex;
            textBox4.Text = Dbase[SelecIndex, 0] + " " + Dbase[SelecIndex, 1] + " " + Dbase[SelecIndex, 2];

private void comboBox1_SelectedIndexChanged( object sender, EventArgs e )
{
    TextBox1.Text = (comboBox1 as DataViewRow).Row["GoodsPrice].ToString("f");
}

  private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
        {
            DataRow current = ((DataRowView)comboBox1.SelectedItem).Row;
            textBox1.Text = current["GoodsPrice"].ToString();
        }

textBox1.Text=pbe.tblGoods.Select("GoodsId="+comboBox1.Selectedvalue.ToString())[0][2].ToString();

    DataTable table = DataSet1.Tables["Orders"];
    // Presuming the DataTable has a column named Date.
    string expression;
    expression = "Date > #1/1/00#";
    DataRow[] foundRows;
 
    // Use the Select method to find all rows matching the filter.
    foundRows = table.Select(expression);

            comboBox1.DisplayMember="GoodsName";

 
private void comboBox1_SelectedIndexChanged( object sender, EventArgs e )
{
    TextBox1.Text = (comboBox1.SelectedItem as DataRowView).Row["GoodsPrice].ToString("f");
}