I'm working with a simple UserControl someone at my company created. It's basically just a DropDownList with a RequiredFieldValidator and some added properties (such as "Required", which controls the CSS styling of the DropDownList and whether the RequiredFieldValidator is Enabled or not).
Here is an example of the UserControl usage where a SqlDataSource is used to populate the ListItemCollection. I'm trying to specify an intial ListItem below (and would like the ability to add multilple ListItems if necessary) but can't seem to get this to work...
[Code]....
My code-behind looks as follows:
[Code]....
I've found several posts related to this but cannot seem to get the declarative ListItem to be added to the DropDownList.
I understand that using a WebControl is another option, but I'd like to learn how to get this method to work if possible.
but when I run it, it doesnt show it, until after i chose something else and it postback then it shows it at the top. I think it has something to do with the process in which things are loading, this being first, then overriden by the sqldatasource, how can i make this load last? or maybe im just not right about this.
My problem is that some of the users that used to be in the list have left the company so we want to mark them inactive. When they are inactive they should not show up in the DDL to be selected to be assigned to. But there are existing records that they are already assigned to. If they are no longer able to be assigned their is a column called IsActive in the db that is set to 0. The Datasource filters for only == 1 when filling the datasource.
When it tries to render the control where a selected value is not in the list the Browser throws an error. I can not seem to find an event where I can intercept and set a value that is legal.
The solution I would like would be to add the listItem to the Control in the code behind then call the bind("AssignedTo") in the code behind instead of in the aspx page. This way linq would still handing the update of the DB record for the update event.
I am adjusting my DropDownList on my MASTERPAGE to point to resourcefiles - like this:
<asp:DropDownList runat="server" ID="Language1" AutoPostBack="true" OnSelectedIndexChanged="Language1_SelectedIndexChanged"> <asp:ListItem value="0" Text="<%$ Resources:SiteMapLocalizations, DropDownSelect1%>"></asp:ListItem> <asp:ListItem Value="0" Text="<%$ Resources:SiteMapLocalizations, DropDownSelect2%>"></asp:ListItem> <asp:ListItem Value="0" Text="<%$ Resources:SiteMapLocalizations, DropDownSelect3%>"></asp:ListItem> </asp:DropDownList> Problem now is that my SelectedIndexChanged has broken its funktionality in MasterPage.master.vb: Protected Sub Language1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs) Dim cookie As New HttpCookie("SelLang") cookie.Value = Language1.SelectedValue Response.SetCookie(cookie) Response.Redirect(Request.UrlReferrer.AbsoluteUri) this is for the redirecting to the referrer page End Sub
I have a databound dropdownlist, bound to an object datasource. I want to have a default value of "None" inserted at the top of the list and I would like to do this declaritively if possible. After much googling I came up with the below code. However it does not display my default item. I was under the impression that setting the AppendDataBoundItems to True would solve this, however it hasn't.
Now i have a dropdown combo which is manually binded to Builder Table , what i want is that it would disable all those builders in the dropdown to be selected which are residing in Project Table.
I am trying to pass the parameters dynamically thru Sqldatasource and get the results in grid view. Based on the dropdown list selection it has to show the results in grid view. When I hard code its giving correct results but when passing thru parameters i'm unable to get the results in grid view.
Output shud be something like this:
Select the value: 123
124
125.
Lets say user selects '123', the query it runs in sqldatasource is Select col1,col2,col3 from table1 where col1 LIKE '123%'
results will be 12301,12302,12303 with other columns in grid view.
I need to pass a user selected value from a databound DropDownList into a GridView SQLDataSource select statement so the correct records will be selected. I have found lots of documentation on DropDownLists and sqldatasources but nothing that connect the two.
I am facing a small issue in using a DropDownList that has only two values (AND and OR) which i want to use to configure a SQL Query in a SqlDataSource. How can i use this thing by passing the value in a SqlDataSource Select Query in such a way to Bind the Result to a GridView. I want something like this -
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen @Option InvoiceNo = @invoiceno where @Namen is from a DropDownList and InvoiceNo is from a TextBox
I m having a problem in specifying this @Option parameter from a DropDownList which contains only two list items - AND and OR. On the Basis of the Selected Value from this DropDownList i want to execute query like
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen AND InvoiceNo = @invoiceno
or
SELECT [somefields] FROM instinvoice WHERE Namen = @Namen OR InvoiceNo = @invoiceno
Using the Query with @Option gives me a Parsing Error. Why is that so. How can I implement this scenario.
So I have a major issue and cannot find any solution online to solve it excepting one that is singlistviews. But i am also encounting some probs with listviews since i am not sure of to use it.Anyways so my major issue is that I have drop down lists that are being populated by a sqldatasource. Users are filling out a form selecting values in the drop down list which is fine, the prob exists with editing a record. I have the dataValuefield to be the Id of the data and the selected item in the dropdownlist id is being stored in a database. So I have the data in the database that is the Id of the selected item however I cant use the dropdownlist1.selectValue ='idNo' since that only works with listitems.
How can i access the dynamic rows in a dropdownlist that is being populated by a sqldatasource and set the selected item to a particular item?Any insight is greatly welcome. Even how to use listviews
I am trying to use a DropDownList in a DetailsView for the ItemTemplate, InsertItemTemplate, and EditItemTemplate. I must bind this DropDownList to a SQL-Server support table using a function that returns a DataTable. I am not allowed to use a SQLDataSource in my backwards IT department. So, not only do I need to load the DropDownList, I also need to make the SelectedValue equal to the current record that I am viewing, editing.
I have a dropdownlist that's being populated from a SQL datasource. I would also like to have a tooltip for each dropdownlist list item on mouse over. I found the example below which adds a title attribute for each list item using the listitem text as a tooltip but I want to make the title/tooltip value another field in the database. In other words,
I have created a asp.net webpage for viewing daily downloaded newspaper, saved as a pdf file in a selected folder (~/NEWS/{0}) within the web root directory. Also i have a SQL datasource linked, where the news table has two columns viz: date and filename.
I want to create a tiled listview where the date text is visible on the hyperlink. on clicking the hyperlink, the file name is retreived for the corresponding date and the pdf file opens in a fresh page.
I have tried going to the item template in listview and replacing the label control with a hyperlink control, but then not able to successfully proceed ahead.
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 use the sqldatasource control a lot with stored procedures. But this time I'm using some code I found online where I am defining the new sqldatasource in the code and using it. You can see this below. I am getting a NullReferenceException on the first SelectParameters line and not sure why. Do I need to add the parameters different?
Code: Dim SqlDataSource As New System.Web.UI.WebControls.SqlDataSource() SqlDataSource.ConnectionString = ConnectionString SqlDataSource.SelectCommand = "MySprocName" SqlDataSource.SelectCommandType = SqlDataSourceCommandType.StoredProcedure SqlDataSource.SelectParameters("Distance").DefaultValue = 25 SqlDataSource.SelectParameters("ZipCode").DefaultValue = "31410" Dim arg As New DataSourceSelectArguments() Dim dv As System.Data.DataView = DirectCast(SqlDataSource.[Select](arg), System.Data.DataView)
Two ddl inside gridview. on selecting first ddl1 fill next ddl2 by passing selected value as parameter by executing the sqldatasource select command in codebehind.code:
GridViewRow gr = (GridViewRow)((DataControlFieldCell)((DropDownList)sender).Parent).Parent; //find the control in that DropDownList d1 = (DropDownList)gr.FindControl(ddl1); DropDownList d2 = (DropDownList)gr.FindControl(ddl2); SqliaDataSource.SelectParameters.Add("@name", d1.SelectedItem.Text.ToString()); dataView dv=(dataview) SqliaDataSource.select(DataSourceSelectArguments .Empty); Error: There is no source code available for the current location. and Returns null value
I have a series of dropdownlists on webform in ASP 4.0. The first drop down is filled upon load, and then when a user selects a value from that list, it populates the second dropdown. To accomplish this, I have a SQLdatasource with a parametersource of the first drop-down list control. This works great, except when a user changes their selection from the first drop down. It performs the query, but then adds the list of items to the ones that were already there from the previous selection, instead of replacing it with the new data. Here is the code:
[Code]....
Do I need to do something on selectedindexchanged to somehow "clear out" the previous datasource? I can't find anything about this online, although one person seemed to suggest it was related to using a master page. (which I am using).
I have a page called Page2.aspx and it is called by another page called Page1.aspx and Page1.aspx passes two parameters namely: Name and Category to Page2.aspx. Does anyone know why the following code from Page2.aspx is not working and it keeps giving an error message as follows: " You have declare the parameter @Username".
I am using a gridview where i am calling a stored procedure which has 4 input parameters. Out of these 4 parameters, values are to be given such that DomainId = This has to be the row which is to be deleted. This is a primary key Domain = This field has to be passed to SP as NULL. Description= This field has to be passed as NULL. OperationType= This field has to be passed by programmer as some static value say 4 How to i need to specify these here... More details of the Question are here.
