problem about select-statement-Collection of common programming errors

11 years ago
admin
1 minute

  • Tom H.
    c# sql parameters sqlcommand select-statement
    I’m paging data using an ObjectDataSource and I have the following method:public int GetNumberOfArticles(string employeeIds) {System.Data.DataTable dataTable;System.Data.SqlClient.SqlDataAdapter dataAdapter;System.Data.SqlClient.SqlCommand command;int numberOfArticles = 0;command = new System.Data.SqlClient.SqlCommand();command.Connection = Classes.Database.SQLServer.SqlConnection;command.CommandText = @”SELECT COUNT(*)FROM [Articles]WHERE [Articles].[EmployeeID] IN (@EmployeeIds)”;command.Param

Web site is in building