How do I obtain the SQL Edition in C#

Question

0.00/5 (No votes)

See more:

Hi,

I'm trying to obtain the SQL Edition from the SQL server using the following code, however I can not get past the syntax error near '('. I'm not sure how to code this in C#, works perfect in SQL Studio. Any help greatly appreciated.

<br />
using (SqlConnection connection = new SqlConnection(connectionString))<br />
{<br />
    strSelect = @"SELECT SERVERPROPERTY('edition')";<br />
    SqlCommand command = new SqlCommand(strSelect, connection);<br />
    command.CommandType = CommandType.Text;<br />
    command.Parameters.AddWithValue(@"SERVERPROPERTY('edition')", edition);<br />
    connection.Open();    <br />
    command.ExecuteScalar();<br />
    connection.Close();<br />
}<br />

Thank you,
Glenn

Posted 16-Mar-14 7:11am

gmhanna

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Accepted Answer · 2014-03-16T07:52:00

Solution 4

Hope this[^] helps.

C#

IDataReader cReader = cmd.ExecuteReader();
if (cReader.Read())
{
    string cText = cReader.GetString(0);
}

Posted 16-Mar-14 7:52am

Abhinav S

v2

Marcin Kozub · Accepted Answer · 2014-03-16T07:23:00

Solution 1

This should work:

C#

using (SqlConnection connection = new SqlConnection(connectionString))
{
    var strSelect = @"SELECT SERVERPROPERTY('edition')";
    SqlCommand command = new SqlCommand(strSelect, connection);
    connection.Open();
    var result = command.ExecuteScalar();
    connection.Close();
    MessageBox.Show(result.ToString());
}

Posted 16-Mar-14 7:23am

Marcin Kozub

Comments

CHill60 16-Mar-14 13:29pm

My 5 - I'd focussed on the way the OP had handled parameterized queries and completely missed the fact that 'edition' is in fact the text to pass to the function! :faceslap:

Marcin Kozub 16-Mar-14 13:31pm

That was first thing I removed from code ;)
Thx for you vote!

gmhanna · Accepted Answer · 2014-03-16T08:09:00

Here's what actually works:

<br />
using (SqlConnection connection = new SqlConnection(connectionString))<br />
{<br />
    strCreate = @"SELECT SERVERPROPERTY('edition')";<br />
    SqlCommand command = new SqlCommand(strCreate, connection);<br />
    command.CommandType = CommandType.Text;<br />
    connection.Open();<br />
    IDataReader cReader = command.ExecuteReader();<br />
    if (cReader.Read())<br />
    {<br />
        edition = cReader.GetString(0);<br />
    }<br />
    connection.Close();<br />
}<br />

Thank you everyone for your help...

PS - Solution 1 also works and is what I'm going with.

CHill60 · Accepted Answer · 2014-03-16T07:25:00

Solution 2

Change the strSelect assignment to be

strSelect = @"SELECT SERVERPROPERTY(@edition)";

and the Parameter addition to be
C#

command.Parameters.AddWithValue("edition)", edition);

See here for another example http://www.dotnetperls.com/sqlparameter[^]

You appear to be confusing the @ at the front of strings which means you don't have to escape certain characters with the @ in a parameterized query which shows the placeholder for the parameter

[Edit] = Here's a link about the @ symbol for verbatim strings[^]

NB Although the comments here do apply (re sqlparameter and verbatim strings) the proposed "solution" is not correct - see Solution 1

Posted 16-Mar-14 7:25am

CHill60

Updated 16-Mar-14 7:31am

v3

Comments

gmhanna 16-Mar-14 14:00pm

I've coded it like this:

using (SqlConnection connection = new SqlConnection(connectionString))
{
strCreate = @"SELECT SERVERPROPERTY(@edition)";
SqlCommand command = new SqlCommand(strCreate, connection);
command.CommandType = CommandType.Text;
command.Parameters.AddWithValue("edition", edition);
connection.Open();
command.ExecuteScalar();
connection.Close();
}

Now I'm getting, SELECT SERVERPROPERTY(@edition) returned: The parameterized query '(@edition nvarchar(4000))SELECT SERVERPROPERTY(@edition)' expect the parameter '@edition', which was not supplied.

gmhanna 16-Mar-14 14:05pm

I think it's expecting me to pass some value in the variable edition, which is set to null.