Web Forms :: QueryExtender Control - Variable Field Name To Search Against?
Sep 25, 2010
I have been alerted to the Query Extender control through previous posts, but I am still seeking the final part of my desired solution.
NB the following is written in conceptual English (programming specification) format, rather than actual asp code.
While I fully understand that I can use the QueryExtender control to pass a parameter from one web page to another, I do not see, and maybe this is not even possible, how I can pass a parameter of which field I want to select on.
Ideally I would like to be able to implement a query which is
SELECT tiles where 'Passed Variable Name' contains 'Passed Test Value'
such as would then generate, for example -
[code]....
I have only mentioned three in the concept above but there are actually about half a dozen different calling pages, and there could develop a few more over time.
View 1 Replies
Similar Messages:
Apr 19, 2010
how to Add Search Control for Detailsview for search page... simple solution required.?
and is it possible to give field names to each page numbering?
View 3 Replies
Jan 17, 2011
Is it possible to substitute submit button which triggers QueryExtender filtering by a code?
how would you do it?
View 5 Replies
May 12, 2010
I am trying to dynamically add a queryextender expression to the page. something like, when the user clicks a button, we need to add a OrderbyExpression. The following is the code used. It works when added in Page_Load but doesn't when added on a button click event. Upon button click the page just reloads and ignores the filter condition.
OrderByExpression obex = new OrderByExpression();
obex.DataField = "ProductName";
obex.Direction = SortDirection.Descending;
ThenBy tb = new ThenBy();
tb.DataField = "UnitsInStock";
tb.Direction = SortDirection.Ascending;
obex.ThenByExpressions.Add(tb);
this.q.Expressions.Add(obex);
where queryextender1 is the ID of the queryextender
View 3 Replies
Jan 8, 2010
What is the proper way to use a variable in the email "To" field. I am calling a list of 5 emails from the database table and want to insert into the To address of the email.
If I use the following: message.To.Add(New MailAddress(mEmail)) I get "The specified string is not in the form required for an e-mail address." Although the string of mEmail equals[URL]
see below for complete vb code:
[code]....
View 1 Replies
Apr 16, 2010
populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
View 8 Replies
May 13, 2010
I have the following code in the .aspx page:
<asp:TemplateField
HeaderText="Summary"
SortExpression="INTERPRETATION_SUMMARY"><ItemTemplate>
<asp:Label
ID="lblSummaryView"
runat="server"
Text='<%# HighlightText(Eval("INTERPRETATION_SUMMARY")) %>'></asp:Label
[Code]....
View 5 Replies
Mar 19, 2010
I'm about to create a masterpage that contains a search field, the result from the search should be placed inside a contentplaceholder, but how do I build that? I added the search form to the masterpage (not inside a contentplaceholder), and then I added the eventhandler for the button that trigger the search. Now lest say I want to display the result in the contentplaceholder, how would I do that?
View 4 Replies
Aug 21, 2010
How to take value of bound field of grid in a variable or in a textbox.
I m using this code in .aspx page for grid.
[code]....
Now how to take value of cell of grid in textbox or in any varaible on cell click.remember if I take the field as BoundField on aspx.
View 4 Replies
Mar 14, 2011
I would like to use QueryExtender control to retrieve records in a given date range.
<asp:QueryExtender ID="qeFilter" runat="server" TargetControlID="EntityDataSource1">
<asp:RangeExpression DataField="Date" MaxType="Inclusive" MinType="Inclusive">
<asp:ControlParameter ControlID="txtFrom" />
<asp:ControlParameter ControlID="txtTo" />
</asp:RangeExpression>
</asp:QueryExtender>
The problem is that date in text boxes is in "d.M.yyyy" format. I am unable to figure out how to specify the format for the asp:ControlParameter.
View 1 Replies
Oct 20, 2010
Nested GridView Control returns "Object variable or With block variable not set" when outer GridView returns rows.
The Nested GridView Control works as long as the outer GridView returns rows, the following code works: [Code]....
Object variable or With block variable not set.
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.NullReferenceException: Object variable or With block variable not set.
Source Error:
Line 118: If e.Row.RowType = DataControlRowType.DataRow Then
Line 119: Dim myStatus_ID As SqlDataSource = CType(e.Row.FindControl("sqlDeviceStatusAssign"), SqlDataSource)
Line 120: If Not e.Row.DataItem("Status_ID") Is Nothing Then
Line 121: myStatus_ID.SelectParameters(0).DefaultValue = e.Row.DataItem("Status_ID")
Line 122: End If
I have tried checking for IsDbNull and checking to see if a label exists in a given row. This code *If Not e.Row.DataItem("Status_ID") Is Nothing Then* appears to do nothing.Same with the following:
*Dim localLblItemReference As Label = CType(e.Row.FindControl("lblItemReference"), Label)
*If Not localLblItemReference Is Nothing Then
******************************************************************************************
To further clarify my question above, I am looking for a method to detect e.Row.DataItem("Status_ID") is nothing/null due to the outer GridView returning 0 results in a query.I have a (Outer) GridView Control with another GridView Control inside of a template field with it's associated SqlDataSource control.
In the "Protected Sub GridViewReport_RowCreated", I provide the Select Parameter for the associated SqlDataSource with the DataItem row value.When the (Outer) GridView Control does not return any rows, the "e.Row.DataItem("Status_ID")" throws a:
Exception Details: System.NullReferenceException: Object variable or With block variable not set.
View 3 Replies
Dec 24, 2010
I have a webform developed in VB.NET and I am facing a strange problem. In the webform I have a GridView control which has two bound fields (Item # and Item name) coming from a master table and infront of these two fields I have placed a TEXTBOX control as TEMPLATE FIELD to take any value of particular item. But after filling all the textboxes when i clicked on submit button it loops thru the items and there i need to read the textbox value of that particular item in a variable but unfortunately the value is blank even the data is there. Here is the ASPX code.
[Code]....
Here is the Code behind
[Code]....
View 4 Replies
Oct 27, 2010
I have heard alot about sql injection and how it is normally caused. Mostly sql injection in my opinion is caused through search boxes. Now my question is quite simple. Is it advisable to store the search keyword in a session variable to prevent sql injection? I don't want to expose the keyword through the querystring as it is prone to attacks. So in short there is no harm in using session variables to store the keyword right?
View 6 Replies
Feb 24, 2011
If I wanted to search a variable for the wrod "alert", what would be the syntax in javascript
View 2 Replies
Feb 10, 2011
I have a web page with 3 search fields on it, each with a different submit button. When using the enter button on the keyboard to submit any of them, an incorrect action is being performed, although with the mouse it's fine. Any ideas why this is happening? The rendered HTML as requested below:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="ctl00_ctl00_Head1">
<body id="home">
<form name="aspnetForm" method="post" action="history_lookup.aspx?theme=t2" id="aspnetForm">
<div>
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTE1MzkzOTQxNDBkGAEFHl9fQ29udHJvbHNSZXF1aXJlUG9zdEJhY2tLZXlfXxYFBSZjdGwwMCRjdGwwMCRNaW5pQ2FydFRleHQxJEltYWdlQnV0dG9uMQUsY3RsMDAkY3RsMDAkVG9wTmF2JFF1aWNrU2VhcmNoMSRJbWFnZUJ1dHRvbjIFLGN0bDAwJGN0bDAwJFRvcE5hdiRRdWlja1NlYXJjaDEkSW1hZ2VCdXR0b24xBShjdGwwMCRjdGwwMCRjcGhSb290JGNwaFN1Yk1hc3RlciRzdWJtaXQxBShjdGwwMCRjdGwwMCRjcGhSb290JGNwaFN1Yk1hc3RlciRzdWJtaXQy4UTdoX+Ej1GFsXGOrI898SMftDA=" />
</div>
<script type="text/javascript">
//<![CDATA[
var theForm = document.forms['aspnetForm'];
if (!theForm) {
theForm = document.aspnetForm;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
//]]>
</script>
<script src="/WebResource.axd?d=gfGwAOwAxcQ9Nlq6l3EJfg2&t=634166396192656250" type="text/javascript"></script>
<div>
<input type="hidden" name="__PREVIOUSPAGE" id="__PREVIOUSPAGE" value="fwZ-2v_x8CYGGr9a8Ce0s6gkE38QmubHNljKJaKxZV41" />
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWCAKs3Nu8DwLV2a2zBwKK/6PwCQLBpvyBBAKT+aizBgL+qMTTDwLU1/SWCwL+qNiuCArtGFkuC9Zj3X3If1cwPC7PKtcm" />
</div>
<div class="container clearfix" style="left: 0px; top: 0px">
<div class="utilityNav">
<a class="MenuItem" href="/extranet.aspx?theme=t2" title="Account Info">
Account Info
</a>
|
<a class="MenuItem" href="/history_lookup.aspx?theme=t2" title="Order History">
Order History
</a>
|
<a class="MenuItem" href="/_user_logout.aspx" title="Sign Off">
Sign Off
</a>
</div>
<div class="header">
<div class="cart" >
<div id="menu">
<div class="cartimage">
<input type="image" name="ctl00$ctl00$MiniCartText1$ImageButton1" id="ctl00_ctl00_MiniCartText1_ImageButton1" src="images/bg-cart-corner.gif" align="left" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$ctl00$MiniCartText1$ImageButton1", "", false, "", "cart.aspx", false, false))" style="border-width:0px;" />
</div>
<div class="cartlabel">Checkout Cart:<br />
<a id="ctl00_ctl00_MiniCartText1_lbMiniCart2" class="cartlink" href="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$ctl00$MiniCartText1$lbMiniCart2", "", false, "", "cart.aspx?theme=t2", false, true))">View your cart</a>
</div>
<br /><br />
</div>
</div>
</div>
<div class="primaryNav">
<div class="navdropdown">
</div>
<div align="right" class="quicksearch">
<div class="QuickSearch">
<div id="ctl00_ctl00_TopNav_QuickSearch1_quicksearchpanel" onkeypress="javascript:return WebForm_FireDefaultButton(event, 'ctl00_ctl00_TopNav_QuickSearch1_ImageButton1')">
<table cellpadding="0" cellspacing="0" class="QuickSearch">
<tr>
<td class="quicksearch_text">
<span id="ctl00_ctl00_TopNav_QuickSearch1_lblSearch"></span>
</td>
<td >
<input class="QuickSearch" type="text" name="searchstring" size="15" maxlength="30" value="Search" onfocus="if (this.value == 'Search') {this.value = '';}" onblur="if (this.value == '') {this.value = 'Search';}" />
</td>
<td class="quicksearch_button">
<input type="image" name="ctl00$ctl00$TopNav$QuickSearch1$ImageButton2" id="ctl00_ctl00_TopNav_QuickSearch1_ImageButton2" src="images/searchbutton.gif" onclick="javascript:WebForm_DoPostBackWithOptions(new WebForm_PostBackOptions("ctl00$ctl00$TopNav$QuickSearch1$ImageButton2", "", false, "", "/Searchdh.aspx?theme=t2", false, false))" style="border-width:0px;" />
</td>
</tr>
</table>
</div>
</div>
</div>
</div>
<td valign="top">
<div class="HistoryLookupPage">
<h1 class="PageHeader">
<span id="ctl00_ctl00_cphRoot_cphSubMaster_PageHeader1_LabelHeader">Order History</span>
</h1>
<p>
Enter the reference number of the order you want to see.
</p>
<p>
Reference number
<input name="ctl00$ctl00$cphRoot$cphSubMaster$CustomerReference" type="text" id="ctl00_ctl00_cphRoot_cphSubMaster_CustomerReference" class="borderTextBox" />
<input type="image" name="ctl00$ctl00$cphRoot$cphSubMaster$submit1" id="ctl00_ctl00_cphRoot_cphSubMaster_submit1" src="images/buttons/findorder-blue.gif" style="border-width:0px;" />
</p>
<br />
<p><b>Or search by PO Number</b></p>
<p>
<input name="ctl00$ctl00$cphRoot$cphSubMaster$CustomerReference2" type="text" id="ctl00_ctl00_cphRoot_cphSubMaster_CustomerReference2" class="borderTextBox" />
<input type="image" name="ctl00$ctl00$cphRoot$cphSubMaster$submit2" id="ctl00_ctl00_cphRoot_cphSubMaster_submit2" src="images/buttons/findorder-blue.gif" style="border-width:0px;" />
</p>
</div>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
and the aspx markup
<%@ Import Namespace="System.Configuration.ConfigurationManager" %>
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="history_lookup.aspx.vb"
EnableViewState="false" Inherits="history_lookup" ValidateRequest="false" CodeFileBaseClass="Main.Page"
MasterPageFile="~/masters/default/main.master" RuntimeMasterPageFile="ThreeColumn.master"
CrumbName="<%$ Resources: Language, LABEL_MENU_HISTORY %>" %>
<%@ Register Src="~/controls/Message.ascx" TagName="Message" TagPrefix="uc1" %>
<%@ Register Src="~/controls/PageHeader.ascx" TagName="PageHeader" TagPrefix="uc1" %>
<asp:Content ID="Content1" ContentPlaceHolderID="cphSubMaster" runat="Server">
<td valign="top">
<div class="HistoryLookupPage">
<uc1:Message ID="Message1" runat="server" />
<uc1:PageHeader ID="PageHeader1" runat="server" Text="<%$ Resources: Language, LABEL_MENU_HISTORY %>"
EnableTheming="true" />
<p>
<asp:Literal ID="Literal1" runat="server" Text="<%$ Resources: Language, LABEL_PLEASE_ENTER_ORDERREF %>"></asp:Literal>
</p>
<p>
<asp:Literal ID="Literal2" runat="server" Text="<%$ Resources: Language, LABEL_HISTORY_LOOKUP %>"></asp:Literal>
<asp:TextBox runat="server" ID="CustomerReference" CssClass="borderTextBox" />
<%-- <asp:Button ID="Button1" runat="server" CssClass="BtnC" Text="<%$ Resources: Language, ACTION_LOOKUP %>" />
--%> <asp:ImageButton ID="submit1" runat="server" imageurl="~/images/buttons/findorder-blue.gif" />
</p>
<% if Not globals.User("Anonymous") then %>
<br />
<p><b>Or search by PO Number</b></p>
<p>
<asp:TextBox runat="server" ID="CustomerReference2" CssClass="borderTextBox" />
<%-- <asp:Button ID="Button2" runat="server" CssClass="BtnC" Text="Find Order" />
--%> <asp:ImageButton ID="submit2" runat="server" imageurl="~/images/buttons/findorder-blue.gif" />
</p>
<% end if %>
</div>
</td>
</tr>
</table>
</asp:Content>
View 1 Replies
Jan 6, 2011
I want to add a search field and have search results display in a user-friendly format on an employee intranet. Does anyone know what component(s) I can drag over from the toolbox to create these two items?
View 4 Replies
Mar 7, 2011
I have a textfield () in my homepage for a searchstring. Normaly I have a text like "enter here to searach..." in it. Now I will clear the box from the text when a user click into it.
View 4 Replies
Feb 12, 2010
suppose i have few fileds in table and one filed is xml type. how to search this.
the xml which is stored in my xml filed like
<OpenShipments xmlns="x-schema:C:UPSLabelOpenShipments.xdr">
<OpenShipment ShipmentOption="RS" ProcessStatus="">
<ShipTo>
[code]...
we can query sql server data very easily but i dont know how to query the xml data which stored in xml filed.how to query address field in my xml or how to query Options field,how query CompanyOrName.
please help me to construct the sql. guide me in detail with few sample for querying xml datatype.
View 1 Replies
Jun 8, 2010
I have an application that goes through a series of questions and I have a view that shows each question based on the ViewData.
I would like to store the QuestionID (the view uses this to determine which question to show), but I'm curious if I should be storing the CurrentQuestionID in the Session or as a hidden field?
I am sure this is pretty common and I was curious what the conventions/best practices were for this sort of thing.
View 2 Replies
Nov 30, 2010
Trying to figure out how to handle data returned for a site search from a description field. I don't think I want to display all the text from the description field, but I also don't want to "chop" a word in half. How do I get the first 100 characters, plus a few extra letters if needed to prevent a word from being chopped in half. In some cases, the description field is less than 100 characters, so all the text will be displayed. However, if the description does need to be chopped at 100, I'd like to finish the word and add ... to indicate that there is more text.
View 6 Replies
Sep 8, 2010
I have a gridview with two textboxes (first name & last name) and a linkbutton to search results inside the gridview.
I have made select parameters as well and the search works if i write in both textboxes. However, if I leave one textbox blank, i don't get any results.
[code]...
How can I get results from searching only one textbox?
View 4 Replies
Dec 20, 2010
I'm building dropdown search box for a field in a database table. How can I code search all in web form and Stored procedure?
View 4 Replies
Apr 21, 2010
I want to add my own session variable to elmah error log table and display it. I already have modified the source code and added the new fields to Error.cs and other fields but I don't know but when I assign an HttpContext.Current.Session["MyVar"].tostring() value to my field in the constructor it stops logging exceptions and does not log any exception. I just need to get the value of the session variable is there other way for this ? I read a post which he added fields for the email but it does not say where exactly should I get the session value. I also read that Session and Cookies ar e logged by default by Elmah but I dont know how to access them.
View 2 Replies
Aug 19, 2010
What's the best method to allow a user to search in a specific field for a record(s) containing the keywords they enter into a textbox? I am considering using the streamreader to obatin the values from textbox into an array, so I can build dynamic query using the stringbuilder. Is there a cleaner or more efficient method to approach this common search functionality?
View 1 Replies
Aug 21, 2010
I have grid view control that includes a dropdown control in a template field.I wish to execute some code when the value is changed in the dropdown list. Can't figure out how to capture this event though?
View 5 Replies