|
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;
using System.Windows.Shapes;
using System.Data.SqlClient;
using System.Data;
using System.Configuration;
namespace WpfApplication1
{
/// <summary>
/// Interaction logic for MainWindow.xaml
/// </summary>
public partial class MainWindow : Window
{
public MainWindow()
{
InitializeComponent();
FillDataGrid();
}
private void FillDataGrid()
{
SqlConnection con;
SqlDataAdapter sda;
SqlCommand cmd;
String CmdString = "SELECT TOP 100 * FROM Employees";
string ConString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
using (con = new SqlConnection(ConString))
{
cmd=new SqlCommand(CmdString, con);
sda=new SqlDataAdapter(cmd);
DataSet ds=new DataSet();
sda.Fill(ds, "Employees");
grdEmployee.ItemsSource = ds.Tables[0].DefaultView;
}
}
private void dataGrid1_SelectedCellsChanged(object sender, SelectedCellsChangedEventArgs e)
{
}
}
}
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.