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'm having a problem with my Linq to XML query. I'm getting the result data I want, but it's nested so deep that there must be a better way.Here is my XML:
[Code]....
I'm trying to get a list (simple string[]) of all Item IDs where Category Names contains "Other".Here is my Linq:
[Code]....
[Code]....
Here is a snapshot of my result from Visual Studio:The results I want are there ("item100", "item400", "item500"), but buried so deeply in the results var.
How can I get the query to return a simple
string[] = { "item100", "item400", "item500" }
I have a listview that is showing its result by using a linq query. The linq query goes like this.
[Code]....
* db.Varer: Varer is a table that contains basic product information like proudct name, product nr. etc. ** a.fk_kategori_id == CatParamId : I'm just saying limit the result according to the Category ID (a.fk_kategori_id). The category id is coming from a dropdownlist (CatParamID) *** Join: Besides the Varer (Product) table I also have another table, Sizes. This Sizes table contains 6 columns (ID_Sizes (int) primary key and the columns: OneSize, S, M, L, XL, XXL all are bit (true or false)). There is a relationship between Varer table and Sizes table. It says that I can only insert a value into the "fk_sizes_id - column" of varer table if that value already exists as primary key within the Sizes table. **** I'm starting by picking basic product values like productId, ProductName etc from the Varer (a) table ***** Then I'm picking the corresponding Sizes values (onesize, s, m, ...) from the Sizes table. Now within my ListView I'm showing the above result by using Eval, like this.
[Code]....
And this works perfectly, but now comes the thing that is causing me trouble. I have the below drop down list (still within the ListView ItemTemplate):
[Code]....
I want this drop down list to be populated with only those of the "linq query's Sizes table result" that are true. By "Sizes table result" I mean these
[Code]....
i have asp page. i did the connection with connection string. the query is to search name, id and phone numbers. i wand to display these data in 3 textboxs. how can i display these results in textbox.
this is the connection code.
SqlConnection con = new SqlConnection();
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;
con.ConnectionString = "server=localhost;uid=sa;pwd=sa;database=mydatabase";
cmd.CommandText = "select ename, id phone from emp";
now i want to display these data in 3 textboxs. how can i do it.
How can I use Order by on the result of a LinQ to SQL query ?
I have the following Situation:
Dim ret As New Object
ret = From status In tableStatus _
Select status.STATUS_ID, _
Text = Function_GetText(status.TEXT_ID)
Now I have to order this result on the field Text, has anyone an idea? (I can't use in my case Orde by Function_GetText(status.TEXT_ID))
How to randomize a LINQ query result?
Below takes 4 of the records but it won't randomize in every request. [:(]
Dim products = (From p In Northwind _
Order By Guid.NewGuid _
Select New With { _
.Name = p.Name, _
})
Return products.Take(4).ToList()
i want take a single value result from linq query
if i have :[Code]....
the variable result does not return nothing, only tostring() and similar how can i get a single result from linq query and use it in my ID variable?
New to Linq and Var type have a method where linq query is executed, want to return the result and assign it to GridView. but method don't take the return type as var.
So was wondering how do i return this query result?
Should i assign this result to DataTable first and make the method return type as DataTable?
Here is the code, This is what i want to do but not sure what is the right way
[Code]....
for example,
var result = from category in myEntities.Categories
where category.UserId == userId
orderby category.CategoryName
select category;
What is the type of "result"? I casted it to an IQueryable variable and it worked except it did not have some of the methods normally available, e.g. Count(). In my program I have to cast it to some explicit types and then use the Count() method.
I am running a LINQ query which populates a list used by a DropDownList, I need to insert an "Unassigned" value to the list. The function below queries the values correctly from the db but does not insert the "Unaasinged" value to the list.
[Code]....
i have a new question: i read all the tutorials that i found but i cannot understand how to pass a result of a linq to entities result to the view so that i can display the results. My query is actually in the controller function ot the view, i would now loop the results and display them in the page. How?
View 23 RepliesI Pieces
NA 400
I am new to this, and I am trying to implement a linq query similar to db.Genres.Include("Albums") command from
mvc music store using my current DB setup. I realize that the tutorial mentions Checlking the "Include foreign key columns in the method" when creating the tables in ADO.NET, but if I am using LINQ to SQL classes, then how can I obtain the same effect. And how do I use
db.Genres.Include("Albums") to simplify my life?
How do i check if linq insert/update query was successfull or how many rows were added/updated?
View 1 Repliesmy query is like this " select product_id, product_price, purchase_amout from purcases"
and on my formview i tried to add a "total purchase"
i tried using <asp:Label ID="total_purchase" runat="server" Text='<%# string.format(cint(eval("product_price")*eval("purchase_amout")),"{ Rp 0:###,###,###,###,###}")%>'>
the total amount show the correct calculation result, but the string format dont work.... so it display 20000 instead of Rp 20,000
btw. "Rp" is the currency symbol in my country... i dont use {0:c} coz the server user US currency
For context: First of all, I am new to LINQ, as I have been using SubSonic for quite some time now.
I have two tables, Users, and Affiliates. They both have a very typical schema. The FK that joins them is the UserId field, which is in the Affiliates table. I want to create a LINQ query that pulls the Username from the Users table using the AffiliateId value. The AffiliateId is a primary key of the Affiliates table.
I have tried to accomplish this using many variations of the following code:
[Code]....
In the above query, I expect to get a single row result set. However, I instead receive the entire table of results.
How can I make this work? I have yet to see an example or article out there to do what I am trying to do.
I have a query that references many tables, however the main record doesnt necessarily have records in the other tables. In my formview itemtemplate, i bind the values of the query but I'm getting an obvious error when the value is null. This is what I'm trying to do: (the field is a boolean btw). These fields are hidden so I don't really care if it gets assigned a temp value or something.
[Code]....
Error: BC30452: Operator '=' is not defined for types 'Object' and 'System.DBNull'.
Microsoft report viewer showing different sorting with query result. My rdlc report has 2 groups [2steps] .Query Result>>
col1 col2 ......
5 aa
5 bb
4 bb
4 cc
MS Viewe displays
4 bb
cc
5 bb
aa
I have a label inside a formview that is not bound to anything.
Lets say I have a table of customers (with a key field called CustomerID), and then another table that has all their orders (with amount spent per order (OrderID) - based on CustomerID)
On the FormView there is a key field (CustomerID) (this is to be used as an INPUT parameter to a SP - which is to return the SUM of all the customers (Order_Totals). I could nest a view within a view I suppose to get this result, however, I just want a label to simply show this ScalarValue.
Basically, I want the label to show the aggregate (SUM) total amount each customer has spent on all orders. I have a SP called SumCost with two Fields (one a grouped by field CustomerID and the other a Summed Total of each customer's orders SumCost)
SELECT [SumCost] FROM [SumCost] WHERE ([CustomerID] = @CustomerID)
I test my SP and it works great, returning the value based on CustomerID - no problem.
My problem is getting the CustomerID passed into the SP on runtime (do I put it in FormView2_Databound) and putting the value into the label (CustTotalLbl) which is inside this form.
i have a column named POINT.. it is the point in every question... therefore i want to get the total of this column..
View 3 RepliesI am having a problem with this code, i had a post on this however this code is slightly different to that so i thought i would post a spearate thread.
Anyway, what i am trying to do is display job vacancies by the result of a DropDownList value. Now each job name has a description. The problem i am having is i need to display the results in this logic:
Job nameJob descriptionJob location. But what is happening is the job description (body) is repeating the more vacancies there are. This is the page:
http://kidsunlimited.co.uk/vacancies_test_two.aspx
If you select Deputy Nursery Manager from the DropDown and hit the Search button you will see the results. After listing the first two locations the description is repeated and then the 3rd location is shown after this. This is my code:
[Code]....
I am having this C# string if i run this I won't get any result but i interchange the value like Between "19", " 22" then it shows correct result, to interchange this between value(In Code behind(cs file) not in Sql Server) string strQuery=Select # from [Demo].[Customer] WHERE [Demo].[Customer].[Age] Between "22", " 19" Result should be string strQueryModified=Select # from [Demo].[Customer] WHERE [Demo].[Customer].[Age] Between "19", " 22"
View 3 RepliesI am having a datatable in which the data is as follows
No Name Text
1 a abc
1 a xyz
1 a asd
2 b aaa
2 b bbb
I want to querry this data table to get the result as
No Name res1 res2 res3
1 a abc xyz asd
2 b aaa bbb
I want to populate a label with the employees name when they enter a badge number in the source page but im new to programming and don't know how to tackle this. The database connection has been established and it is successful. just an fyi this is for a time sheet application.
string Badge = "100000" + Request.Form["xBadgeTextBox"];
string Date = Request.Form["xWeekDropDownBox"];
string Hours = Request.Form["xWlengthDropDownBox"];
if (Badge != null)
{
string cmdquery = "SELECT EMPLOYEE_NAME FROM Employees WHERE Badge ='" + Badge + "'";
OracleCommand cmd = new OracleCommand(cmdquery);
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
}
I have two tables: Projects and ProjectsData and I want to execute query with join and get the result in the View. In the Controller I have this code:
ViewBag.projectsData = (from pd in db.ProjectsData
join p in db.Projects on pd.ProjectId equals p.ID
where pd.UserName == this.HttpContext.User.Identity.Name
orderby p.Name, p.ProjectNo
select new { ProjectData = pd, Project = p });
What I should use in the View to extract this data. I tried that:
@foreach (var item in ViewBag.projectsData)
{
@item.pd.UserName
}
but it doesn't work.
