Forms Data Controls :: Selectparameter Not Passed?
Jan 11, 2010
I am really sorry for this, but this is such a bizarre situation I don't know where to turn. I have a stored procedure that takes four parameters (two dates, a positionID, a userID). The SQLDataSource is very generic:
[Code]....
and I set the parameters via this code:
[Code]....
When this executes, no matter what the value of PositionID, it acts as if the PositionID is zero. Now, if I remove PositionID variable and add the number:
[Code]....
All is well. Also, when I look at the parameter in the immediate window, it appears to be correct:
I am trying to get my Nested ListView to work. I have my parent List View supplying the correct information, but I can't seem to set the SelectParameter Value for my Nested ListView. I am using SQLDataSources for both. I read your comment about adding a Hidden Field. Where Should that field be located. Right now I have it inside my Parent ItemTemplate but nothing is happening. Currently I have both DataSource outside my Parent ListView. I tried moved the nested ds inside with the list view but I still was not able to grab the hidden field values either. Here's what I have:
How do I set the selectparameter of Objectdatasource in usercontrol from dropdownlist in parent page?I tried the following but when I select a new value in the dropdownlist it does not change the data from the initial page load
Protected Sub ODSLocations_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.ObjectDataSourceSelectingEventArgs) Handles ODSLocations.Selecting Dim ntid As DropDownList = CType(Me.Parent.FindControl("DDLEmployees"), DropDownList) e.InputParameters("ntid") = ntid.SelectedValue End Sub
I'm using a ListView (e.g topListView) with paged rows (using a DataPager). One of the topListView's features is when a user clicks on one of its rows, its SelectedValue property is used to populate a SelectParameter in another SQLDataSource control that populates another ListView (e.g. bottomListView). It's working fine. Even when the webpage first loads, the SelectedValue of first row of the topListView is successfully being used to generate content in the bottomListView.
However, when one of the DataPager's buttons is clicked, the SelectedValue seems to be ignored, and the bottomListView isn't refreshing. And yet, when you click a DataPager button again, it works. basically it's taking TWO clicks of the pager for the SelectedIndex to be read. I've tried assigning the SelectedIndex to 0 in the PagePropertiesChanged and PagePropertiesChanging handlers but no luck (even with calls to bottomListView.DataBind(); and/or SQLDataSource1.DataBind(); after index assignment).
assigning the index seems unecessary though, since top row content is being rendered correctly in a SelectedItemTemplate after clicking any DataPager button. to me that means the SelectedIndex is being set to 0 when the page is being re-rendered.
Can't say I'm new to this, but I just can't see what I'm doing wrong. Can some one please take a look at this and point out why is my Edit event from the DataList not exporting the index value that is needed to populate a FormView? Below is my reduced code.
I'm working with Linq and I'm using with ObjectDataSource that have SelectParameters tag for inserting default parameters to object.
How can I set <DefaultValue> for an array parameter ?? (i.e : object that have 2 parameters - string and array of int , I can set <DefaultValue> for the string but I don't know how to do it for array)
I've got a gridview with three fields, the last of which is a template field with an imagebutton in.
The first field is a Date, and the second is a time field (it is however just varchar field as it may differ and will not be programmatically used).
I want the following to happen if I click on the imagebutton (reserve):
Four other fields must be inserted into the record.
Is the best way to launch a detailsview where the row.imagebutton@=ID and just edit the fields like that or should I pass the two fields (and RecordID) along with the query string to a new page where the passed information can be in invisble textbowes and just have the user enter (UPDATE) the four outstanding fields? I feel like doing it this way?
can read on 1. setting up the onrowcommand code for the templatefield 2.
This should be simple as it is only one table with records that has to be partially inserted by an admin person (2 Fields) and then completed by a web user (4 fields).
Running both statements above in the query analyzer it WILL return me different results. Why? Someone mentioned that it looks like I don't have correct data type specified for SQLParameter in .Net application. I was asked to create something like:
I have a Gridview with a templated column that gets a True/False value from the SQL Datasource. The value displays as a string in a label in the template. I added a RadioButtonList and in the RowDataBinding event put in some logic to set the appropriate radio button based on the text value of the Label.
Now I want to be able to interrogate the RBL upon update and set the Label text accordingly. I tried the Row_Updating event but that doesn't have a handle on the row itself and the RBL is not in the NewValues or OldValues collection since it's not one of the bound fields. I tried the RBL_SelectedIndexChanged event but I can't get the current row (got a handle on the Gridview but Gridview.SelectRow and Gridview.SelectedDataKey are both null).
how to interrogate the RBL and set the Label so the correct value is passed back to the datasource for update?
I created a Function called GetWordsLike("word") it look in database to get some words that they are like "word". i also have a TextBox in my page to get "word" from User.
i use ObjectDataSource to databind a gridView and this ObjectDataSource use the GetWordsLike("word") Function to get the data frome database.
now i need to give this "word" to ObjectDataSource programatic.
I have comma separated data on client side [Since my columns and rows are dynamic along with dynamic control inside it which are not accessible in backend due to viewstate issue of dynamic controls],
So I am passing CSV string to Web Method as and want to get Excel file out of it.
I tried following code but it is not exporting the file.
I am using 3 web controls ,two are cascading dropdownlists used to filter gridview control bound to a datasource.
My question is , How to define multiple queries in stored procedure that takes parameter values from the controls declared using sqldatasource.Also, return all data when i set default control value to say 'null'.
NB: one paramaterised query for cascading dropdownlists and another for other control.
I am trying to update a records by calling a SPROC throgh my SQLDataAdapter.Here is my code in this order :
[Code]....
I have looked for parms which are field names with the @ in front but I can't seem to locate them in my code.I could use the assistance of a fresh pair of eyes.
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.
I have a problem with dll. I have a class library and genrerated a dll. that dll has business entity object.If i pass value from front end t that dll.The value has not been accepted.Its remaining null after i passed the value
My gridview has hyperlink field which will redirect to another page when clicked. Is there any way to hide the values from being shown in the URL? I do not wish to have encrypted values as well.
?DirectCast(Me.FindControl("txtFName"), TextBox).Text.ToString().Trim() Referenced object has a value of 'Nothing'. ?txtFName.Text "Lisa"
So .. if I take out the DirectCast syntax, the value is passed but with DirectCast I get the Referenced Object has a value of nothing .. why and do I even need DirectCast here?
Is there a way of checking validation on the fly as the user inputs data and then when all validation is passed - change the submit button to green colour?
In each cell there is a checkbox. On page load, each checkbox is checked depending on records 0-99 from a database. This works fine.
However, I want to be able to update those 100 records in the database by checking or unchecking the checkboxes.
The update process works ok as I have debugged it, but the problem seems to be that if I check a checkbox, that value (true or false) doesn't get passed to the event handler.
This is the button click event handler that I'm running right now to see if the value is being recognised:
[Code]....
If I tick checkbox zero and click the button, it still comes up as false. What I want to happen is that the DB is updated and when the page loads, the checkboxes are repopulated with the new values from the database.
I have a gridview and template field (textbox) control. on GridView_RowDataBound I want to find the control and pass the control id to a javascript which will set datepicker on that textbox here is how I am doing but its not working.