Database

<br />
<br />
namespace DataBindingListBox<br />
{<br />
    /// <summary><br />
    /// Interaction logic for Window1.xaml<br />
    /// </summary><br />
    public partial class Window1 : Window<br />
    {<br />
        public SqlConnection connection; <br />
        public SqlCommand command; <br />
        string sql = "Select Number From Tnumber";<br />
        string connectionString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\NORTHWND.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True";<br />
        <br />
        public Window1()<br />
        {<br />
            InitializeComponent();<br />
        }<br />
<br />
        private void Window_Loaded(object sender, RoutedEventArgs e)<br />
        {<br />
            BindData();<br />
        }<br />
<br />
        private void BindData()<br />
        {<br />
            DataSet dtSet = new DataSet();<br />
            using (connection = new SqlConnection(connectionString))<br />
            {<br />
                command = new SqlCommand(sql, connection);               <br />
                SqlDataAdapter adapter = new SqlDataAdapter();           <br />
                connection.Open();<br />
                adapter.SelectCommand = command;<br />
                adapter.Fill(dtSet, "Tnumber");<br />
                listBox1.DataContext = dtSet;              <br />
            }<br />
        }<br />
<br />
        private void BindXmlData()<br />
        {<br />
         //listBox1.DataContext = BooksData ;<br />
        }<br />
<br />
        private void button1_Click(object sender, RoutedEventArgs e)<br />
        {<br />
<br />
<br />
        }<br />
}<br />
    }