Forms Data Controls :: GridView / Get Into The Select Statement?
Jan 6, 2011
I have walked through other posts with a similar problem but I am very stuck.I am normally use Php/MySQL and am new to ASP (actually only this new client uses it and I'm trying to help them). I am trying to filter a table to only show the last 90 days of records. I found what I thought was the easy solution shown below:
FilterExpression="columnname < GETDATE() - 90"
Or, if you can modify your SQL SELECT statement
SELECT col1, col2, col3 FROM tablename WHERE col3 < GETDATE() -90
However when I added it I get this error:Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately. Parser Error Message: Type 'System.Web.UI.WebControls.BoundField' does not have a public property named 'FilterExpression'.I think I have added the code to the wrong place or have another file to edit but I have no clue honestly. The best I can do is show you the file I have the code to in hopes someone may know what this is. Here is the code from the file I added the solution to (my edit is bold/italics/underlined towards the bottom): And shouldn't I have some select statements somewhere like I normally do with MySQL?
<%@ Page Language="C#" MasterPageFile="~/SecureRck.master" AutoEventWireup="true"
Codebehind="Default.aspx.cs" Inherits="SecureRckWeb.Reps.Default" Title="Reps" %>
<%@ Register Assembly="schedule2" Namespace="rw" TagPrefix="cc1" %>
[code]...
View 9 Replies
Similar Messages:
Feb 14, 2011
the select statement for my gridview contains a sub select statement..that should allow users to see how many queries are associated with a particular record..how can I get the queries column to display in my grid. As it is a count and not directly bound to any field
SELECT
WardID,
ScriptID,
DateAdded,
(SELECT COUNT(scriptID) FROM query WHERE scriptID = main.scriptID) AS queries.......
View 2 Replies
Feb 8, 2010
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
View 4 Replies
Mar 1, 2011
im creating advance search for my project and end up with the problem of select statement format for 2category.
here is example:
i have advancesearch that has checkbox wherein you can select multiple checkbox. example is selecting category, for example ihave 5 category as shown below.
Category
News Sports Opinion Editorial Literary i did tried someformats for my select statements to make it work for 2 or more category, but i just cant get the right format of the select statement.
example if i select the following.
if selected is category 'Sports'
it wil work with this: " 'Select * MyTable1 where [Category Title]='Sports' "
if selected are category 'Sports' and 'News'. what must be the format for my selectstatement for 2 or more category in the same fieldname? should it work with this?
" 'Select * MyTable1 where [Category Title]='Sports','News'" no, how could i make it work. what must be the right format?
View 2 Replies
May 7, 2010
I'd like to print out the select statement for a SqlDataSource to see exactly what is being issued to the database. I added an OnSelecting event and the code shown below. The problem is that it's printing the variables in the select statement rather than the values assigned to those variables. How do I print out the "resolved" output so that I can see the values being passed to the database.
[code].....
View 2 Replies
Jun 15, 2010
The code below returns a dataset that I use in a Gridview. How can I modify my select statement to format the DateEntered as a Date in gridview with no time and TimeEntered as Time in gridview without date info?
[Code]....
View 3 Replies
Mar 3, 2011
I have a formview, selecting * from friends, where [date] = getdate()
The problem is the friends table date columns datatype is datetime, i cannot make it just date.
I only want to display data if the date is the actual date, i.e. between 00:00:01 and 23:59:59
How do i select only the date for both getdate and my date column?
SelectCommand="SELECT * FROM [friends] WHERE ([date] = getDate())">
View 2 Replies
Nov 5, 2010
Edit and Delete functionality works flawlessly in Gridview if all data is pulled ONLY FROM ONE TABLE. But pulling data from one table give you ID's instead of actual values that are stored in other tables.
After creating a usable Select statement that would pull all the correct values, my Edit and Delete functionality no longer work.
Here is code.
[Code]....
View 2 Replies
May 29, 2010
i'm trying to to create a simple string array with data retrieved from a select statement(SELECT firstname FROM customers , for ex.)
View 6 Replies
Jun 16, 2010
I want use select * from sample (tablename) ,which returns only those columns from sample table which does not have xml data type.
note : sample table contains some columns which have xml data type .
View 6 Replies
Mar 17, 2010
I get and error when I run a sub select statement. What is wrong with the statement?
[Code]....
[Code]....
ERROR:
System.Data.SqlClient.SqlException: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
View 3 Replies
Jan 25, 2011
I have gridview. some columns are data, and some are link buttons. now, I need move these link buttons to a hovermenu. this is done. but I got a javascript exception, and it is because if there is no row was selected in gridview, it will pop this.
so, the question is: how can I select a row in gridview without select command? simply by code?
View 3 Replies
Oct 24, 2010
I'm using asp.net and c# language.
How can i display a GridView using select statement of two column in one table?
This is my coding:
if (sdr.Read())
{
if(namaPembekal.Equals(sdr["namaPembekal"]) && tarikhRo.Equals(sdr["tarikhRo"]))
{
Session.Add("namaPembekal",sdr["namaPembekal"]);
Session.Add("tarikhRo", sdr["tarikhRo"]);
if((((String)(Session["namaPembekal"])).Equals("namaPembekal")) && ((String
(Session["tarikhRo"])).Equals("tarikhRo"))
GridView1.DataSourceID = SqlDataSource2.ID;
GridView1.DataSourceID = txtJourneyDate.Text;
}
View 1 Replies
Dec 8, 2010
My sql statement is not functioning correctly. The gridview does post the items correctly but the results are not correct. Can someone assist me with the sql statement where I'm going wrong with it?
I only have one being reffer to the code because I was testing to see it work. Eventually, the search will be base on multi select and the selected items are going to the stored procedure to search for the proper records.
The following is the site code and sql code. -carlos
Site behind code:
[Code]....
[Code]....
View 7 Replies
Apr 29, 2010
I'm quite new to asp.net. I use MS Visual Studio 2008 and MySQL database. When I try to edit a record via gridview and the generated UPDATE syntax I get an error.I inserted a gridview into my asp.net web application and connected it to my database (all is OK). Then I checked for auto generation of update and other syntax:
[Code]....
When I test in a browser I get a pop window form for editing a record. But when I click "update" I get the following error:"You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '?, strSkrajsanNaziv = ?, strKraj = ?, strDavcnaSt = ?, SkupinaID = ? WHERE Stran' at line 1"what's wrong with the UPDATE syntax? Is this syntax only valid when using MSSQL?
View 6 Replies
Nov 18, 2010
I have a conditional Eval statement in a Gridview that returns a boolean result to display an image if two datafields(strings) are identical:
Visible='<%# Eval("customerA").Equals(Eval("customerB")) %>'
Works great except I don't want the image to display if both datafields are empty. How can I add that logic into this Eval stmt?
View 3 Replies
Mar 21, 2010
On Page1 of a project, I have a Gridview showing a table of customer names (showing CustID, CustName, CustJoinDate). When I click on a record, I have passed a querystring to Page2 showing an address table for that customer. This part works for me.
The SQL statement in simply: Select * from CustAddress where CustID = @cust
What I would like to do though, is capture that @cust to a session variable so that I can use it later on.
View 2 Replies
Feb 9, 2010
I have a gridview that I am manually binding in my code behind page because I have to pull out information from other sources for the WHERE clause.The issue is that I get an error on the aspx page that one of the columns is not in the dataview, however when I run the SQL statement in SQL all the columns are there and there is not a spelling error.If I remove the column from the gridview then the page loads.I cannot see why the column is a problem.Here is my ASPX gridview code.
[Code...]
This is the line where the error occurs. <asp:Label ID="Label2" runat="server" Text='<%# Bind("date_submitted") %>'></asp:Label> Here is the code behind
[Code...]
Here is the ending SQL statement that works in SQL and does return the date_submitted column. SELECT id, title, date_submitted, (SELECT username FROM users WHERE (id = t.submitted_by_user_id)) AS submitted_by, (SELECT name FROM departments WHERE (id = t.department_id)) AS department FROM tickets AS t WHERE (closed_by_user_id IS NULL) AND (department_id = 48 OR t.department_id = 83) ORDER BY t.date_submitted DESC
View 2 Replies
Mar 11, 2010
I'm attempting to bind multiple datasources to a single Gridview. Can someone direct me on how to change the below <%# Bind("") %> programatically in the code behind. For example, change "HRID" to "PayrollID" to account for a different column. the dataSource binds to the Gridview so the Rows will not be created yet.
I know how to accomplish this with a boundField, but I'm having issues with setting the text of the label in the ItemTemplate.
<asp:TemplateField HeaderText="ID">
<ItemTemplate>
<asp:Label ID="lblHR" runat="server" Text='<%# Bind("HRID") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:Label ID="lblNewID" runat="server" Text=""></asp:Label>
</EditItemTemplate>
</asp:TemplateField>
View 4 Replies
Mar 22, 2011
I need to loop through a GridView and get the values of a databound field. Then use those values in my update statement.
Here is the GridView:
[Code]....
And here is my UPDATE statement, which is actually just passing the values to a stored procedure:
[Code]....
Right now, I just have it grabbing the text from a label control, but I know that will not work as it only passes one value. I need to be able to update multiple rows based on the del_doc_num.
View 15 Replies
May 10, 2010
I have a select statement where I want to get some data. The problem is that I am not geting the right answer. This is what I am trying to do:
SELECT * FROM se_cs_test WHERE
Status = 1
OR Status = 2
AND NumberOfContacts = 1[code]...
View 2 Replies
Feb 19, 2011
One of my table columns is for date and I understand how to use the ORDER BY statement in general. But how would I have the gridview sort with only the future items (relative to the current date) apear and leave out the past entries?
View 10 Replies
Mar 17, 2010
If I run the following SQL script:
[Code]....
View 3 Replies
Apr 24, 2010
I want the select statement for the above scenario.
View 2 Replies
Apr 30, 2010
How would you handle an INSERT that gets some values from another table using SELECT, where you wanted some values to come from the source table record and other values to come from a different parameter source like a session value? Is this possible?
View 3 Replies
