Details

Written by: Stanko Milosev

Category: Windows Forms

Published: 08 May 2021

Last Updated: 08 May 2021

Hits: 2023

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;

namespace GridDataSetBindingSourceAndTableAdapterDynamicExample
{
  public partial class Form1 : Form
  {
    public Form1()
    {
      InitializeComponent();
    }

    private void button1_Click(object sender, EventArgs e)
    {
      string connectionString =
        "data source=localhost;initial catalog=TestCompleteTest;persist security info=True;Integrated Security=SSPI";

      using (SqlConnection conn = new SqlConnection(connectionString))
      {
        using (SqlCommand cmd = new SqlCommand("SELECT * FROM Names", conn))
        {
          conn.Open();
          DataSet ds = new DataSet();
          SqlDataAdapter da = new SqlDataAdapter
          {
            SelectCommand = cmd
          };
          da.Fill(ds);
          dataGridView1.DataSource = ds.Tables[0];
        }
      }
    }
  }
}

Taken from here

Example download from here

Details

Written by: Stanko Milosev

Category: Windows Forms

Published: 25 April 2021

Last Updated: 25 April 2021

Hits: 2355

First I started new Windows Forms App (.NET Framework), please note that you need .NET Framework, otherwise it will .NET 5.0

Next I added DataGridView, and here automatically opened "Choose Data Source":

Then choose a data source type, in my case I have choosen Database:

Choose data connection:

Choose database objects:

I have added two buttons, one to update data to the database, and other to fill grid with data. On the end my Form looks like:

Finally, here is how my source code look like:

using System;
using System.Windows.Forms;

namespace GridDataSetBindingSourceAndTableAdapterExample
{
  public partial class Form1 : Form
  {
    public Form1()
    {
      InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {
      // TODO: This line of code loads data into the 'testCompleteTestDataSet.Names' table. You can move, or remove it, as needed.
      this.namesTableAdapter.Fill(this.testCompleteTestDataSet.Names);

    }

    private void Update_Click(object sender, EventArgs e)
    {
      this.namesTableAdapter.Update(this.testCompleteTestDataSet);
    }

    private void Fill_Click(object sender, EventArgs e)
    {
      this.namesTableAdapter.Fill(this.testCompleteTestDataSet.Names);
    }
  }
}

CREATE TABLE [dbo].[Names](
	[FirstName] [nvarchar](50) NULL,
	[LastName] [nvarchar](50) NULL,
	[ID] [int] NULL
) ON [PRIMARY]

Details

Written by: Stanko Milosev

Category: Windows Forms

Published: 23 November 2020

Last Updated: 23 November 2020

Hits: 2105

private void sdnButton1_Click(object sender, EventArgs e)
{
	List<MyChild> stankosKids = new List<MyChild>();
	stankosKids.Add(new MyChild { Name = "Velimir", Gender = "Male" });
	stankosKids.Add(new MyChild { Name = "Hilda", Gender = "Female" });

	List<MyChild> arnoldsKids = new List<MyChild>();
	arnoldsKids.Add(new MyChild { Name = "Thomas", Gender = "Male" });
	arnoldsKids.Add(new MyChild { Name = "Sabrina", Gender = "Female" });

	List<MyChild> chucksKids = new List<MyChild>();
	chucksKids.Add(new MyChild { Name = "Bruce", Gender = "Male" });
	chucksKids.Add(new MyChild { Name = "Lee", Gender = "Female" });

	List<MyParent> list = new List<MyParent>();
	list.Add(new MyParent { ID = 1, FirstName = "Stanko", LastName = "Milosev", Address = "Herseler strasse 8", MyKids = stankosKids });
	list.Add(new MyParent { ID = 2, FirstName = "Arnold", LastName = "Schwarzeneger", Address = "Whitehouse 1", MyKids = arnoldsKids });
	list.Add(new MyParent { ID = 3, FirstName = "Chuck", LastName = "Norris", Address = "Las Vegas", MyKids = chucksKids });

	ultraGrid1.SetDataBinding(list, null);
}

public class MyParent
{
	public int ID { get; set; }
	public string FirstName { get; set; }
	public string LastName { get; set; }
	public string Address { get; set; }

	public List<MyChild> MyKids { get; set; }
}

public class MyChild
{
	public string Name { get; set; }
	public string Gender { get; set; }
}