currently i am working on wcf...i am adding data through textborex till here is ok. but when i am retriving it from database into grid..but the grid is getting blank...
i am using this query..--page - svc.cs
public List<AddressBook> BindData()
{
DataClasses1DataContext dc = new DataClasses1DataContext();[code]....
I'm looking to translate an SQL query into linq
INNER JOIN Usrs ON
SAQ.UserId =
Usrs.UserId AND Scan.UserId =
Users.UserId
I'm not sure how to include the "AND" in the LINQ statement.
[Code]....
[Code]....
'm not sure if this is the right forum, but I couldnt find one for linq related questions.I have the following problem. I have four tables, One with users, one with projects, one with the users and the projects they are in (joinProjectTable) and on table where the users can fill in there worked hours for a certain project. These hours are filled in on a daily base. Now every month there is going to be created a report on the workedHours table so there is visible which user has entered how many hours for a certain project. On this report there is gonna be a billing for the company where for the hours are worked. This is the easy part, the hard part is the following.
companies also want to have a list of users that didn't entered any hours for that particular month for a particular project. So I have to write a linq query that would look in the joinprojecttable to see which users are joined to which projects, and than with that join it should look if that particular combination (user+project) is in anyway entered in the workedhourstable for that particular month. If not this has to be shown in the datagrid, for every user that isnt in the workedhourstable for that month. So it should be a certain NOT query, but I can't seem to figure it out.does anyone have any idea to accomplisch this in Linq2Sql? I'm using VB instead of C#.
I've got a gridview that will allow clients to edit options they've already entered on another page. The gridview has three radio buttons in it each with a value of 1,2,3. The option value in the dataset is 1,2 or 3 respectively. I would like to have the radiobutton with the corresponding value selected in the gridview so they can see what they previously chose and will then be able to edit, if they wish.
Here's my code so far:
[Code]....
select Groupid,GroupName,onorusername from palgroup where groupid in (select distinct Groupid
View 5 Repliesif LINQ to Entity queries the EDMX class or its .CSDL or SSDL XML on its way to getting data from the RDBMS?
View 8 RepliesI have database as
ID        name    desc     rupees
1        Test1      abc     1000
2        Test2      dcf     1000
3        Test3      edf     1000
1        Test1      dcd     1000
2        Test2      dcf     1000
Now I want a linq query to check for the duplicate name and if present adding its rupees...
E.g.: Result will be
     name        rupees
     Test1        2000
     Test2         2000
    Test3         1000
I have this ListView that has a Drop Down List.Everything works fine (I think/hope) except that the drop down list are not showing its result correctly.This is the code.
Front-End
[Code]....
The code behind consist of the page_load and the ItemDataBound
[Code]....
I want to use "if statement" in Linq query. How can I do this situation?
For example:
if txtAge.Text=="", I will not use that in Linq Query.
else txtAge.Text!="", I will use that in Linq Query.
i"ve build a small (verry small) test app with a UI and a domain model and i'm able to show all the data from one table but now i wanna create a query so i only get the data i want but i have no idea how to do this. i've created a domain model with a entity class, an abstract and a concrete repository (see code)
[Code]....
namespace winkelketen.domain.Abstract{ public interface IwinkelketenRepository { IQueryable<Winkelketen> Winkelketen { get; } }}
namespace winkelketen.domain.Concrete{ public class SqlWinkelketenRepository : IwinkelketenRepository { private Table<Winkelketen> productsTable; public SqlWinkelketenRepository(string connectionString) { productsTable = (new DataContext(connectionString)).GetTable<Winkelketen>(); } public IQueryable<Winkelketen> Winkelketen { get { return productsTable; } } }}
and then i created a UI with a controller
[Code]....
and a view
[Code]....
could something give me some tips how to do this or how to get started?
I have a web application that uses LINQ-to-SQL. It has a very strange issue, where a LINQ command retrieves the data that is supposed to be returned by another, totally different query that runs in a different thread. What could be the cause of this?
Specifically, a user accesses the application from his machine, opening a certain page. At the same time, another user accesses a different page from his (different) machine. One of the queries throws an exception, while the other returns the data of the first one, which comes from a very different table!
The case is always reproducible, whenever we stress the application with these two users. I've checked but I don't see any shared variables of any kind. What else could the problem be? What should I be looking for?
I've build a linq query.But i want a random selection so its not always ID : 1,2,3,4,5,6 How can i randomize this var? I like to bind it to a repeater.//TagCloud:
Random rand = new Random();
var tc1 = from i in JumpTide.cms.menu.GetMenuItems(32)
select new
[code]...
I´m using Linq to Sql in my asp.net application, but the problem is:I have a query like this:
[Code]....
My query is not returning anything, how do I do to get this?my problem is with this interval I need to have.
I am trying to figure out why this service does not return any data. The service does not error out is just doesn't return any data. When I take the Linq into LinqPad the query returns exactly as I expect. So I am wondering if the problem is getting my return data into a List<string>??
[Code]....
I don't know what else to say to help. When I set a break point on the "return LoanStats" line a quick watch shows an empty results view.
I want to use from two db connection in one linq query
My sample is:
int a=1;
if(a==1)
DataClasses1DataContext1 db = new DataClasses1DataContext1();
else
DataClasses1DataContext2 db = new DataClasses1DataContext2();
var q =
from c
in db.F_Groups
select c;
In this code a=1 so db connection is DataClasses1DataContext1
I want if a=2 then db connection = DataClasses1DataContext2
but this code is error.
db connections is completely same but in two deferent class a db connection is sql and another is oracle
How can I convert this sql query to LINQ ?
[code]...
Im doing thing profile, zip code thing on my site. One table has a list of zipcodes and in the other is a profile and there they keep what zip code they entered. I already have the radius code but idk how to get a list of all the profiles in a radius.I'm going to store the zip codes that come back from the zip code table in a arraylist and put it in a session state so i don't have to keep getting the same thing over and over again. The problem is i don't know how to write the linq to sql query to take the arraylist of zip codes and look up all the users that have that as there set zip code in there profile.
View 1 RepliesIs there a way opf getting the first value from a linq query so for example
[Code]....
So I'm trying to add a single item to a query I wrote. The query is then pass to the e.Result of a LinqDataSource_Selecting event. This datasource is being used by a dropdown list and label in a listview.
I am trying to add a "New" field to the end of the list.
Currently I have this working, but it seems like a really messy solution. First I make a class with the fields I need:
[Code]....
Then I build the query:
[Code]....
Then a second list and query with the new value:
[Code]....
Finally, I union the two and set the e.Result:
[Code]....
I need to know how to extract the result of the attempted LINQ query below and set it equal to the strFile variable.Everything Intellisensed OK here but ine 5 shows a syntax error at the parenthesis.
[Code]....
I'm having a problem with a Linq query where is executing the second half of an OrElse even though the first half evaluates to true.
[Code]....
When Manufacturer is null, I get a NullReferenceException. The "Manufacturer.Trim()" should never be executed, because the first half of the OrElse evaluates to true. Just to test it out, I also tried this:
[Code]....
This actually works fine... Manufacturer.Trim() is never executed, and I get no error. Why is the Trim() statement being executed in the first case? If Manufacturer is null, then it shouldn't be.
I have this LINQ query:
var agnts = (from a in db.agents select new { a.userid, a.name }).Take(10);
How can I get randomly get 10 records from my agents table?
I have tried:
agnts = agnts.OrderBy(n => Guid.NewGuid());
but this doesn't seem to do anything.
Need to figure out the correct way to do a simple SUM function in Linq, but also manipulate one of the feilds coming back by doing a Substring on it, here is the original SQL query:
[Code]....
As the title sugests, I am missing a (basic?) concept as I teach myself asp.net, linq, and C#. It has been awhile since I've done anything object oriented, so I don't know how much that is impacting this gap in my understanding. Anyhow, here is what I am trying to do. I have three SQL Server tables: PERSON, POSITION, AREA. There is a 1 to many relationship between PERSON and POSITION, and a 1 to 1 relationship between POSITION and AREA. Given the following code I verify who the person is who has logged into the browser:
[Code]....
I want to be able to return all of the AREAs the person is able to access, based on the position they currently hold. I am able to easily do this in a SQL Server query, and I am sure I can do this with a SQL stored procedure once I pass the EMPLOYEE_ID to the procedure. However, I would rather do this in the page_load event, and load the returned results into gridview1 for the viewer. The issue I am running into is in building the LINQ query. When I try to build it, I can only get access to two of the three tables, depending on which table I select with db. Is it possible to access all three tables in the same query?