Does SqlDataAdapter Requires open connection To Execute Sql Command

Question

Does SqlDataAdapter Requires open connection To Execute Sql Command ?

see below :

protected void Page_Load(object sender, EventArgs e)
    {
        string strconn = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
        SqlConnection con = new SqlConnection(strconn);            
        SqlCommand cmd = new SqlCommand("Select * from EmpDetails", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);           
        DataSet ds = new DataSet();           
        da.Fill(ds);           
        GV_Data.DataSource = ds;
        GV_Data.DataBind();
    }

anyone have a clue about this ?

Did you note anything gone strange?

sujith karivelil
– sujith karivelil

2017-11-07 11:47:36 +00:00
Commented Nov 7, 2017 at 11:47 — sujith karivelil
– sujith karivelil, Commented Nov 7, 2017 at 11:47

Caius Jard · Accepted Answer · 2017-11-07 11:47:26Z

1

No. A DataAdapter will open a closed connection automatically, before it fills a dataset/table. It will also return the connection to the state it was before the fill operation

answered Nov 7, 2017 at 11:47

Caius Jard

75k6 gold badges61 silver badges95 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Does SqlDataAdapter Requires open connection To Execute Sql Command

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related