" '）'附近的语法不正确我需要帮助，这段代码有什么问题 [英] " Incorrect syntax near ')' " i need help please, what is the wrong with this code

问题描述

private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
        {
            string cs = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\SATDB.mdf;Integrated Security=True;User Instance=True";
            using (SqlConnection con = new SqlConnection(cs))
            {
                con.Open();
                SqlTransaction txn = con.BeginTransaction();
                string sql = "GET_FILESTREAM_TRANSACTION_CONTEXT(), SELECT Trial_Addmission.PathName() from Sat";
                SqlCommand cmd = new SqlCommand(sql, con, txn);
                SqlDataReader rdr = cmd.ExecuteReader();
                while (rdr.Read())
                {
                    string filePath = rdr[0].ToString();
                    byte[] objContext = (byte[])rdr[1];
                    string Name = rdr[2].ToString();

                    SqlFileStream sfs = new SqlFileStream(filePath, objContext, FileAccess.Read);

                    byte[] buffer = new byte[(int)sfs.Length];
                    sfs.Read(buffer, 0, buffer.Length);
                    sfs.Close();
                }

                rdr.Close();
                txn.Commit();
                con.Close();
            }
        }

推荐答案

您的错误出现在以下声明中：

Your error is in this statement:

string sql = "GET_FILESTREAM_TRANSACTION_CONTEXT(), SELECT Trial_Addmission.PathName() from Sat";

Microsoft文档for GET_FILESTREAM_TRANSACTION_CONTEXT [ ^ ]表明它必须在选择语句中使用。



我从未见过有人使用过GET_FILESTREAM_TRANSACTION_CONTEXT，所以我无法帮助你编写代码。请参阅Microsoft示例以获取帮助。

The Microsoft documentation for GET_FILESTREAM_TRANSACTION_CONTEXT[^] shows that it must be used in a Select statement.

I've never seen anyone use GET_FILESTREAM_TRANSACTION_CONTEXT, so I can't help you write your code. See the Microsoft example for help.

这篇关于" '）'附近的语法不正确我需要帮助，这段代码有什么问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！