xmlns:c="clr-namespace:WPF1" >
    <Page.Resources>
        <c:EmPAll x:Key="empAll"></c:EmPAll>
        <c:AllData x:Key="allData"></c:AllData>
    </Page.Resources>
    <Grid>
        <ComboBox Height="23" ItemsSource="{ StaticResource empAll}" DisplayMemberPath="Name" SelectedValuePath="ID"  HorizontalAlignment="Left" Margin="47,37,0,0" Name="comboBox1" VerticalAlignment="Top" Width="120"/>
        <ListBox Height="60" ItemsSource="{ StaticResource allData}" DisplayMemberPath="Name" SelectedValuePath="ID" HorizontalAlignment="Left" Margin="48,133,0,0" Name="listBox1" VerticalAlignment="Top" Width="167"/>
        <Button Content="Button" Height="23" HorizontalAlignment="Left" Margin="197,25,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click"/>

    </Grid>

namespace WPF1
{
    ///<summary>
    /// 绑定Combox.xaml 的交互逻辑
    ///</summary>
    public partial class 绑定Combox : Page
    {
        public 绑定Combox()
        {
            InitializeComponent();
        }

        //获取选中的值
        private void button1_Click(object sender, RoutedEventArgs e)
        {
            string val = comboBox1.SelectedValue.ToString();
            var val2 = (listBox1.SelectedItem as Emp).Name;
            MessageBox.Show(val + "," + val2);
        }
    }

    public class Emp
    {
        public int ID { get; set; }
        public string Name { get; set; }
    }

    public class EmPAll : System.Collections.ObjectModel.ObservableCollection<Emp>
    {
        public EmPAll()
        {
            this.Add(new Emp { ID = 1, Name = "A" });
            this.Add(new Emp { ID = 2, Name = "B" });
        }
    }

    public class AllData : System.Collections.ObjectModel.ObservableCollection<Emp>
    {
        public AllData()
        {
            for (int i = 0; i < 10; i++)
            {
                this.Add(new Emp { ID = i, Name = "Name" + i });
            }
        }
    }
}

 1 StringBuilder sb = new StringBuilder();
 2             if (arrService.Length > 0)
 3             {
 4                 for (int i = 0; i < arrService.Length; i++)
 5                 {
 6                     if (string.IsNullOrEmpty(sb.ToString()))
 7                     {
 8                         sb.AppendFormat("INSERT INTO [SM_PackageEntry] select '{0}','{1}','{2}' ", servicePackageID, arrService[i][0], arrService[i][1]);
 9                     }
10                     else
11                     {
12                         sb.AppendFormat(" UNION ALL  select '{0}','{1}','{2}'", servicePackageID, arrService[i][0], arrService[i][1]);
13                     }
14                 }
15                 //执行SQL
16                 SqlHelper.ExecuteSql(sb.ToString());
17                 sb.Clear();//清空SQL
18             }