如何在C＃中获取SQL版 [英] How do I obtain the SQL Edition in C#

问题描述

我正在尝试使用以下代码从SQL服务器获取SQL版本，但我无法通过附近的语法错误（'。我不确定如何在C＃中编写代码，在SQL Studio中运行得很完美。任何帮助都非常感谢。

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

推荐答案

希望这个 [ ^ ]有帮助。

Hope this[^] helps.

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

这应该有效：

This should work:

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());
}

以下是实际工作原理：

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 />

谢谢大家的帮助......



PS - 解决方案1也有效，我正在使用它。

这篇关于如何在C＃中获取SQL版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！