Dataset connection string in properties

Dataset do not have connection property. Dataset are populated with datasource (database etc)

for example

String cs=ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;
public void display()
{
using (SqlConnection con = new SqlConnection(cs))
{
DataSet ds = new DataSet();
con.Open();
SqlDataAdapter da = new SqlDataAdapter("spInterview", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@Type", "Select");
da.Fill(ds);
// for WebForm
GridView1.DataSource = ds;
GridView1.DataBind();
}
}
//in windows form
DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = ds; // dataset
DataGridView1.DataMember = "TableName"; /

3 Replies

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

Varun Setia6y ago
Hi Rajeesh,

What objective are you trying to achieve ? It will help in identifying the solution.
-3
Rajanikant Hawaldar6y ago
Possible by writing extension methods
+2
Sachin Singh6y ago
Dataset do not have connection property. Dataset are populated with datasource (database etc)
for example
String cs=ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString;

public void display()
        {
            using (SqlConnection con = new SqlConnection(cs))
            {
                DataSet ds = new DataSet();
                con.Open();
                SqlDataAdapter da = new SqlDataAdapter("spInterview", con);
                da.SelectCommand.CommandType = CommandType.StoredProcedure;
                da.SelectCommand.Parameters.AddWithValue("@Type", "Select");

                da.Fill(ds);
//   for WebForm
                GridView1.DataSource = ds;
                GridView1.DataBind();

            }
        }

//in windows form
DataGridView1.AutoGenerateColumns = true;
DataGridView1.DataSource = ds; // dataset
DataGridView1.DataMember = "TableName"; /
+3