public SqlConnection con;
public SqlCommand cmd;
public SqlDataAdapter adp;
public DataSet ds;
public void Connection()
{
con = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=accounting;Data Source=HOME-D5073E143B");
con.Open();
}
public DataSet FillData(string MyString)
{
Connection();
adp = new SqlDataAdapter(MyString,con);
ds = new DataSet();
adp.Fill(ds);
return ds;
}
Place this in a class. And call the function any no of times.