背景代碼:
MKP。MyCommon.SQLHelper sh =新MKP。my common . SQL helper(null);
數據表dt=sh。GetDataTable("select Fi_id,Fs_pCompanyName,Fs_phone,Fs _ email from TPM company ");
dataGrid1ItemsSource = dt。DefaultView
前臺代碼:
& ltpre class="csharp" name="code " >& ltDataGrid autogenerate columns = " False "
height = " 153 " horizontal alignment = " Left " Name = " datagrid 1 " vertical alignment = " Top "
width = " 449 " selectedcells changed = " datagrid 1 _ selectedcells changed " >
& lt數據網格。列& gt
& ltDataGridTextColumn Header = " ID " Binding = " { Binding Path = Fi _ ID } "/& gt;
& ltDataGridTextColumn Header = " company name " binding = " { binding path = fs _ pcompany name } "/>
& ltdatagridtextcolumn binding = " { binding path = fs _ phone } " header = " phone "/& gt;
& ltDataGridTextColumn Binding = " { Binding Path = Fs _ Email } " Header = " Email " & gt;& lt/datagrid text column & gt;
& lt/DataGrid。列& gt
& lt/DataGrid & gt;