I have a gridview connected to sqldatasource and regular textbox. In sqldatasource I defined selectparameters controlparameter to textbox.I'm trying to rebind gridview when textbox text is changed. So question is how can I rebind sqldatasource?
View 3 Replies
I have ASP.NET page, Page1 and there is a gridview. There is also a linkbutton which takes user to Page2. And, once user clicks a button on Page2, the page is redirecting to Page1.
I want to rebind the gridview on the Page1 with previous gridview again upon coming back from Page2. So I am passing the gridview in the Session variables, and bind it to same gridview again, but it looks like it's not binding (No gridview displayed).
Is there any way I could preserve the gridview and rebind it upon coming back from another page?
The binding of the data to chart switches according to the radio button selection, but it shows only the data that is selected for the first radio button
View 6 Repliesi am doing a drop and drag operation that calls a webmethod to do a data insert on drop. I am trying to figure out the best way to rebind the datalist that i am getting my items from to show accurate items. Should i just remove it using javascript? or rerun the binding?
View 1 RepliesIs there a flag or property value I can set to have my controls re-bind on every page load, instead of just the initial one? I'm still very new to ASP.NET, so I would like to do it properly (if such a way exists) before resorting to the first thing that "works".
I am working on a simple WebForms page, which boils down to a few SQLDataSource-bound Repeaters; for example:
<asp:Repeater ID="ExampleRepeater" runat="server" DataSourceID="ExampleDataSource"
OnItemDataBound="ExampleRepeater_ItemDataBound">
<ItemTemplate>
<asp:Label ID="DataboundControlID" runat="server" Text='<%# Eval("ExampleColumnName")%>' />
</ItemTemplate>
</asp:Repeater>
<asp:SqlDataSource ID="ExampleDataSource" runat="server" ConnectionString="example_connection_string"
SelectCommand="ExampleStoredProcedure" SelectCommandType="StoredProcedure">
<SelectParameters>
<asp:Parameter DefaultValue="exampleValue" Name="parameter1" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
After the user has interacted with my page, they can initiate a postback which will change the state of the database. I'd like the postback'ed page to reflect the changes to the database.
I have an jquery ajax event that fires and sends some variables to a user control. the user control (which displays a repeater) takes these values, runs a query, and returns a list for binding to it's repeater. For some reason it wont let me bind to the repeater. It just quits the debugger?
View 6 RepliesI have a DetailsView control, in edit mode, I want to hide and show fields based on a DropDownList's value inside it (the DropDownList makes a postback).
The problem is that when a hide and the show operation is maked, the DetailsView control will make a rebind for it and all the filled fields are cleared!
How can I prevent this behaviour?
I have a grid with one TemplateField which is a checkbox and say 2 bound fields.
In Page_Load on postback I rebind the grid with cached dataset stored in session. If user selects checkbox on the grid, upon postback i can iterate on the grid and get those checked values, everything works fine.
If I move the code of grid binding on postback to OnInit instead of Page_Load then i loose those user checked checkbox data. Why? Should the postback data not overlay on top of the grid after oninit?
It does work with page_load, I'm assuming that when i rebind the grid, I'm overlaying my data on grid which has postback data, since the checkbox column is not bound i do not overwrite postback data.
NOTE: viewstate is disabled on my grid, i bind data (stored in session) on everyback postback. Also something weird, when I'm using OnInit, on every postback i get the first page of the grid, no matter which page the postback was triggered.
i appologise if thisis a silly question but i just want to be completely sure something is not possile before i tell this to my manager.
i am a WinForms programmer by trade, but i have put in charge of making a web site for our sales team, and web development is a new area for me. the web site is written in ASP.NET, C# code. it is finished, however they are complaining that there are too many page refreshes.
first of all, we have an SQL server with all our data in it. on the main web page, the user must select their country of interest from a DropDownList. when they do this, all our customers from that country are displayed in an html table, generated by a Repeater. i have set AutoPostBack on the country DropDownList to true, so each time the user selects a different country, the SelectedIndexChanged event handler is called, and in here i generate a new sql statement with the selected country, and re-bind the Repeater.
There are also a few other DropDownLists that do other 'filtering' stuff. for example, one DropDownList selects whether to display customers whose license expires soon (within a week), and another DropDownList filters the customers who currently have an open support case. All the DropDownLists have their AutoPostBack set to true, and in their SelectedIndexChanged event handler, i work out the sql based on the values of the DropDownLists, and re-bind the Repeater.
the problem with the above is that each time the user selects a different value from the DropDownList, the page refreshes, clearly because the AutoPostBack is set to true for them all. so to stop this i need to set AutoPostBack to false - but then of course the SelectedIndexChanged event handlers are not called, and so i have no place to rebind the repeater with my new sql statement.
so what i really need, is to be able to set a DropDownList's AutoPostBack to false, and handle the rebinding of the Repeater in some client-side event, which does NOT result in a postback. the Repeater will be bound by some sql, which is generated by the values in the DropDownLists (eg "SELECT * FROM custTable WHERE [Country]='" + CountryDropDownList.Text + "'"), so in this client-side event i need to be able to reference the asp.net controls.
I have a ListBox declared like this in my aspx:
[Code]....
And I need to rebind it in the codebehind:
[Code]....
Then I want only the second item in the list to be selected
[Code]....
I don't want the first item to be selected, what do I miss?
Some of you might know that I am currently working on a simple blog (thread with full details here). There is a slight problem however ! After achieving the post filtering, the blog doesn't show any posts, unless; I click on of the categories. I was hoping that the blog would show ALL posts at first, and THEN if a user clicks a Category, the filtering would occur. So I went over the code again, and there was this:
[Code]....
The DefaultValue="0" caught my eye, so I changed the number to "1" and I got all the posts in the [ General ] category, I tried "2" and I got the posts from the [ Programming ] category ..etc So I was thinking how I'd go about solving this problem, because (initially) I want the posts from ALL categories to show. Is it possible to add more than one defaultValue ? for example: DefaultValue = "1,2,3"
I have tried the above and it gave me errors, so obviously it doesn't work that way, but is there another way of adding more default values ? Or could you think of a different way to make all the posts show ?
Inside the OnItemCreated event (of the repeater), I get the ID of the textbox that I want to bind to the ControlParameter. I realized that using the ID alone was not working. I get a message saying something like "can't find txtBoxName in ControlParameter". I read somewhere that if I view the page source of the browser, then use the value in the Name attribute of the textbox (for the controlId property of the controlParameter), it works. But I also noticed that when I use a textbox outside the repeater, I could just use the ID of the textbox (without having to use page source to get the name, which is different from the ID in the aspx page, of the textbox).
View 1 RepliesI'm using a jquery plugin called uploadify to upload images to my database. I'd like my datalist to be auto-rebind after the images' been uploaded so people could see the changes immediately. Also because this is a feature for admin there is a delete button in the datalist. I used updatePanel for this.
I put __doPostBack('" + upnlUploaded.ClientID + "','') to the javascript so when Images have been uploaded the update panel will postback.
I also have the following two lines to make it working...
<asp:UpdatePanel ID="upnlUploaded" runat="server" UpdateMode="Conditional" OnLoad="upnlUploaded_Load"> <%--upnlUploaded_Load --%>
One thing I really don't like about Updatepanel is that I have to rebind almost all components in the page.
For example, I have to specify Eidit (Update) index (for inline editing) after rebind Listview using Update panel (after partial update).
It was too much job to rebind all components, so I redirected to same page and used Querystring to pass values in order to avoid all components to be updated based on one value...
If I update Listview using Updatepanel, the datapager has to be updated as well based on new Select SQL statement results.
Listview is pretty simple to update, using "Listview1.bind()" does the job.
Datapager is also in updatepanel, but it won't rebind with new results.
After post back, I'm still getting same Datapager as the orignal SQLDataSource.
In orger to "refresh" Datapager, what do I need to do??
I used to use iframe to do partial page update, but I'm having big problem using Updatepanel since simple rebind won't do the job.
I'm using an accordion control with a textbox to get data that I'll use later to get values for a ObjectDataSource, that use the data of the textbox as ControlParameter.
my problem is that I'm getting a 'Not found control error...' because the textBox is inside the accordion how can I reffer the control into my ObjectDataSource?
Here is a reduce example of my code.
[Code]....
I am trying to do a version of this post, but with the EntityDataSource. I think I am close, but it seems that the "InsertText" and "Insert" command in the code-behind do not carry over. Here is what I have so far, but please help me fix it. In addition, in the .edmx the Table "UserProfiles" inherits from "aspnet_Users"
[Code]....
[Code]....
I have a gridview connected to sqlDS and a dropdown Dropdown contains a selection Last 30 days, 60, 90,180 etc... How to write a Where Statement that reflects this? If I want to view the last 60 days of records
WHERE RecordDate >= TodaysDate - 60 days, but as a parameter
WHERE RecordDate >= TodaysDate - @SelectedValue days
Is this a clear explanation?
I have a SqlDataSource that calls a stored procedure and it works fine. If I add a <ControlParameter> tag to add an additional argument, then the query never fires and the databinding never occurs.
This works:
[Code]....
When I add the ControlParameter, the databinding no longer occurs:
[Code]....
The ControlParameter refers to a valid object on the page.
I am having a problem with using A Gridview SectedIndex or value in a sql ControlParameter. When I select the row it does what I need it to except it shows that there is no data.
but if I add Default Value of 1 the data shows up, but it needs to read from the Gridview.
[Code]....
I even added sqlDataSource.DataBind() in the SelectedIndexChanged Event to see if that would fix it but - No! I used it with a DropDown and it worked only when I use AutoPostBack = true of course.
I am trying to add a textbox search to a gridView. However I am recieving the below error
View 3 RepliesI have this code in an .aspx file, within a sqldatasource control.
<asp:controlParameter
Name="WH"
ControlID="rblWH"
DefaultValue="DL"
Type="String"
Size="2"
Which currently uses a 2 character code from a radio button list as its value. It is used as a parameter for a stored procedure. Somewhere else on the page I have a combobox called cbTripPick with that 2 character code embedded within its text property. I wish to use that 2 character substring as the control parameter instead of the above. Can I do something like this ?
<asp:controlParameter
Name="WH"
ControlID="cbTripPick"
PropertyName = "some function or expression or eval that will give me the 2 char. value from the cbTripPick control"
DefaultValue="DL"
Type="String"
Size="2" />
Is it possible to declaratively set the propertyname to some dynamic expression which will get me what I want? Or should this all be done programmatically?
I am working on a project and I need to use Master/Details view, the problem is everything works fine except when I place the Master (gridview) and Details(FromView) in different content holder.
The error I get is:
Could not find control 'GridView1' in ControlParameter 'ID'.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: Could not find control 'GridView1' in ControlParameter 'ID'.
My code is:
[Code]....
[Code]....
[Code]....
[Code]....
I have a master page that divides the main content into two areas. There are two asp:ContentPlaceHolder controls in the body section of the master page with IDs cphMain and cphSideBar respectively.
One of the corresponding content pages has a control in cphMain that needs to refer to a control in cphSideBar. Specifically, a SqlDataSource in cphMain references a TextBox in cphSideBar to use as a parameter in the select command. When the content page loads the following run-time error occurs:
Could not find control 'TextBox1' in ControlParameter 'date_con'.
Description: An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
[code]....
I kinda know what the problem is... ASP.NET does not like the fact that the SqlDataSource and TextBox are in different asp:Content controls within the content page.
As a workaround, I have another TextBox in cphMain with the SqlDataSource which has Visible=False. Then in the Page_Load() event handler the contents of the TextBox in cphSideBar is copied into the contents of the non-visible TextBox in cphMain.
I have an ObjectDataSource with a number of parameters. These parameters are binded in my FormView EditItemTemplate and the ItemTemplate. My Stored Procedure column names in my ItemTemplate are different to the Bind properties used in the EditItemTemplate. This is obviously throwing an exception when I update a record.
Instead of using Bind("Columne Name") in my EditItemTemplate how do I use a ControlParameter to reference a TextBox in the EditItemTemplate?
I may be wrong but I'm trying to use the PropertyName=Controls but i do not know how to reference the Textbox in the EditItemTemplate.
i'm using Relational Tables and during Edit, my Drop Down list is a lookup column from the Master table, but when i try to edit it works and shows the records the only problem is that when i udpate, i get the error (Can't find control DDLSongs (my drop down control) in @AlbumID Parameter) below is the code for ref.
<asp:GridView
ID="grdSongs"
runat="server"
DataSourceID="srcSongs"
DataKeyNames="SongId"
AutoGenerateColumns="false"
[Code]....
