Browse by Tags

Home ›

All Tags » query » SELECT (RSS)

Linq dynamic select query, occur injection

Hi, Im making an c# asp.net webservice and using Linq for my DAL layer. I have an method with some parameters. I would like to use the parameter values in an SELECT query after the WHERE. Something like this: public void GetItems(String filter) { string sql = "SELECT * FROM ConfigurationItems WHERE...

Posted to Data Access and ObjectDataSource Control (Forum) by khalidelmeknesi on 05-28-2009, 12:00 AM
Filed under: Query, Dynamic, Linq, Select
Select query for gridview

Hi everybody, Im making an c# asp.net website. I have 2 tables with an relation between them. Im using an dataset with for each table an tableAdapter. Here are my tableAdapters: I have an gridview and an objectDatasource(to the StatsTableAdapter). For the select method Im using the method "GetUsersByDate"...

Posted to Data Access and ObjectDataSource Control (Forum) by khalidelmeknesi on 03-16-2009, 12:00 AM
Filed under: Query, DataTable, SELECT, GridView
Join on table with multiple instances on one side

I have two tables I want to join on customer id table a has one instance of a customer table b has three instances of the same customer When running the query, I am getting 3 results being returned which is not correct. I need just one to be returned. I have tried joining on another select, using distinct...

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by Metalore on 09-25-2009, 12:00 AM
Filed under: ASP.NET, SQL, query, SELECT, Inner join, server
Getting error while passing values as special chars

Hi friends, I m facing an error while i m passing the values in query as special characters like (',"). anyone can help me? code will be more preferable. Thank you.

Posted to SQL Server, SQL Server Express, and SqlDataSource Control (Forum) by jaymehta_26 on 03-04-2008, 12:00 AM
Filed under: query, query?, querystringparameter, selectparameters, queries, "SQL Server", SELECT, SELECT ExecuteNonQuery