Breaking News: Grepper is joining You.com. Read the official announcement!

Using a Views in .net and c#

Uptight Unicorn answered on May 10, 2021 Popularity 8/10 Helpfulness 1/10

answer Using a Views in .net and c#

Using a Views in .net and c#

Comment

using (SqlConnection connection = new SqlConnection("Data Source=raven\\sqlexpress;Initial Catalog=ucs;Integrated Security=True;Pooling=False"))
{
    using (SqlCommand command = connection.CreateCommand())
    {
        command.CommandText = "SELECT * from your_view WHERE your_where_clause";

        connection.Open();
        using (SqlDataReader reader = command.ExecuteReader())
        {
            while (reader.Read())
            {
                // process result
                reader.GetInt32(0); // get first column from view, assume it's a 32-bit int
                reader.GetString(1); // get second column from view, assume it's a string
                // etc.
            }
        }
    }
}

Popularity 8/10 Helpfulness 1/10 Language csharp

Source: stackoverflow.com

Tags: .net c# using

Link to this answer
Share Copy Link

Contributed on May 10 2021

Uptight Unicorn

0 Answers Avg Quality 2/10

Using a Views in .net and c#

Contents

More Related Answers

Using a Views in .net and c#

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.