im getting 'ON' as value instead of its actual value
View Complete Post
I'm building a Sharepoint page with a data form web part that uses custom SELECT and UPDATE statements with an SQL Server connection in order to retrieve and store records of information.
I'm getting along fine, records seem to update how they should etc, but I've ran into a problem with one thing: Sharepoint dropdownlists in 'Edit Template'
So the issue is this: if I replace a textbox field with a dropdown list that is populated with a separate SQL datasource, the dropdown list seems to be unable to show the current value of the field.
E.g. I have a dataview which has a field "FruitID", which I can update just fine by setting the ID value to different numbers. The SQL datasource uses the FruitID to display a list of all available Fruits, (e.g. 1 = Banana, 2 = Apple, 3 = Cherry,
If i open the dataview in editmode, the default value in the dropdown is null, despite the real value of the field being "2", which should show "Apple" in the dropdown.
I can select a fruit and click save, and it will update just fine. But the initial display needs to show the correct value to start with.
Is there a custom binding I should be coding to make this work? I can't configure dropdown <items> on an individual level as they are populated from the SQL server. I can't set "SelectedI
I have a dropdownlist that I am trying to populated from a data source using an Oracle db. I can't get any data with the code I have. Can this be down in Sharepoint? Here is the code I am using:
<asp:DropDownList runat="server" id="DropDownList2" AutoPostBack="true" DataValueField="POPULATION_LIST_ID" DataSourceID="sdsLastName" DataTextField="Last_Name" Visible="True" Height
I have assigned a work to create a report, that should render in excel with dropdown list. i.e. report should contain a input parameter as a table names, when user selects the table name, report should show only the field names of the selected table. Some
of the field name have look up values that values should be displayed as dropdown when we export to excel.
Can any one have any idea how to proceed with this report?
is there a way..where an alert window prompts up to remind the user to select a checkbox when one field in dropdown is selected..for example
there is a dropdown field(Status) which contains (Tobe confirmed, confirmed and rejected ), when confirmed is chosen..an alert window prompts up reminding the user to select a checkbox(send email) - Yes or No. It is not compulsory for the user to select
the checkbox, but if Yes is chosen, the workflow will send an email
I'm attempting to load a GridView dynamically on a button is pressed.
The gridview has AutoGenerateColumns="True" (set in skin definition) and has a declarative column definitions as follows:
<asp:GridView runat="server" SkinID="GridViewDetail" ID="gvReport" DataKeyNames="dateofcompletion"> <Columns> <asp:TemplateField HeaderText="Date"> <ItemTemplate> <asp:LinkButton OnClick="
I have a choice list column containing dropdown values. I crawled the content source and created Managed Property to map it.
Also Configured Advanced Search webpart to display the property. But when I pick the property and perform search with values then no results are returned.
Can any one can help me out.?
Thanks in Advance.!
I'm having a devil of a time joining two tables for a BDC to be used as a Business Data field in a list. I've seen plently of examplesÃÂ connecting two tables to use with web parts, however i haven't seen anything about using an association in a list. Before i continue to beat myself up i need to know that this is possible.
If that's confusing here's what i'm trying to do.
I have two tables Locations and Region. I need the Region_Name from the region table based on the Location_Id (primary key) from the Location table. Locations is connected to Region by Region_id as a foreign key.
Any help would be immensely appreciated.
I am trying to bind the XML data to a datagrid from an XML file. I don't know why I am getting the message: "A field or property with the name 'User_x0020_Name' was not found on the selected data source."
The "User_x0020_Name" field does exist in the XML file. This is a portion of the XML file.
<?xml version="1.0" encoding="utf-8" ?> <DataSet xmlns="http://www.----------.com"> <xs:schema id="NewDataSet" xmlns="" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> <xs:element name="NewDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Table"> <xs:complexType> <xs:sequence> <xs:element name="User_x0020_Name" msdata:ReadOnly="true" minOccurs="0"> <xs:simpleType> <xs:restriction base="xs:string">
I need to filter a dropdown field on a form that is linked to another list. The linked list has a field active/inactive and I only want the active ones to show on the form.
How do i set a data source of a drop down list which is inside a grid view, snap shot of asp code given below , the Asp file name is DataEntry.aspx and there is method in the DataEntry.aspx.cs called DTB.BindData("Department"). i want to set the datasource to point to this method
<asp:GridView ID="GridViewEmply" DataKeyNames="EmployeeID" runat="server" AutoGenerateEditButton="True" ShowFooter="True" OnRowEditing = "GridViewEmply_RowEdit" OnRowCancelingEdit = "GridViewEmply_RowCancelingEdit"OnRowUpdating = "GridViewEmply_RowUpdating" OnRowCommand = "GridViewEmply_RowCommand"OnPageIndexChanging="GridViewEmply_PageIndexChanging" AllowSorting="True" AutoGenerateColumns="False" AllowPaging="True" Visible="false"><Columns><asp:TemplateField HeaderText="DepartmentName"><ItemTemplate><asp:Label ID="LabelEmplyDeptName" Text='<%# Eval("DepartmentName") %>' runat="server"></asp:Label></ItemTemplate><FooterTemplate><asp:DropDownList ID="ddlDept" runat="server" ></asp:DropDo
I'm trying to submit values to a SharePoint list that contains text fields and lookup fields.ÃÂ I'm doing this with a WebServiceConnection and an XML file.ÃÂ When I execute the submit without the lookup field, it works perfectly.ÃÂ When I execute the submit with the lookup field it doesn't error out but my list is not updated.ÃÂ Can anyone help?