SQL Server and Visual Studio 2012 [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 12 years ago.

Improve this question

I have connected to my database using Data Connection Server Explorer and the same is added to my web.config as well. Now can someone tell me how to query it?

Duplicate of many questions on this site.... stackoverflow.com/questions/9966301/sql-query-form-c-sharp, stackoverflow.com/questions/783294/…, stackoverflow.com/questions/1504895/simple-sql-select-in-c — B-M
– B-M, Commented Jul 5, 2013 at 15:19

Mike Perrenoud · Accepted Answer · 2013-07-05 15:15:18Z

2

Sure, you could do this:

using (SqlConnection c = new SqlConnection(ConfigurationManager.ConnectionStrings["key_of_element"]))
{
    c.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT * FROM Table"))
    {
        var reader = cmd.ExecuteReader();
        while (reader.Read())
        {
            // do something with the data
        }
    }
}

answered Jul 5, 2013 at 15:15

Mike Perrenoud

68.1k32 gold badges167 silver badges238 bronze badges

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

Collectives™ on Stack Overflow

SQL Server and Visual Studio 2012 [closed]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related