SQL Server Data Rows exception incorrect syntax

-1

I am working on a function and getting an error that keeps pointing in the area where the DataTable object is getting declared but it is only giving the following error (see below). Can someone tell me what I am missing?

Code:

SqlConnection myConnection = ConfigManager.SqlConnection;

/// <summary>
/// Load Data Rows for Section Type ID
/// </summary>
public void LoadSectionTypeIDList()
{
     String sql = "SELECT DISTINCT section_type_id"
                + "FROM [claims_module].[dbo].[template_clob_gl]"
                + "ORDER BY section_type_id";

     SqlDataAdapter myAdapter = new SqlDataAdapter(sql, myConnection);
     DataSet ds = new DataSet();
     myAdapter.Fill(ds, "claims_module");

     DataTable dt = ds.Tables["claims_module"];
     SectionDropDownList.Items.Add("Select");

     foreach (DataRow r in dt.Rows)
     {
         SectionDropDownList.Items.Add(r["section_type_id"].ToString());
     }
}

Error:

System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '.'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction)
at System.Data..SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader..get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource
1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data..SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at admin_utilities_FileUpdater.LoadSectionTypeIDList() in c:\Development\git\wteel\source\rewardtrax\inetpub\wwwroot\claims_module\admin\utilities\FileUpdater.aspx.cs:line 39 at admin_utilities_FileUpdater.Page_Load(Object sender, EventArgs e) in c:\Development\git\wteel\source\rewardtrax\inetpub\wwwroot\claims_module\admin\utilities\FileUpdater.aspx.cs:line 23 at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) ClientConnectionId:5793f80a-e918-4387-a3e3-f0840e7c983e Error Number:102,State:1,Class:15

c#
sql-server
webforms
asked on Stack Overflow Oct 24, 2018 by Justin Williams • edited Oct 24, 2018 by marc_s

1 Answer

1

I noticed that it was a syntax error from missing spaces between the sql statement. Once I fixed it, the statement ran and the list appeared.

answered on Stack Overflow Oct 24, 2018 by Justin Williams

User contributions licensed under CC BY-SA 3.0