DataSource Controls :: Pass QueryString In SelectCommand From Code Front?
Jan 7, 2011
I have a question related to <asp:SqlDataSource's SelectCommand. How to pass a querystring like <%# Eval("PhotoID") %> in the selectCommand. The whole frontend code is attached. I put
<%# Eval("PhotoID") %> and the photoid gets printed in the page.
<%# Eval("PhotoID") %> is the current displayed picture's PhotoID.
I want to pass this PhotoID or I want to pass <%# Eval("PhotoID") %> to the select command dynamically. I have tried the following approaches:
1) <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnetdb %>" SelectCommand="SELECT UserName, commentDesc, uID FROM photo_comment_view Where pID = @pID"> <SelectParameters><asp:Parameter Name="pID" DefaultValue="7" /></SelectParameters> </asp:SqlDataSource> The above works but it gives only information about PhotoID 7, but there are other photos; How to set pID's value to <%# Eval("PhotoID") %> in ASP .NET's frontend page? then I also tried,
2) <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:aspnetdb %>" SelectCommand="SELECT UserName, commentDesc, uID FROM photo_comment_view Where pID = <%#'Eval("PhotoID') %>"></asp:SqlDataSource> Gives Parser error: Parser Error Message: The server tag is not well formed.
What I should do so that I can pass current PhotoID to SelectCommand? The frontend code:
<%@ Page Language="VB" MasterPageFile="~/Default.master" Title="Your Name Here | Picture Details"
CodeFile="Details.aspx.vb" Inherits="Details_aspx" %>
<asp:content id="Content1" contentplaceholderid="Main" runat="server">
<asp:ScriptManager ID="ScriptManager1" runat="server">
</asp:ScriptManager>
<div class="shim solid"></div>
<div class="page" id="details">
<%--Update Panel Here--%>
<asp:UpdatePanel runat="server" ID="updatepanel">
<ContentTemplate>
<asp:formview id="FormView1" runat="server" datasourceid="ObjectDataSource1" cssclass="view"
borderstyle="none" borderwidth="0" CellPadding="0" cellspacing="0" EnableViewState="false" AllowPaging="true">
<itemtemplate>
<div class="buttonbar buttonbar-top">
<a href="Albums.aspx"><asp:image ID="Image1" runat="Server" skinid="gallery" /></a>
<asp:ImageButton ID="ImageButton9" Runat="server" CommandName="Page" CommandArgument="First" skinid="first"/>
<asp:ImageButton ID="ImageButton10" Runat="server" CommandName="Page" CommandArgument="Prev" skinid="prev"/>
<asp:ImageButton ID="ImageButton11" Runat="server" CommandName="Page" CommandArgument="Next" skinid="next"/>.................
View 14 Replies
Similar Messages:
Jul 8, 2010
I'm making a page with a DropDownList (called ddlSupp) that contains several suppliers, and I populate it with an SqlDataSource, all in front code.
In another part of the page I make a CheckBoxList, and populate it again with an SqlDataSource. The select command of the SqlDataSource is a procedure call to my MySQL database. However, what the CheckBoxList gets populated with depends on who is selected in ddlSupp. How do I make a variable in front code that will take the value from ddlSupp and populate my checkbox accordingly?
Here is my code:
[Code]....
I get a MySQL error at (<%$ddlSupp.SelectedValue %>) so I know the wrong value is being passed into the query. How can I fix this?
View 1 Replies
Dec 1, 2010
how to query the system date in selectcommand in gridview without using the codebehind. using c# .net
my code:
<asp:SqlDataSource ID="SqlDataSource1" runat="server" SelectCommand="SELECT * FROM tablename where date_today = <SYSTEMDATE>" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName
%>"
View 1 Replies
Feb 7, 2010
.cs code is
[Code]....
and .aspx code is
[Code]....
now i want to pass value in Reply.aspx?C={0} to stored procedure
View 3 Replies
Nov 16, 2010
This may be a simple question, but I'm trying to call a a value from table in my back-end SQL Server database and pass it through a querystring in the URL. For example:
I'm building a mobile web site that registers a mobile device to an account on the sign up page. After the database entry is created, I want the to get the generated deviceId from the database and pass it to a querystring in the URL such as: http://www.mobilewebsite.com?dId=22
Is this easily possible, or is it even the best solution for what I'm trying to accomplish?
View 1 Replies
Apr 8, 2010
I am trying to pass a variable "PIN2" that I am retrieving like below to a SelectCommand statement in a asp SqlDataSource tag
<%
Dim PIN As String = Request.ServerVariables("LOGON_USER")
Dim PIN2 As String = Right(PIN, 6)
%>
View 1 Replies
Mar 30, 2011
How to get sqldatasource1.selectCommand value
[Code]....
i want to set that if nothing return i will display a msg to users.
View 7 Replies
Sep 4, 2010
I have a gridview with a sqldatasource with SelectCommand as below:
[Code]....
but it's not workling.....
View 1 Replies
Oct 11, 2010
i have an SQLdatasource in my page
i was trying to modify it as:
SQL.SelectCommand = "Select * from " + TXT_Tabella.Text;
because i want update dinamically my sql server tables but ,every time i am going to sort, or change page the selectCommand returns as before!
viewState is true! how can i have an SQLdatasource dinamyc by tableName? and how this problem occurs?
View 3 Replies
Jul 7, 2010
I am trying to pass a variable within a selectcommand statment in ASP.NET and I have researched online how to do it but I can't seem to find a way to do it...What I am trying to do is write a code for a web page that will display a page with useful links on it where the links are separated into different topics and where everything is dynamically grabbed from a database. This is what I have so far:
<!-- Start MainContentRegion -->
<h1>Useful Links</h1>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
[]code...
View 4 Replies
Dec 21, 2010
My SelectCommand string in my asp:SqlDataSource is very long. Is there a way I can chop it up into different strings on several newlines to make it more readable?
View 4 Replies
Feb 19, 2011
My SqlDataSource has no selectCommand defined in the .aspx page. Instead I define it in the code behind dynamically depending on some parameters that the user selects and then clicks a button to perform the query (custom search filters basically). The problem is that when I click on a different page in my dataPager, or I click to sort any of the columns the gridview becomes empty when the page refreshes. I did a check and the selectCommand becomes empty when the page posts back. Is there a way to prevent this from happening?
View 2 Replies
Sep 28, 2010
I have a SqlDataSource setup in the markup on my page. After some new requirements, I am trying to find a way to modify the SelectCommand before the data is filled for the first time. The SelectCommand below will now be used by default since we'll always have the first param. I am faced with a need to modify the SelectCommand though, adding a second session parameter along with it. I tried to override the OnInit method but it didn't seem to help...it still used the default query. Is there a best way to accomplish this? Here is the section of markup I am referring to:
[code]....
View 2 Replies
Nov 17, 2010
In an asp.net 3.5 web app, I have a page with the following markup/code (this is the brief version, but I believe I got all the relevant info).
[Code]....
The form contains 2 different record types, accessed using the paging controls, depending on the ParentSR field; a parent SR will be something like '1234' while its sub-record will be something like '1234.1'. There are only a few differences in the fields used between the 2 different record types and that is why they are stored in the same table. However, the activity depends on the record type. When browsing from the parent record to the sub-record, the itemtemplate loads fine (notice in the formview's datasource
query, that the sractivity_id field is being pulled along with the subquery value). But when going to edit the record, the page throws an error:
System.Web.HttpUnhandledException: Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.ArgumentOutOfRangeException: 'ddlActivity' has a SelectedValue which is invalid because it does not exist in the list of items.
If i click 'back' and retry, it may take 3 attempts, but then the edittemplate will load just fine. I should also point out that this error does not always occur. I've been trying to figure this out for a couple months and it is driving me nuts, mainly due to the fact that I can't reproduce the error in development--it seems to only occurr in production. Anyone with any thoughts on what is going on?
View 1 Replies
Nov 7, 2010
I've got a gridview which works fine. I use dropdownlists which are filled with distinct values of the columns. So when I select an item in a drompdownlist the gridview refreshes based on the selected value. When I have a column which uses string values, I can start the filter with a default % value to use in my select paramaters. But when I have a date column, I can't use that. I use a datasource for the gridview and I prefer to leave codebehind out if this is not needed. Now I use >= in my gridview select to show all rows. but I want to use only = to make the filter work correct when I select a date in the ddl and use the selectedvalue in the gridview selectCommand
<asp:DropDownList ID="ddlUpdateDatum" DataSourceID="dsPopulateUpdateDatum"
AutoPostBack="true" DataValueField="UPDATEDATE" runat="server"
CssClass="selectinput" AppendDataBoundItems="true">
<asp:ListItem Text="All" Value="01/01/1900"></asp:ListItem>
</asp:DropDownList>
<asp:SqlDataSource ID="dsPopulateUpdateDatum" runat="server"
ConnectionString="<%$ ConnectionStrings:GAMSYSTEMSqlServer %>"
SelectCommand="SELECT DISTINCT(UPDATEDATE) FROM [messages] ORDER BY UPDATEDATE ASC ">
</asp:SqlDataSource>
And I use this in the gridview datasource:
<asp:SqlDataSource
runat="server"
ID="dsGridview"
ConnectionString="<%$ ConnectionStrings:DBSqlServer %>"
SelectCommand = "SELECT * FROM [messages] WHERE AND UpdateDatum >= @UpdateDatePar ORDER BY UpdateDatumDESC"
>
<SelectParameters>
<asp:ControlParameter Name="UpdateDatePar" ControlID="ddlUpdateDate" PropertyName="SelectedValue" Type="string" />
</SelectParameters>
View 2 Replies
Mar 11, 2010
I have a page has Listview and Datapager inside UpdatePanel. When I refresh the new SQL results and bind by pressing link buton outside of the update panel, I get correct results. (get new SQLselect statment, rebind to listview, update updatepanel)
However, the SelectCommand is not bound right or some other reason, if I press datapager, I won't get no results.
I'm guessing it's caused by not passing new dynamic selectcommand since my datapager and listview works first update.
View 4 Replies
Mar 19, 2010
I want to insert a particular value against a range of dates into my sql server database from the front end using c#.
the table has the column date and worker. so i desire that the user writes the name of the worker and then enters a From and To range into two textboxes so that thorugh a loop function the name of the worker gets written into the table along with the range of chosen dates.
View 18 Replies
Feb 1, 2010
here is my query which is not working properly. I have 5 fields in my table Company, Reseller, Item, Code, Price. How can i get minimum Price when i pass parameters for Code is dublication value
Company Reseller Item Code Price
A A-1 I1 C1 20
B A-21 I2 C2 13
C A-B I1 C1 19
select Company,Reseller,Item,Code,Min(Price) from Table1 where code='C1' order by Code HOW CAN I GET THIS BELOW TYPE OF RESULT
Company Reseller Item Code Price
A A-1 I1 C1 20
C A-B I1 C1 19
View 17 Replies
Mar 18, 2011
I am looking to pass a value into a query string. I am rendering a page right now called UserDetails.aspx?id=23 and in ASPX page I have a Gridview like this:
<asp:GridView ID="dgDetails" runat="server" AutoGenerateColumns="false">
<Columns>
<asp:BoundField DataField="txtName" SortExpression="txtName" HeaderText="User Name" />
<asp:TemplateField HeaderText="Permissions">
<ItemTemplate>
<a href="javascript:void(0);" onclick="javascript:pop('Perms.aspx?id=<%# DataBinder.Eval(Container.DataItem, "intUserAccount") %>&hu=<%# DataBinder.Eval(Container.DataItem, "intUserAccountWorkspace") %>', 600, 300);
return false;">Details</a>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
I want to take the "id=23" query string from the current page and pass it onto this link (in bold).
View 2 Replies
Jun 27, 2010
im creating a photo album just like facebook album featureThe problem im facing now is unable to add new picture to a particular albumBelow is the code to pass a querystring to the addphoto.aspx in a datalist, i bind the sqldatasource using vb in the codebehind
[Code]....
[Code]....
View 5 Replies
May 7, 2015
Object reference not set to an instance of an object.
Line 20: GridViewRow row = GVInvestigateReport.Rows[rowIndex];
View 1 Replies
May 7, 2015
i want to pass multiple arrays variable in query string.for example i have three checkbox list Brand ,Price, Attribute any arrays variable may have more than one value key arrays variable are fixed for checkboxlist
1-checkbox list Brand has Brand []arrays variable
2-checkbox list Price has Price []arrays variable
3-checkbox list Attribute has Attribute []arrays variable
now i have selecting two -two from every checkbox list .than i want to query string something like this
www.defualt.aspx?brand[]=samsung=123&apple=11,Price[]=100=12&200=2,Attribute []=camera=1&display=2
View 1 Replies
Oct 16, 2010
i have a page, when the page loads, nothing shows up, when i pass the querystring on the browser as [URL]
I want it to work when the page load not when i pass the querystring on the browser.
Here is the code:
[code]....
[Code]....
[Code]....
View 4 Replies
Jan 9, 2014
I have passed the value from one page to next page using a querystring. In the next page i need to get the value from the query string and based on the value, it needs to checked with the database and the result set should be placed in the gridview, details view or listview anything else.
Ex: Response.redirect("user.aspx?id="+userinput.text);
userdetails.aspx?id=vicky - url
table:
user mobileno email
vicky 9848752322 ervigsh@gmail.com
In the details view or list view control, I need to get the value vicky from the url and based on the value's row in the database table need to be binded in any of the mentioned above controls.
View 1 Replies
May 7, 2015
In one of the web page say "Default1.aspx" I have a Gridview.I am using 2 DataKeyNames in Gridview. i.e., DataKeyNames="G_Name, Param_ID" Also, I have one Hyperlink inside Gridview, upon clicking, page navigates to other page say "Default2.aspx"
code of "Default1" page:
<asp:GridView ID="GridView1" runat="server" DataKeyNames="G_Name, Param_ID" AutoGenerateColumns="False" Width="100%" PageSize="8" AllowPaging="True" OnPageIndexChanging="GridView1_PageIndexChanging">
<Columns>
<asp:BoundField HeaderText="Goal Name" DataField="G_Name" Visible="false"/>
[Code]....
code of "Default2" page:
protected void Page_Load(object sender, EventArgs e) {
if (!Page.IsPostBack) {
string name = Request.QueryString[0].ToString();
string id = Request.QueryString[1].ToString();
}
}
I want to pass multiple parameters in querystring. I wrote above code.
Problem is: I am unable to write the correct syntax for Hyperlink NavigationUrlTherefore, it is giving me below error:
DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'GF_Name, Param_ID'.
at Line:
<asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl='<%# Eval("GF_Name, Param_ID","~/Default2.aspx?Name={0}&Id={1}") %>'
Text='<%# Eval("GF_Name") %>'></asp:HyperLink>
how to resolve it.
View 1 Replies
