I have loaded the drop down box from LINQ,
CustomerDataContext customer = new
CustomerDataContext();
ddlCust.DataSource = from cust in customerDC.Customers
orderby cust.CustId ascending
select new {cust.CustId,
cust.CustName} ;
ddlCust.DataTextField = "CustName";
ddlCust.DataValueField = "CustId";
ddlCust.DataBind();
it is working fine but I want item of drop down list as :
Text: Select
Value: 0
How can I do that?
I'm new to Linq. I have searched and searched the web for a soluion, and can't find anything. I have a Linq query and I want to insert a row ("Select User") to the top before I pass it to the drop down list. I've been trying to use the Union but to now avail (it keeps telling me that my object doesn't support the Union method). My code, prior to attempting to inser a row, is very simple.
public SelectList DropDown_Users()
{
var context = new VivarianDataContext();
var query = from t in context.AspnetUsers
select new { t.UserId, t.LastName };
list = new SelectList(query.AsEnumerable(), "UserId", "LastName");
return list;
}
Now I try to insert a row and I found this on the internet and it seems to say that his solution will work. But it is filled with syntax errors. [URL]
I tried to implement it using the following code, but it doesn't compile.
public SelectList DropDown_Users()
{
SelectList list;
//get the original data
var context = new SQL2005633131VivarianDataContext();
var query = from t in context.AspnetUsers
select new { t.UserId, t.LastName };
//create a dummy table with an empty row
var AllUsers = new List<AspnetUsers>();
var BlankUser = new AspnetUsers()
{UserId=System.Guid.Empty, LastName="Select One"};
AllUsers.Add(BlankUser);
//use Union to join the data - ERRORS HERE
var newTable = AllUsers.Union(query);
list = new SelectList(newTable.AsEnumerable(), "UserId", "LastName");
return list;
}
i do have a stored procedure which inserts data and the message should be displayed that data has been sucessfully updated or not
[code]....
I have a table and i want to use this table in asp.net page
how i will call the stored procedure on the basis
of Stored procedure's Action .
Â
CREATE TABLE Std_Enquiry(
StdID int IDENTITY(1,1) PRIMARY KEY CLUSTERED ,
FirstName varchar(50) ,
LastName varchar(50) ,
[Code].....
how can i select a record from A table and insert into B table using linq?
View 2 RepliesI am struggling to create a webservice method using LINQ technology and to populate a dropdown in a form. Here is the Webservice code.
[WebMethod]
public
string[] GetAllCountries()
{
LinqClassesDataContext db =
new
LinqClassesDataContext();
var q =
from c
in db.ListContinents()select
c;
return q.ToList() ;
}
And here is the form code behind
protectedvoid
Page_Load(object sender,
EventArgs e)
{
WSClass WS =
new
WSClass();//bool
ds = WS.GetAllCountries();
var v = WS.GetAllCountries();
ddlContinent.DataSource = v;
ddlContinent.DataBind();
}
I'm using the code below to extract data from a gridview and populate it into textboxes for the days and two drop downs for Project and Category.
For some rows in the gridview everything but the category ddl populates correctly. If I click the row a second time the category ddl displays the correct category.
why I have to click twice for some rows?
[Code]....
What is difference between select { } and select new {} In Linq Query
View 3 Repliesi have two dropdownlist. i wanna select first than second dropdown will fill according to first dropdown. for example first is categories, second is sub categories. i do not wantto use javascript.
View 2 Repliesi have one dropdownlist, i bind it to a datasource with this code.
[Code]....
i have one dropdownlist, i bind it to a datasource with this code. But when i run the website this dropdownlist, no matter if i select the last item, the value selected is the first one.
i am trying to use LINQ to populate a drop-down. This code works fine on my local machine, but I get an error when I try to run it on the live site.
The error occurs on this line: ddTicketMasterRoles.DataBind()
The error message is:
.Read_VB$AnonymousType_0`2(System.Data.Linq.SqlClient.Implementation.ObjectMaterializer`1<System.Data.SqlClient.SqlDataReader>)
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.MethodAccessException:
[code]....
I have a dropdownlist , where one of teh item text is "Payment -> Enrollment" and value is not unique'
so for one of teh condition i had to select the item "Payment -> Enrollment", but with teh below code the "Please select option text is changed to this text and finally the dropdown loads with 2 items having "Payment -> Enrollment". I cannot do ddlCategory.SelectedItem.Value as teh value is not unique ,teh value is teh amount which keeps changing .
easy way to select the item "Payment -> Enrollment".
ddlCategory.SelectedItem.Text = "Payment -> Enrollment";
I have a dropdown that has datain the format "ID Title" sorted on the Title.
Ex data is
122343 Another Example
320078 Machines are fun
953278 This is an example title
145678 Welcome to my world
Now the data in the dropdown is becoming too large. And customers have to scroll down a lot to get to a specific title. What I am trying to do is give links above the dropdown (A, B, C, ...., Z, 0, 1, ...., 9). When A is clicked the dropdown should select the first Title that begins with A and so on.
why use where condition before select statement in LINQ
View 2 RepliesI am using this C# with linq to sql:
string currentLabel = from s2f in stream2FieldTypesTable
where s2f.s2fID == item.s2fID
&& (s2f.s2fLabel != item.s2fLabel || s2f.s2fIsRequired != item.s2fIsRequired)
select s2f.s2fLabel;
I am getting a compiler error saying i can't assign type System.Linq.IQueryable<string> to string.
I tried this code:
string currentLabel = from s2f in stream2FieldTypesTable
where s2f.s2fID == item.s2fID
&& (s2f.s2fLabel != item.s2fLabel || s2f.s2fIsRequired != item.s2fIsRequired)
select s2f.s2fLabel.ToString();
And that returns the same error. I'm sure this is a simple thing. what am I missing? I just want the first s2fLabel that matches the where clause.
how to indicate which columns I would like returned at run-time from a LINQ To SQL statement?I am allowing the user to select items in a checkboxlist representing the columns they would like displayed in a gridview that is bound to the results of a L2S query.I am able to dynamically generate the WHERE clause but am unable to do the same with the SELECT piece. Here is a sample:
var query = from log in context.Logs select log;
query = query.Where(Log => Log.Timestamp > CustomReport.ReportDateStart);
query = query.Where(Log => Log.Timestamp < CustomReport.ReportDateEnd);
[code]...
[Code]....
[Code]....
I have to get the maximum of these two select values. The select values are nullable. How do I go about checking if the value is null before calling the Max() method on it? I tried the ?? coalesing operator (example: e.HomeSales.Max() ?? 0M,) but I get the following error:"Operator '??' cannot be applied to operands of type 'decimal' and 'decimal'"
I am use the new ASP.NET MVC 2 and Entity Framework, but when I try to create a new view with strongly-typed option selected, the entity objects is not appears at dropdown and I cannot use the view creation wizard. I recompile the solution, but still not appears yet. Have any workaround that I forgot to do to enable the entities to be displayed at dropdownlist ?
View 5 Repliesi want to validate dropdownlist which is bound to objectdatasource. i am using following code but the listitem <asp:ListItem Value="-1">Select</asp:ListItem> doesnot appear. it shows only items that are stored in database. please help me how can i validate this dropdownlist.
<asp:DropDownList id="drpdwnFID" CausesValidation="true" runat="server" DataSourceID="objDtsrcForums" DataTextField="Title" DataValueField="ForumID" >
<asp:ListItem Value="-1">Select</asp:ListItem>
</asp:DropDownList>
<asp:RequiredFieldValidator ID="rqrValidDropDwn" InitialValue="-1" ErrorMessage="Select Forum" runat="server" ValidationGroup="submit" ControlToValidate="drpdwnFID" Display="None"></asp:RequiredFieldValidator>
Here is my Controller:
public class MatchManagerController : Controller
{
//
// GET: /MatchManager/
public ActionResult Index()
{
return View();
}
public ActionResult CreateMatch()
{
return View();
}
}
Here is my View:
@model MatchGaming.Models.MatchModel
@{
ViewBag.Title = "CreateMatch";
}
CreateMatch
@using (Html.BeginForm()) {
@Html.ValidationSummary(true).....
I want my MatchTypeId to be a drop down that populates from my table MatchTypes.
I am developing the asp.net mvc application . my one of forms requirement is that:
It has dropdown filling up with let say A,B,C values. If selected A then on UI there should be 2 text boxes should be visible and other should be invisible , if selected B, then must be add another 2 text boxes , i this way there should be 4 text boxes. same for selection of C.
I able to get the selected value by
[code]....
What I have to do. I tried hide() show(), but i think it is not working for me.
I want to select "Algeria" as default selected value in drop down list.I am fetching countrylist from database using handler ( LoadCountryList.ashx ) in JSON data format and binding it to dropdownlist on aspx page using Jquery's $.getJSON precedure given below
[code]...
I have a dropdownlist on my page that when a user selects an item sets the list for another dropdownlist. My problem is that no matter what the user selects in the 1st dropdown it resets itself to the first item in the list. I have autopostback=true and nableviewstate= true. Is there another setting i'm missing or is it my code?
[Code...]
I got the following query to group the table. I am wondering how to add a subtotal record with anonymous type.
string prevOriginator = string.Empty;
var oOriginator = (from I in dtIssue.AsEnumerable()
group I by new {RaisedBy = I.Field<string>("RaisedBy"), ItemType = I.Field<string>("ItemType")} into grp
[code]...
I have several tables to load from depending on a string value using Linq to Sql I currently have
[Code]....
but of course that only gets the specific table DOffices if I wanted to grab tables at runtime what would be the best way to go about it?