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 />
    }

ID              DESCR           CYCLETEMPLATE
====================================
7620	     Campbell P Dr	26
7620	     Campbell P Dr	27
7620	     Campbell P Dr	28
7620	     Campbell P Dr	29
7620            Campbell P Dr	      31
7621	      Jones D Dr	        23
7621	      Jones D Dr	        24
7621	      Jones D Dr	        26
7621	      Jones D Dr	        28
7621	      Jones D Dr	        29
7621	      Jones D Dr	        33
7621	      Jones D Dr 	       34 

ID              DESCR           CYCLETEMPLATE
===============================
7620	Campbell P Dr	26,2728,29,31
7621	Jones D Dr	23,24,26,28,29,33,34

Select [PatientID] as [رقم المريض] from EMR.Patient; 

DECLARE @SQL nvarchar(250);
SET @SQL='Select [PatientID] as [رقم المريض] from EMR.Patient';

EXEC sp_executesql @SQL;