[Code]....
i am using gridview control and a linqdatasource and its all working fine and i have added the functionlity of searchingBySubject and i added WhereParameters and than binding my gridview (see the code below) but somehow its not returning any rows and i see i have number of rows based on what i am searching.
the problem is not solved the way i wanted but i go ahead give the credit to : ŁukaszW.pl for his time and effort.
i am using gridview control and a linqdatasource and its all working fine and i have added the functionlity of searchingBySubject and i added WhereParameters and than binding my gridview (see the code below) but somehow its not returning any rows and i see i have number of rows based on what i am searching.
protected void btnSearch_Click(object sender, EventArgs e)
{
this.LinqDataSource1.WhereParameters["Subject"].DefaultValue = this.txtSubject.Text;
[ode]....
I have dropdownlist of dates and depending on the date that the user selects from list, I would like to filter records that fall between the startyear and finishyear columns in the datasource. (My the problem is that I do not know how to declare the Startyear and Endyear from the query in the code as they appear underlined - probably the BETWEEN syntax is wrong too).
yYear = DropDownList1.Text
Using connection As New SqlConnection("Data Source=CHRIS-PCSQLEXPRESS;Initial Catalog=TorGHL;Integrated Security=True")
Dim cmd As String
cmd = "SELECT BarDetails.*, MenuHeadingId AS Expr1 FROM BarDetails WHERE (MenuHeadingId = 2)" & "WHERE " & yYear & " BETWEEN " & "(" &
StartYear & ")" & " AND " & "(" & EndYear & ")"
connection.Open()
Dim dapubcb As New SqlDataAdapterDim sqlcomm
As
New SqlCommand(cmd, connection)
dapubcb.SelectCommand = sqlcomm
Dim dspubcb As New DataSet("BarDetails")
dapubcb.Fill(dspubcb, "BarDetails")
after hours of searching and testing (and found no luck), I came here to ask for your help again. I have a gridview and two dropdownlists. The first dropdownlist (DropDownList1) filters the gridview with Type of Customer. Here is the code on the aspx:
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
AppendDataBoundItems="True">
<asp:ListItem Value="1" Selected="True">A Type</asp:ListItem>
[code]...
have detailsview
<asp:DetailsView
ID="dtlviewRecommendation" DataSourceID="LinqDataSourceRecommendation"
DataKeyNames="PK_TT_RecommendationsSysId">
[code]...
I have a standard gridview, with the standard paging and sorting interface enabled.The application holds appointments for three organisational units, with a maximum of 3000 appointment records being returned across all three units. The appointment records are quite small.
The choice I am faced with is to:
1. Have an Org Unit dropdown which returns to the datasource on change of selection and at inital databind, and returns appointment records for one org unit at a time i.e. approx 1000 records.
2. Have the objectdatasource return all 3000 appointment records for all org units at initial databind, and filter the objectdatasource by org unit on change of selection, thereby saving a trip to the datasource.
I guess the question boils down to identifying the point at which querying the datasource by org unit is more efficient than filtering the records returned by org unit.
Is 3000 records a lot for a gridview to be paging and sorting etc.
I'm trying to filter data based on the selected value from a drop down list and the according values of a local variable within a gridview_rowdatabound event. For example, if "In Arrears" is selected, the gridview should return all rows where the account balance is less than -100. So far, when I select a value from the dropdown list, it has no effect on the gridview. Here's the code I have:
If (DropDownList1.SelectedIndex = 0) Then
e.Row.Visible = True
ElseIf ((DropDownList1.SelectedIndex = 1)
And (AccountBalance <= -100))
Then
e.Row.Visible = False
ElseIf ((DropDownList1.SelectedIndex = 2)
And (AccountBalance > 100)
And (AccountBalance < -100))
Then
e.Row.Visible = False
End
If
I am writing an ASP.Net web application. I have listview, it's datasource is a LinqDataSource. In my database, I have a staff table and I am trying filter for records by their team using a dropdownlist. This works fine, until I select "All" in the dropdownlist. It returns all staff except for the ones where the teamID is null. How can I return the records where teamID is null?
This is my code:
<asp:ListView ID="ListView1" runat="server" DataSourceID="ldsStaff" DataKeyNames="staffID">
<LayoutTemplate>
<table>
<tr>
<th>Name</th>
<th>Team</th>
</tr>
<tr>
<td> </td>
<td><asp:DropDownList ID="ddlTeamFilter" runat="server" DataSourceID="ldsTeams" DataTextField="Team" DataValueField="TeamID" AppendDataBoundItems="true" AutoPostBack="true">
[Code]....
I have this GridView with this member details:
Members (ID, Title, Forename, Surname)
I want to use Drop Down List to Filter Members table by MemberType, this means having to Join the following three Tables..
Members (ID, Title, Forename, Surname, Memb_ProdID*) has Foreign Key for MemberProducts Table
MemberType (ID, MembType)
MemberProducts (ID, Duration, Price, Terms, memb_TypeID*) has Foreign Key for memberType table MembType is in Italic and underlined, how do I use this to filter members details in GridView.
I've got a GridView populated via a SqlDataSource whose Select command is controlled by a DropDownList. This is all working nicely:
How do I support the "All" user choice:
In other words, when the user selects "All" there are no aircraft names that match that so nothing is returned. Instead, I'd like the select statement to skip the WHERE clause in this case and just show everything. Do I need to create a second page for this case or is there a way to programmatically alter the SELECT command or some other way to accomplish this?
The datasource of the datagrid is a LINQDataSource which relies on the value of a dropdownlist. In addition, I want to use the footer to insert new records - so I'd prefer not to use the empty dataset template. I am trying to find a way to always display the footer regardless if the datasource is empty or not.
EDIT:
Is there a way to create an empty/invisible object of the type in the LinqDataSource?
Im trying to build a where clause in c# for a LinqDataSource, but I cant get it to work, heres my code
[Code]....
when I set category to 'Concerts' tyhe where clause is
'Category = Concerts'
this generates an error telling me there is no column called 'Concerts'. I assume I somehow have to enclose the search term in quotes, Ive tried single and double quotes, but nothing works.
So I need to take the literal "SELECT....FROM Bay....WHERE Warehouse=1 and ((BAY LIKE '1.0%' or BAY LIKE '2.0%'))I have set up a linqdatasource on my asp page and I want to bind that to a gridview. Here is the start of the HTML:
<asp:LinqDataSource
ID="dsBays"
runat="server"
ContextTypeName="CartonInventory.CartonInventoryDataContext"
EnableUpdate="True"
[code]...
How do I add a parameter so that it includes the LIKE statement?
I have a gridview that takes in values from a sortedlist. I want to filter those values before putting them in the gridview without taking values out of the list.
Is there an easy way to do this? Or do I have to redirect the data through another list and point the gridview to it?
I'v been using SqlDataSource and ObjectDataSource for a while.I would like to know about LinqDataSource and EntityDataSource. Therefore I have 2 questions to ask.1) Why do we need to use those twos? 2) In which cirmustances (Requirements) developers are using LinqDataSource and EntityDataSource?
View 1 Repliesi am an asp.net beginner, i am a windows application programmer and currently i am working on big project " Human Resources" and i need to allow the users to apply for jobs using a web page.in windows application, i can use the bindingsource to bind textboxes and comboboxes to the fields of an object from L2S.and to bind the datagrid also to the detailed data and the page will be for inserting issue only,i.e i don't need to bring the data of applicants and certificates from the database, i just need some lookup data like maritalstatusCombo and availableJobsList things to allow the user to choose from.how can i do this using linqdatasource.
View 3 RepliesI use LinqDataSource and GridView.
I need an old value of field "PictureBig" in RowUpdating handler like this:
e.OldValues["PictureBig"]
To achieve this I use bound unvisible literal in edit item template...
<asp:Literal ID="ltBig" runat="server" Text='<%# Bind("PictureBig") %>' Visible="false" />
Is there any better ways of doing this?
I am trying to program the where prameters for this in code behind in C#, and is there really no way to do more than one parameter? Or am I not understanding this correctly? It seems only the 2nd parameter gets executed, no matter which one is at begining. I debug and seems they both get executed fine, but my listview doesn't get filtered and instead only the 2nd paramter works. Look at my code:
Also, if I do myLinq.Where = "division ==1 and someotherInt = 2", it works fine, but if I do two different data types, it will throw error. Since I want to filter with two different data types, hwo do I do this?
Parameter pram1 = new Parameter();
pram1.Name = "division";
pram1.DbType = DbType.Int32;
[code]...
I'm having a question about the LinqDataSource. Does anyone know if it's possible to perform multiple inserts with the LinqDataSource? Let's say for example that I have 2 tables.
Table A
AID = PK autoincrement Name AddressA FK AddressB FK
Table B
BID = PK autoincrementStreetNumberPostalCodeCountry
These tables are just examples to clarify my question. Let's say that I have a FormView with a LinqDataSource where the user can enter his name en a billing address (A) en delivery address (B). Now I would like to know if the LinqDataSource is able to insert 2 records in table B and use these ID's to insert them in table A together with the name?
I need to retrieve data using a date as an input parameter. I created a WhereParameter and passed in a date value that I know to exist in the database, but no data is returned. Heres my code
[Code]....
Ive passed in '02/06/2010' as the date, in the database, the Startdate column has several values of '2010-06-02 13:08:50.503' so I guess its not being found because of the time part. Whats the best way to make sure that I retrieve the correct data ? Im not concerned about the time at all, I just need all rows for 02/06/2010.
If I have a Linqdatasource that isn't connected to a a bound control on my page how do I use the data source to read data in the code behind. ie
var query = (from x in linqdatasource select x)
What I actually want to do is create a data array (myArray) within the code, read all of the data from the linqdatasource (selecting 1 field to form tableDataArray), then compare the two arrays and then write (insert) those into in myArray that are not already in the datasource to the datasource (ie execute an insert back on the datasource).
Where can I find documentation on the syntax that is expected for LinqDataSource.Select? It seems to be different from what I would do with Linq inline in C# code. For example, concatenateing something in Linq I would normally just do this in the projection:
new { FullName = (person.FirstName + " " + person.LastName ) }
However, with a LinqDataSource the only way I've found to do this is like this:
new ( String.Concat(person.FirstName, " ", person.LastName) as FullName)
I literally spent hours trying to figure this out, and only succeeded when I found a blog where someone gave this verbatim as an example. So I still don't understand why the syntax is different, the braces versus parens, aliasing, Concat operators. Next time I do this I want a better understanding so I am not playing this guessing game. It's like being handed a compiler, and trying to write a program when you don't know what language the compiler compiles.1. Are there different "flavors" of Linq? Like a VB Linq, and C# Linq?2. If so, is the LinqDataSource using a VB flavor of Linq?3. Really, what is really important to me, where can I find documentation on this particular falvor of Linq that the LinqDataSource expects? The documentation for the LinqDataSource itself gives nothing more than extremely simplistic examples.
I just started working with LinqDataSources and I was wondering how you retrieve values in a FormView DataBound Event.
With an ObjectDataSource I believe you can grab them like:
[Code]....
Is there a similar way to acheive this with a LinqDataSource?
I have a gridview on a page and based on the row selected I need to fill out a form view (dynamic data enabled) from a linqdatasource. On gridview_sleectedindexchanged I create the linqdatasource and set it as the datasource for the formview. It displays nicely but clicking update returns a "Could not determine a MetaTable" error for the datasource mapped.
THe goal is to create a single page that allows users to select a row then get the appropriate data, create an updateable formview so further edits can be done. Do not want to scaffold.
I have LinqDataSource ID="LinqDataSource1" with values - EnableDelete="True", EnableInsert="True" EnableUpdate="True" on my ascx page, furthermore GridView, button a few textboxes, where a fill new values, which I would like save in my database. After click on button I insert new value to the table throught in function stored in ascx.vb page. It is works, but I don't know, how I refresh GridView on ascx page. I tried
LinqDataSource1.DataBind()
GridView1.DataBind()
without any good result, I must refresh page manualy (F5).