Stack Overflow
Stack Overflow

Questions tagged [linqdatasource]

LinqDataSource is a Web Control which enables the use of Language-Integrated Query (LINQ) in an ASP.NET Web page through markup text to retrieve and modify data from a data object.

LinqDataSource is a Web Control which enables the use of Language-Integrated Query (LINQ) in an ASP.NET Web page through markup text to retrieve and modify data from a data object.

141 questions
0
votes
2 answers

')' or operator expected on LinqDataSource where clause

Where="((ProgModelID == @ProgModelID) || (@ProgModelID == @ShowAll)) && (((FirstName + ' ' + MiddleName + ' ' + LastName) LIKE '%' + @Name + '%') || ((FirstName + ' ' + LastName) LIKE '%' + @Name + '%'))" I need to concatenate the full name together…
Jenius
  • 174
  • 15
0
votes
2 answers

Access foreign key data linq

I have a simple requirement if done via sql query. I have table A which is category with ID,Name table b which is categoryItems which has foreign key of A CategoryId,Name. I am using linqdatasource with simple select statements to show data from…
Mandar Jogalekar
  • 3,199
  • 7
  • 44
  • 85
0
votes
2 answers

LinqDataSource - how do I select rows based on the current UserId?

I have a Grid View control that displays data based on what is returned by the LinqDataSource. The LinqDataSource selects data depending on the date chosen in a date control (used in the where clause), but I also need the where clause to be based…
Hewie
  • 225
  • 2
  • 8
0
votes
2 answers

LinqDataSource: How to assign IQueryable value to where parameters in code

I am trying to assign linq datasource in code behind but I have IQueryable query want to assign in where clouse using Any function like a sub query clause in sql this is my sql statment select * from table1 where col1 in (select col1 from table1…
Kyabroudi
  • 549
  • 1
  • 7
  • 22
0
votes
1 answer

Cannot bind dropdownlist to my linq queries

I am dragging in dropdownlist controls to my aspx page. When I write any query in the asppx.vb page and try to bind it to my ddl the ddl remains unbound. I have tried several different ways of doing it and none are working. Even if I just create…
Gavin
  • 437
  • 2
  • 8
  • 20
0
votes
0 answers

Can't delete record in formview when a value is NULL

I am having problems deleting a record in a FormView that is wired up to a LinqDataSource. The table the LinqDataSource is using allows NULL values for almost all fields. If I create a new record in the FormView and fill in all the values, then try…
Hoff
  • 1,762
  • 14
  • 27
0
votes
1 answer

cannot load datacontext in devart linconnect

I have added devart linqconnect ORM to connect to the mysql database. it is a trial version though, i have created a shopping.iqml file in my application which automatically creates a model for the linq to mysql. when i write using…
Vishal Torne
  • 366
  • 5
  • 24
0
votes
1 answer

Linqdatasource group by problem with multiple table

I'm using linqdatasource for displaying data in listview (nested because of grouping) control. I want to display data from more than one table. I'm using VWDExpress.
Sharique
  • 4,199
  • 6
  • 36
  • 54
0
votes
0 answers

DevExpress DataGrid, LinqDataSource, Row Insertion Issues

Here is a screenshot of the problem: http://screencast.com/t/ZG2NQWjxYFLh I'm trying to add a record to the DB via Linq using a DevExpress data grid. When submitting the data, the error is: LinqDataSource 'linqDsLocales' has no values to insert.…
Chris Coddington
  • 13
  • 4
0
votes
2 answers

Custom Paging With LinqDataSource & Formview

I am trying to to use a LinqDataSource's Selecting event to filter data in for a FormView, however I can't seem to get it to page properly. I can manage to get only one record to show in the FormView but the paging controls do not show up. I have…
Hoff
  • 1,762
  • 14
  • 27
0
votes
1 answer

Bitwise operators LinqDataSource Where

I have a byte column called 'Type' in my MS Server database. On my Asp.net page I have a ListView and a LinqDataSource. The 'Type' column is different enum flags. I would like to check specific bits in column 'Type' in my LinqDataSource Where…
Lasse Espeholt
  • 17,622
  • 5
  • 63
  • 99
0
votes
1 answer

Refreshing a DataGrid after delete/update

The Setup I have an application page which I try to deploy to SharePoint 2010. The page contains an SPGridView and a LinqDataSource like this:
…
Kenneth Van Coppenolle
  • 166
  • 2
  • 13
0
votes
1 answer

Filter GridView depending on userid

I have a GridView which I am binding using a LinqDataSource. I want to filter the GridView based on the value of the userid (which is stored in a Session). I also have a Session for determining if the user is an admin. If only user - Filter…
Mix
  • 117
  • 2
  • 11
0
votes
1 answer

Linqdatasource and relational data problem

I have a problem with linqdatasource. I have gridview in my page and I set it's datasource to linqdatasource,also I set AllowPaging="True" , AllowSorting="True".
Hamed
  • 207
  • 5
  • 14
0
votes
3 answers

I am using linq datasource, how can i configure a where expression

RequestDate != @RequestDate = null Gives me an ERROR: The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
Yves
  • 12,059
  • 15
  • 53
  • 57
1 2 3
…
9
10