Advertisement
Guest User

Datagrid from sql server

a guest
Apr 23rd, 2013
210
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C# 2.59 KB | None | 0 0
  1.  public partial class Shift : Form
  2.     {
  3.         private SqlConnection conn;
  4.         private SqlDataAdapter daShift;
  5.         private DataSet dsShift;
  6.         private DataGrid dgShift;
  7.  
  8.         private const string tableName = "Shift";
  9.  
  10.         public Shift()
  11.         {
  12.             InitializeComponent();
  13.  
  14.             Initdata();
  15.             //Create DataGridView
  16.             dgShift = new DataGrid();
  17.             dgShift.Location = new Point(5, 5);
  18.             dgShift.Size = new Size(
  19.                 this.ClientRectangle.Size.Width - 10,
  20.                 this.ClientRectangle.Height - 50);
  21.             dgShift.DataSource = dsShift;
  22.             dgShift.DataMember = tableName;
  23.             dgShift.RowHeadersVisible = false;
  24.             //dgShift.Dock = DockStyle.Top;
  25.             dgShift.Anchor = AnchorStyles.Top;
  26.          
  27.             // create update button
  28.             Button btnUpdate = new Button();
  29.             btnUpdate.Text = "Add Shift";
  30.             btnUpdate.Location = new Point(
  31.                 this.ClientRectangle.Width / 2 - btnUpdate.Width / 2,
  32.                 this.ClientRectangle.Height - (btnUpdate.Height + 10));
  33.             btnUpdate.Click += new EventHandler(btnUpdateClicked);
  34.             btnUpdate.Anchor = AnchorStyles.Bottom;
  35.  
  36.             // make sure controls appear on form
  37.             Controls.AddRange(new Control[] { dgShift, btnUpdate });
  38.  
  39.         }
  40.  
  41.         // Update button was clicked
  42.         public void btnUpdateClicked(object sender, EventArgs e)
  43.         {
  44.             try
  45.             {
  46.                 // write changes back to DataBase
  47.             daShift.Update(dsShift, tableName);
  48.             }
  49.             catch (Exception)
  50.             {
  51.                 MessageBox.Show("Error:Are there empty fields or inncorrect formats?","Error");
  52.                 return;
  53.             }
  54.         }
  55.  
  56.  
  57.         // set up ADO.NET objects
  58.         public void Initdata()
  59.         {
  60.             // instantiate the connection
  61.             conn = new SqlConnection("Server=ROSS-PC; Database=ShiftSummary; Trusted_Connection = True");
  62.  
  63.             // 1. instantiate a new DataSet
  64.             dsShift = new DataSet();
  65.  
  66.             // 2. init SqlDataAdapter with select command and connection
  67.             daShift = new SqlDataAdapter(
  68.                 "select [ShiftDate],[ShiftStart],[ShiftEnd],[JobID], [RateType]  from Shift", conn);
  69.  
  70.             // 3. fill in insert, update, and delete commands
  71.             SqlCommandBuilder cmdBldr = new SqlCommandBuilder(daShift);
  72.  
  73.             // 4. fill the dataset
  74.             daShift.Fill(dsShift, tableName);
  75.         }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement