C# - Custom DataSet within the form

ozzy

16y3.7k

Hi,

A newbie needs some help. I have a custom SQL connection and what I wanna do is, I wanna create a DataSet using this SQL connection. And I wanna be able to call this dataset from any method within the form. Just to be clear let's say :

I have gridcontrol named gridcontrol1, a button called button1. When I click to the button it should bind that dataset to the gridcontrol.

So I want to be able to call this dataset with different events.

I don't know how to make that dataset be able to called from anywhere in the form. Where should I put my codes for my dataset and in what (in a method, a new class or somewhere else?)

Thanks in advance.

EDIT :

I knew it. It's so easy. But as I said I'm a newbie. So here is my solution :

I defined my connection, dataset etc. like :

public static SqlConnection conn;

public static DataSet ds;

....

So I solved my problem...

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

kiran kumar16y ago
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;

namespace populate
{
public partial class Form1 : Form
{
SqlConnection con = new SqlConnection("Data Source=KIRAN\\SQLEXPRESS;Initial Catalog=kiran;Integrated Security=True");
DataSet ds;
SqlDataAdapter da;
public Form1()
{
InitializeComponent();
}

private void button1_Click(object sender, EventArgs e)
{
con.Open();
ds = new DataSet();
da = new SqlDataAdapter("select * from item", con);
da.Fill(ds);
dataGridView1.DataSource = ds.Tables[0].DefaultView;

}
}
}

take a look at this code

MARK THE ANSWER IF IT HELPS YOU
0
Sam Hobbs16y ago
Something else you can do is to use the Server Explorer to create a connection string, then use the Data Sources window to create a data source. The data source will create a TableAdapter. You can drag the data source to a blank form; there are many other things to learn about data sources but normally when you drop the data source into a form, you get a DataGridView bound to the data source. You can build the project and you will have a functional form that can show the data source and even support interactive editing of the data, all without writing any code.
0