Alter Dropdownlist After Been Databound To Sql Data Source
Jul 6, 2010
I've got my Drop down list databound to an sql data source, now I need to change the data in a few of the fields before it gets displayed. I've been messing with this all morning and I can't find anything useful, this is what I've got so far and it's clearly not working.
Protected Sub ddlBookType_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles ddlBookType.DataBound
'ddlBookType.Items.Insert(0, "Any")
Dim i As Integer
For i = 0 To ddlBookType.Items.Count - 1
If ddlBookType.Items(i).Attributes.Equals("mod_cook") Then
ddlBookType.Items(i).Text.Replace("mod_cook", "Modern Cooking")
End If
Next
End Sub
View 1 Replies
Similar Messages:
Jul 8, 2010
I put a sql statement into the textbox,then the result will be bound to the gridview in the page. first time,sql statement is "selecte * from A(B)",and the gridview is ok. second time,sql statement is "selecte * from B(A)",then the gridview will throw a exception the exception is "A field or property with the name 'aa' was not found on the selected data source. i have two tables A and B."
View 5 Replies
Jan 6, 2010
my folowwing code is generating error - selectedItem does not of string type. Basically i am unable to insert values through dropdownlist genrated dynamically.
Imports System.Data.SqlClient
Imports System.Configuration
Imports System.Data
Partial Class open_temp2
Inherits System.Web.UI.Page
Dim conn As New SqlConnection(ConfigurationManager.ConnectionStrings("ABC").ConnectionString)
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim da As New SqlDataAdapter("select partyNameID, partyName from tblParty", conn)
Dim ds As New DataSet
da.Fill(ds, "ds_tblParty")
da.SelectCommand = New SqlCommand("select quotedPositionID, quotedPosition from tblQuotedPosition", conn)
da.Fill(ds, "ds_tblQuotedPosition")
Dim I As Integer
Dim J As Integer = 1
For I = 1 To ddlNo.SelectedItem.Value
Dim MyDDL = New DropDownList
Dim MyDDL1 = New DropDownList
MyDDL.ID = "ddlParNam" & I
Session("a" & I) = MyDDL.ID
MyDDL1.ID = "ddlQuoPos" & I
Session("b" & J) = MyDDL1.ID
MyDDL.DataSource = ds.Tables("ds_tblParty").DefaultView
MyDDL.datatextfield = "partyName"
MyDDL.datavaluefield = "partyNameID"
MyDDL.DataBind()
MyDDL1.DataSource = ds.Tables("ds_tblQuotedPosition").DefaultView
MyDDL1.datatextfield = "quotedPosition"
MyDDL1.datavaluefield = "quotedPositionID"
MyDDL1.DataBind()
Panel1.Controls.Add(MyDDL)
Panel1.Controls.Add(MyDDL1)
Dim MyLiteral = New LiteralControl
MyLiteral.Text = "<BR>"
Panel1.Controls.Add(MyLiteral)
J += 1
Next
End Sub
Protected Sub btnCancel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnCancel.Click
Response.Redirect("Default.aspx")
End Sub
Protected Sub btnSave_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSave.Click
Dim comm As New SqlCommand("insert into tblOBDDetails(specNoID, partyNameID, quotedPositionID) values (@specNoID, @partyNameID, @quotedPositionID)", conn)
comm.Parameters.Add("@specNoID", Data.SqlDbType.Int)
comm.Parameters("@specNoID").Value = ddlSpecNo.SelectedItem.Value
conn.Open()
Dim I As Integer
Dim J As Integer = 1
For I = 1 To ddlNo.SelectedItem.Value
comm.Parameters.Add("@partyNameID", SqlDbType.SmallInt)
comm.Parameters("@partyNameID").Value = Session("b" & I).selectedItem.value
comm.Parameters.Add("@quotedPositionID", SqlDbType.TinyInt)
comm.Parameters("@quotedPositionID").Value = Session("b" & J).selectedItem.value
comm.ExecuteNonQuery()
J += 1
Next
conn.Close()
End Sub
End Class
View 1 Replies
May 24, 2010
I am trying to select a value, automatically, out of ddlCounsellorNameb by selecting a value in ddlCounsellorID. I've been getting a databinding error whenever the first dropdownlist posts back. How do I do about this without getting an error?
[Code]....
View 2 Replies
Jan 22, 2010
I want to accomplish is to check the value of a field against the values within a databound dropdownlist.
[Code]....
View 13 Replies
Aug 25, 2014
i want to "populate" a dropdownlist in vb code inside a Datalist_ItemDataBound but i get this error: adding a value to a 'datetime' column caused overflow vb.net maybe a have done something wrong. here is the code inside Datalist_ItemDataBound
Dim loMarcaDL As String = hfMarca.Value 'CType(e.Item.FindControl("hfMarcaDL"), HiddenField).Value
Dim loAnulDL As Integer = hfAnul.Value 'CType(e.Item.FindControl("hfAnulDL"), HiddenField).Value
Dim loLunaDl As Integer = hfLuna.Value 'CType(e.Item.FindControl("hfLunaDL"), HiddenField).Value
Dim loActivity As String = CType(e.Item.FindControl("hfActivityID"), HiddenField).Value
'Find the DropDownList in the Row
Dim ddlDescriptionEGD As DropDownList = CType(e.Item.FindControl("ddlDescriptionEGD"), DropDownList)
[code]....
View 4 Replies
Oct 27, 2010
i am a new user of asp.net and i am a learner so i just want to connect two dropdownlist to data souce and i want that the list item of second dropdown is changed according to change of selected item of first dropdown.
i have connect it to data source successfully it getting chaged items but it happance only when its load then if i select the next item of first one it would not work properly.
View 3 Replies
May 26, 2010
I am populating a dropdownlist in a detailsView on Page_Load using a table adaptor as follows
[Code]....
[Code]....
View 3 Replies
Sep 20, 2015
I am binding a control which is inside Gridview, using SqlDataSource control as below.
<asp:ComboBox ID="ddlCompany" runat="server" Height="200" Width="240"
DropDownWidth="310" EmptyMessage="- Select Product -" HighlightTemplatedItems="true" CausesValidation="false"
Filter="Contains" AppendDataBoundItems="true" AllowCustomText="true" AutoPostBack="true"
DataTextField="Title" DataValueField="Code" OnSelectedIndexChanged="ddlCompany_SelectedIndexChanged">
</asp:ComboBox>
[code]....
In above SqlDataSource control, I had to pass the SelectParameter (whose value is coming from a ComboBox i.e., whatever comboBox value I selcect from ComboBox, its SelectedValue I had to pass it to the SqlDataSource SelectParameter. I am first time using "SqlDataSource". How to pass the SelectedValue of ComboBox into SlecteParameter of SqlDataSource control ?
View 1 Replies
Feb 15, 2011
I have a dropdownlist that pulls from a datasource. When a name is selected all information drops down to a formview. Once there 3 fields get populated from the dropdownlist and then there is 2 other fields that need user input. Once they hit submit, it should write to a different table in the same DB. I cannot get the fields to populate and write to the DB. Here is my code:
[code]...
View 1 Replies
Apr 12, 2010
I have following in many controls:
<asp:ControlParameter Name="SvcCluster_Id" ControlID="frmConfigEdit$ddlCluster" PropertyName="SelectedValue" />
Everything was good before I bumped into the problem when declarative binding (SelectedValue='<# Bind("SvcCluster_Id") >') produced the error, because value has not been found in the list. So i moved binding to the code:
protected void frmConfigEdit_DataBound(Object sender, System.EventArgs e)
{
if (frmConfigEdit.CurrentMode == FormViewMode.Edit)
{
var svcCluster_id = DataBinder.Eval(frmConfigEdit.DataItem, "SvcCluster_id");
var ddlCluster = (DropDownList)frmConfigEdit.FindControl("ddlCluster");
if (svcCluster_id != null && ddlCluster.Items.FindByValue(svcCluster_id.ToString()) != null)
{
ddlCluster.SelectedValue = svcCluster_id.ToString();
}
}
}
But now seems like this happens later than ObjectDataSource tries to access frmConfigEdit$ddlCluster...
How to manage this?
I wouldn't like to move everything to the code (I mean creating Control parameters, etc)
p.s. Oops, actually it works ok for DataBound event! Sorry.
View 2 Replies
Mar 9, 2010
Let's say I have DropDownList ddlRooms bound to the datasource which returns list of available rooms from table tblRooms. On the other hand I have users, and their info is stored in table tblUsers. Using FormView frmUsers can be inserted, edited and updated... frmUsers is be bound to separate datasource. To each user, I would ilke to assign a room, so the value of txtUserRoom will be populated based on the selected value from ddlRooms. How can i pass the selected value of ddlRooms to txtUserRoom while keeping txtUserRoom stil bound to user datasource? Do I need two separate fileds or can i just put value of ddlRooms into datasource user?
View 3 Replies
Feb 22, 2010
I have a databound dropdownlist hooked up to a table and the query has the returned items show up in order. I also have some default items that are _DataBound like so:
[Code]....
What I'd like to do is add some more items, but have these new items show up in order with the other items displayed from the query. How do I accomplish this?
View 8 Replies
Nov 22, 2010
I have a databound dropdown list (ASP.net). I want the page to load with a certain item as the selected item.
I am not adding a blank first row (thats not what i need)I find that I can get this to work with "AppendDataBoundItems" to true, but the side-effect is that I have all the items listed twice.
View 1 Replies
Oct 25, 2010
I've build a Modal Popup extender with a DataBound DropDownList. The only problem I've got is that the DropDownList is being filled in the Page_Load. Even when I put the binding in the Load of the Modal PopUp extender there is no data inside my Dropdownlist.What am I doing wrong here? Because everything should work when I hit the TargetControlID.
View 3 Replies
May 24, 2010
I have a datalist in my site which displays html tables filled with data from a sqldatasource. I need to be able to remove one column from the table and put it back again (including the tags in my table which pull the data from the datasource e.g. <%# DataBinder.Eval(Container.DataItem,"Forecast1") %>) I need to be able to do this because I have options to change the sqldatasource query, and I need to alter the table to keep it compatible with the query. What is the best way to do this?
View 4 Replies
Dec 14, 2010
I've already searched to no avail for an answer to this question:is it possible to dynamically alter the page size in a paged gridview based on data in a particular column?In other words,let's say I get data from a table that lists students enrolled in a particular course.If there are 10 students in Course "A," then I want page 1 in my gridview to show 10 records.
If there are 15 students in Course "B," then I want page 2 in my gridview to show those 15 records,and so on.I imagine that this could probably be done with a master-detail kind of set up,but let's say for the sake of argument that I don't want to go that route.
View 4 Replies
Jul 10, 2010
I am working on a site using .aspx controls. Currently I am working on a search feature which searches my database of records and produces all applicable results to the search. Everything works as planned. I have recently added the EmptyDataText line to produce a specific output anytime no results are found in the database. However, I would like to be able to alter/change the appearance of the EmptyDataText output and cannot figure out how to do so. For example, if no results are returned from the search, I would like the EmptyDataText to produce an output of something along the lines of "Your search has produced zero results.
double check your spelling and try your search again." I would like to change the font color, font size, and possibly the thin box which is automatically produced around this output. Is any of this possible? If not, is there another way to produce the desired results? Ultimately, I would actually like to have the results actually use the terms which were input to the search within the EmptyDataText results when no search results are found within my database. For example, if "widget" was used as a search term and "widget" was not found within my database then i would like the results page to state something along the lines of: "Your search for 'widgets' did not return any results. check the spelling and try your search again." Does anyone know how to do any of these things using ASP.Net?
View 1 Replies
Mar 27, 2010
I have a repeater bound to a datasource that servers as a list of birds. When the user clicks an item in the list the bird's image is displayed on the page. I want to change the background color of the item that is currently selected in the OnClick handler for the main item in my repeater's ItemTemplate.
I have changed the styling of controls prgrammatically before and it worked fine but in those cases i used the ID of the control to directly access it in my code behind file. But since this is some arbitrary item in a repeater I don't know it's ID at runtime, all I have is the sender object passed to the control's OnClick handler. So in my code behind file, I tried casting the sender object passed to the OnClick handler to the appropriate type and used Style.Add("background-color", highlitColor) but it failed to change anything.
I had a thought - maybe this sender object gets passed by value so all I did was change the Style of a COPY of the control item.
If this is indeed my problem, how do I start with a casted sender object in an event handler and get a reference to the actual control in order to change it's Style?
View 13 Replies
Jan 6, 2011
I recently started using SSRS 2010 and I didnt come across this issue in 2005 or 2008 versions of reporting services.
I have a report that drills down to child report1 and then that drills down to child report 2 but clicking a field in the report.
When I click on the link on the first report to go to the second report. I get this error message
"A data source instance has no tbeen supplied for the data source ''reprort2dataset"
I am not sure how to handle this error.
All reports run fine stand alone, but when I try to link them up I get that error.
I have a report viewer running the reports in an aspx page.
View 1 Replies
Aug 4, 2010
Where and what am i missing?
this code produces some error:
DataSet ds = services.getOrdersReport(1, "", DateTime.Parse(System.DateTime.Now.Date.ToShortDateString()));
ReportDataSource datasource = new ReportDataSource("JMJ", ds.Tables[0]);
rv.LocalReport.DataSources.Clear();
rv.LocalReport.DataSources.Add(datasource);
rv.LocalReport.Refresh();
ERROR :
A data source instance has not been supplied for the data source 'dsOrders_tblOrdersReport'
'dsOrders_tblOrdersReport' -- name of the table designed in dataset.XSD
View 1 Replies
May 10, 2010
i have a FormView, and i already have a Label control that gets the value of theselected propery inside the FormView, so each time the FormView displays data, i have a Label control that displays individual values, according to the value of the FormView, here is the code:
[code]....
What i would like to do is to know how i could add a DataList instead of a Label, and then each time the FormView databinds an item, to show the value of the DataList How would i go about doing that?
View 10 Replies
Dec 7, 2010
I want to render something like this (with ASP.Net Controls in the codebehind):
<ul>
<li class="first"><h1>This is a caption</h1></li>
<li><a href="#" title="" target="_self">Foo</a></li>
<li><a href="#" title="" target="_self">Foo1</a></li>
<li><a href="#" title="" target="_self">Foo2</a></li>
<li><a href="#" title="" target="_self">Foo3</a></li>
<li><a href="#" title="" target="_self">Foo4</a></li>
</ul>
<ul>
<li class="first"><h1>This is a another caption</h1></li>
<li><a href="#" title="" target="_self">Foo5</a></li>
<li><a href="#" title="" target="_self">Foo6</a></li>
<li><a href="#" title="" target="_self">Foo7</a></li>
<li><a href="#" title="" target="_self">Foo8</a></li>
<li><a href="#" title="" target="_self">Foo9</a></li>
<li><a href="#" title="" target="_self">Foo10</a></li>
<li><a href="#" title="" target="_self">Foo11</a></li>
</ul>
The amount of li elements that will be rendered into each ul is determined at runtime. Each link in a li belongs to into a specific ul (the one containing a specific caption. Imagine this as a kind of a treeview with nodes and subnodes) During the bind Event I need access to an ASP:HyperLink that will be rendered into the a-element. Which databound ASP.Net control should I pick for this? Looks like a repeater in a repeater, which should make the databinding process ugly. I'm thinking about creating this HTML-Output with StringWriters myself.
View 1 Replies
May 14, 2010
I am getting the following error while i bind the dataset dynamically in reportviewer(Asp .net 4.0) . I have binded the dataset using stroedprocedure.
Error:A data source instance has not been supplied for the data source 'DataSet1'.
View 3 Replies
Jun 24, 2010
I have a DataBound DropDownList that is loading fine, but i'd like to insert another item that says "--Select--" or something instead of having the first DataBound item automatically display.
Is there an easy way to do this or do I need to manually add a dummy item?
Here is my code:
MyContext fc = new MyContext ();
ddl.DataSource = fc.SomeTable;
ddl.DataBind();
View 2 Replies
