I have a gridview set up with a button that when clicked I want it to send a unique value to a listview which is set to receive the value in a parameterized SQL query. I forgot how to set the button up in the GUI to take the unique value and put it in a query string and send it to url. I would like to use the GUI just to get more familiar with it. I know this is easy but I gortgot how.
View 5 Replies
I'm working on a job seeking website where the job seeker can search for a job , the search box is located in the master page, that's why i passed the keywords as a query string, and then the matching jobs will be displayed in a listview.
the keywords will be taken from two controls: a drop down list which the user can choose the location of the job, and a text box where he can type a keyword.
the select command of the sqlDataSource of the data list is as the following:
[code]....
How do I do this? I want to search my database in listview form with the text from a textbox or an item from a drop down list which is on another page.
View 1 Repliesi put this in a grid so that only one of the rows would have the txt box in it, it works ok ie the txtbox only shows up for the row with 1005 as the ID, but for some reason the query string for each row for the last element in the row, ie an AddToCart image button i have at the end of each row in the grid is not coming out right, ie the query string is missing when the page posts back for all but the last row of the grid which coincidently is the row with the 1005 ID, (the rendered code is shown way down, i apologize for the length of it ) here is the problem line. NOTE when i take the code out of the gridview on row data bound event then the page post back fine and the query string is there, but when i put the code back in the row databound event for the grid then the query string vars and values do not get posted back.
[code]....
i'm writing a button which need to open a new window and sending binded data as query string:
[Code]....
here is the open_win function:
[Code]....
But the url created is ".../Report.aspx?type=comment&id=undefined", the queryString["id"] is not defined.
In the calling page source html, comment_id has value.
[Code]....
How can i set the variable value of "comment_id" in button onclick, to call the javascript open_win() function ? the comment_id cannot known util runtime, it get value from datasource.
I am trying to populate the ListView using LinqDataSource data source but the issue I am having is.I need to load the listview on Search button click action.
IN the page_load I kept like this:
===========================================
LinqDS.Selecting += new EventHandler<LinqDataSourceSelectEventArgs>(LinqDS_Selecting);
protected void LinqDS_Selecting(object sender, LinqDataSourceSelectEventArgs e)
{
e.Result = ObjectDS;
}
=============================================
This works fine but this happens on page load,i want this binding to happen on button click?is there a way to do this?
I have a user control, named productslist.ascx. On pruductslist.ascx, I am using Entity Datasource and a QUERY EXTENDER and LISTview. I have a page Defualt.aspx. On Defualt.aspx, I have a TEXTBOX with a SUBMIT button for searching the site. Everthing works fine so far, AS LONG as the results of the Search is posted back to Default.aspx. What I want is for the results of the search to be posted on a different page.
So I created a new page, Results.aspx and set the postback url to it.
What I want is that when a user clicks the Submit button, after entering a search string, the text the entered is used to execute the query on Productslist.ascx and the results displayed on RESULTS.ASPX. Again, everything works fine as long as the results are posted on same page hosting the usercontrol, BUT I want the postback url to be a different page. I am coding in VB and VS 2010.
I have a search box on a web application that is to use a query I have built in Access to search through projects to find any that are related to the text entered in the search box.
The query in Access is just made up of parameters that use wildcards to search through all the fields. In Access the query works fine and returns the correct data but when I try and link this all up to a ListView in Visual Studio, the ListView just diplays the message "No data was returned"
Below is my page-behind code, hopefully you can see why it is not working but it looks like it should work to me.
[Code]....
Question basically crams it all in... I'm loading a page with a querystring (ID), and I need to use that ID to set the selected item of a ListView when the page loads. The ID is a DataKey on the ListView. I have no code of value to post--none of my attempts at this work.
View 2 Repliesi use this query as my sql query :
SELECT TOP 5 * FROM MyTableName WHERE ID=@ID ORDER BY NEWID()
As you may know it gets 5 records by random. I use it with dataset and bind the listview to this dataset and in ItemDataBound i want to do some programming (like making some controls visible or invisible) i need itemindex.
but the question is : how can i get the itemindex of a listview when sql query selects records randomly?
I am using a nested listview to display a seperate grid for each group of data returned from my db query. To get this working, I have adapted a piece of code to group the data prior to it being bound:
[Code]....
I am then using the following html markup:
[Code]....
[Code]....
This works as I want it to however some of the fields within the nested table need to be formatted as currency so I am trying to use Eval and {0:c} to do this however the moment I use Eval, the data items cannot be found
DataBinding: 'System.Data.DataRow' does not contain a property with the name '0'.
How can I get the value of a hidden field as the value of a query string parameter?
[Code]....
I have a ListView control that pulls a phone number from a db table. I'd like to format the phone number in the presentation layer to look like (###) ###-####.
The code line currently looks like this. The page displays the phone# but unformatted, i.e. 9999999999.
[Code]....
Based on other posts I've looked at in this forum, I've also tried:
<li>Phone: <%# String.Format("{0:(###) ###-####}", Databinder.Eval (Container.DataItem("Phone"))) %> with no success. In fact, this particular line throws an exception in my application (Input string not in the correct format).
The datatype I'm using in SQL is varchar(15)
The MSDN documentation for the String.Format method hasn't been very helpful thus far.
I have a ListView which pulls data from a products table.
In addition to things like ProductName, ProductDescription, etc., I've added two things to the ItemTemplate: a TextBox in which the user may enter a number and a ButtonControl.
When the user clicks the button I need to take the "default" fields plus the value in the TextBox and insert them into a second database table.
1) How to reference the value in the TextBox and,
2) I can't find a Click Event for the button. How do I get the button to work at all.
I'm okay with the C# to input the data to the table but without even a Click Event?
I have a data grid with a lot of information on it - to easily filter the data, I would like to be able to pass parameters to it. My problem is that I do not want the parameters to be required. So if I just put 1 or 2 of them in the query string, I would like for it to return all of the data related to those two parameters.I am using a data grid & stored procedures:My Stored Procedure looks like this:
[Code]...
i have a listview (inside an update panel) in a user control with two columns in each row. the list view is bound to a datatable via a stored procedure. i use the control on a web page and on the click of a button (which is not inside the listview, but in the user control) i want to add a new row at the end of the listview which should add a row with two empty text boxes (one for each column) at the end of the listview.
i am currently able to achieve that, but only on clicking the Add button TWICE.
here's my html code for the listview in the user control
[Code]....
and this is the c# code behind
[Code]....
I have the following ItemTemplate in Repeater1
[code]....
How do I insert the value of ListID into the query string?
I need to know how can I select a gridview row based on a query string data. In my case, the query string will contain the id that exist in the Table related to that grid. Is there a way to do this from the code behind? In other words, if I click a link with that specific query string, can I open the page and tell my grid to select a specific row based on the table row id?
View 1 RepliesI'm having troubles passing a parameter to a handler in it's query string. I have a gridview with an image column, this column is defined as a TemplateField, as:
<asp:TemplateField
HeaderText="Image">
<ItemTemplate>
<asp:Image
ID="Image1"
runat="server" ImageUrl='~/ImageHandler.ashx?ID=<%# Eval("EmployeeID")%>'
/>
</ItemTemplate>
</asp:TemplateField>
As you can see, the ImageUrl is a call to a handler that receives the EmployeeID in the QueryString, under the name ID. When I run it, the ImageHandler method receives the following query string "ID=<%" instead of "ID=<the result of Eval("EmployeeID")>", and of course, it throws a FormatException when using it as an int to get the EmployeeID. (If I type ImageUrl="~/ImageHandler.ashx?ID=<%# Eval("EmployeeID")%>" (using " instead of ') the compiler returns the error incorrect server tag) The complete markup is:
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [EmployeeID], [LastName], [FirstName], [Photo] FROM [Employees]">
</asp:SqlDataSource>
<asp:GridView
ID="GridView1"
runat="server" DataSourceID="SqlDataSource1"
AutoGenerateColumns="False">
<Columns>
<asp:BoundField
DataField="EmployeeID"
HeaderText="ID" SortExpression="EmployeeID"
/>
<asp:BoundField
DataField="FirstName"
HeaderText="FirstName"
SortExpression="FirstName"
/>
<asp:BoundField
DataField="LastName"
HeaderText="LastName" SortExpression="LastName"
/>
<asp:TemplateField
HeaderText="Image">
<ItemTemplate>
<asp:Image
ID="Image1"
runat="server" ImageUrl='~/ImageHandler.ashx?ID=<%# Eval("EmployeeID")%>'
/>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Could anybody tell me what am I missing here?
Rafael
I am passing a query string into a new page and want a detailsview to insert whatever comments a user enters
I am getting an error AlbumUID does not accept nulls error.
I thought I passed the query string value to the insert statement but I must have missed something
Here's what I have:
<asp:SqlDataSource ID="SqlDSAddComment" runat="server"
ConnectionString="<%$ ConnectionStrings:MyCDsConnectionStringHome %>"
InsertCommand="INSERT INTO [Comments] ([Comments], [Rating], [AlbumUID]) VALUES (@Comments, @Rating, @AlbumUID)"
[Code]....
So, I have a button inside a listview:
[Code]....
with a commandName="confirm" and its CommandArgument the memberid from objectdatasource. I have create a code behind to put certain action to the said button..
[Code]....
But it has no effect. Did I make some mistake? I'm still new in this ASP.Net things.
I'm tyring to write a simple DetailsView only used for inserting new records that will pre-fill a textbox with a query string value. Here's the DetailsView:
[code]....
All I want to do is set VenueID_FK.Text to = the "VenueID" querry string. I also want the user to be able to see the VenueID number as they are filling out GridView1.
I know this is probably a simple thing, but I am very new to asp.net. I thought I could handle this in the page load event, but when I try something like this
TextBox VenueID_FK = (TextBox)DetailsView1.FindControl("VenueID_FK");
And then follow by setting the Text property programitically. I've accomplished something similar to this on a different page using a FormView, but only for ReadOnly mode and it was handled in the databound event on that page.
I get the error "The name 'DetailsView1' doesn't exist in the current context." when trying to do the above mentioned. When trying the same line in the databound event here, I get the same error.
I display a bunch of data using a ListView. In the ListView, I insert a CheckBox control that allows the user to select the items he likes. User then clicks a button i.e. button control.I now need to get the data for selected items underlying data. I could use some help with this. Here's what I have so far:
[Code]....
And this is the OnClick event for the button:
[Code]....
So my previous post I made a listview with filtering on dropdownlist from my search part.Now I want that the customer can click on a button from a listitem, and then redirect to another page with all the data from the selected item.
View 3 RepliesI have a Listview in ASP.NET 3.5 page. When I press the Edit button it takes about 10 seconds before the screen is refreshed.
I have disabled ViewState and SessionState with no improvement to response time.
I'm looking for suggestions of what to look at to improve the response.
