I trying to change data on a map control on a dropdown selection that loops through vb and is supposed to refresh the control with the new selecctions. When I change the dropdown, the new recordset is generated but the control does not refresh with the new data, just flashes and shows the last results from the onload command.
[Code]....
I want to bind data from database to Dynamic Grid-view Control with textbox and dropdown using dataset.
I have successfully inserted data to database using this code but now i want to fetch inserted data to same grud view control. i have tried following code. but not getting ans.
SetInitialRow();
string ID = 101;
foreach (GridViewRow row in Gridview2.Rows) {
string str1 = "Select * from VendorInvoiceDetails where Invoice_ID='" + ID + "'";
DataSet ds1 = GEN.GetDataByQuery(str1);
[Code] ....
- i have two drop down lists- ddl_SelectClient, ddl_SelectApplication
- when a client is selected in ddl_SelectClient, i have to show the list of the clients applications in ddl_SelectApplication
- i have written the below code in the ddl_SelectClient_SelectedIndexChanged routine to do the same
- i am getting the error("Unable to evaluate expression because the code is optimized or a native frame is on top of the call stack") in the catch block when the ddl_SelectApplication gets binded
[Code]....
I have a dropdown list within a details view that allows me to set 1 or many categories to a perticular record(in this case a photo). The select command in this case only displays those catetegories that are not already attached to the selected photo.
all works well and as you select a category and add it to the database the category is removed from the dropdown list and is added to a gridview which shows all categories that photo is stored with.
My Problem is that when i delete the category from the gridview the dropdown list does not delete with said deleted item unless i do a "click in URL bar and press enter" to totally refresh the page.....
how to refresh the dropdown list in the details view after the gridview item has been deleted?
[code]....
I have managed to place a dropdown control iniside a gridview control. The dropdown does indeed populate in each row... Question: How is it possible for the system to correctly select the text in the dropdown based on the value of the field which is driven from the database? Is it to do with the selectedvalue?
View 7 RepliesI'm trying to setup a page that will utilize a dropdown list control inside of a grid view control using VS 2005 2.0 version. Everything that I can find online seems to only show the use of the dropdown list control using a data grid. I don't want to use a data grid because it doesn't have the functionality/ power as the grid view control. how I can incorporate a dropdown list control with the grid view control? Here is a copy of my code.
<asp:GridView ID="HardwareSetdv" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="AcctID"
DataSourceID="HardwareSetSqlDataSource">
<Columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="HardwareSetID" HeaderText="HardwareSetID"
InsertVisible="False" ReadOnly="True" SortExpression="HardwareSetID" />
<asp:BoundField DataField="AcctID" HeaderText="AcctID"
SortExpression="AcctID" />
<asp:BoundField DataField="PurchaseOrderID" HeaderText="PurchaseOrderID"
SortExpression="PurchaseOrderID" />
<asp:BoundField DataField="HardwareSetDesc" HeaderText="HardwareSetDesc"
SortExpression="HardwareSetDesc" />
<asp:BoundField DataField="Quanity" HeaderText="Quanity"
SortExpression="Quanity" />
<asp:BoundField DataField="ItemNum" HeaderText="ItemNum"
SortExpression="ItemNum" />
<asp:BoundField DataField="ItemDescription" HeaderText="ItemDescription"
SortExpression="ItemDescription" />
<asp:BoundField DataField="Finish" HeaderText="Finish"
SortExpression="Finish" />
<asp:BoundField DataField="Manufacture" HeaderText="Manufacture"
SortExpression="Manufacture" />
</Columns>
</asp:GridView>
I have an AJAX tab container with 2 panels within aspx page. Each panel hosts an ascx control. Each control contains GridView and FormView that are databound - 1st control to the parent table and 2nd - to the child. The 2nd control/tab contains standard DropDownList that is bound to the parent values so the user can select a parent to create "child" for. everything works fine except when the parent (on the 1st tab control) is created/updates the ObjectDataSource on the 2nd tab does not getting refreshed. Only after refreshing the hole page I can see the new "parent" value in the ddl on "child" page. I use strongly typed dataset. How I can programmatically refresh the DataSource? Simple rebinding didn't make a dent. Do I need to refresh page, the tab container, tab panel?
<asp:Content
ID="Content1"
ContentPlaceHolderID="ContentPlaceHolder1"
Runat="Server">
[Code]....
I have grid view control that includes a dropdown control in a template field.I wish to execute some code when the value is changed in the dropdown list. Can't figure out how to capture this event though?
View 5 RepliesI have a formview with an insert item template. I have added two dropdown controls that are databound to two different database tables to this insert template. However, when I click the 'InsertQuery' for the Accessdatasource neither of these controls are available as 'Parameter source options'.Out of interest, if I take these dropdown controls out of the formview and put them on the page they then become available to use.
View 1 RepliesI have a problem when I try to pass in paramaters for a report in my report viewer. I have set up the ObjectDataSource and set the paramaters for 3 text boxes that are on the page. The only way I have found to set the paramaters for the report is the user must fill in the paramaters and hit the refresh button on the Report Viewer toolbar ,but I would like to have the user click a asp.net button insted. Is there anyway to call the refresh method from codebehind?
View 1 RepliesI have a detailsview, template as follows:
[Code]....
Codebehind: creating dataset, getting data from sql with adaptor and filling into dataset object, then setting detailsview's datasource.
I add 2 button to above template to able to edit data at asp page, and added event handlers:buttons:
[Code]....
My question is, what to do inside the detailsview update event function to able to edit and update data. My method can be wrong too.
i have dataset containing multiple images in binary format,how i can use handler to display those images from dataset which i am having,without needing to pass id in query string to handler each time?
View 4 RepliesI've been given this existing web service [URL] and I need to use the GetQuoteDataSet method to display the dataset in a Grid View control on my aspx page, anyone got any clue as to how I could do this?
View 3 RepliesI'm currently working on a project and I want to make as much things as possible performing on client side - with as little loading as possible. The project consist of three "main" pages. On one page I use jQuery DataTable plugin which is working great. One page has tabs (using jQuery). I want to put datacontrol (repeater) on this site and when user selects one item in dropdown, data in repeater loads on client side, without performing the action on server.
View 4 RepliesHow to write code in vb.net to control the Dropdown which is inside FormView EditItemTemplate. FormView named "frmFaultsReg" DetailsView named "lstStatus" Actually what i want to do that there is a textbox inside FormView EditItemTemplate and ItemTemplate to insert Closing date. lstStatus has a value PENDING and CLOSED. If a user select CLOSED from lstStatus then the date textbox named "ClrDateTimeTextBox" should show current date time and to insert into database and if user again selects PENDING from lstStatus then the date textbox should show empty. I think the postback of lstStatus should work but lstStatus is inside the FormView thats why I am unable to hook it.
View 7 RepliesI am using a DetailsView Control and have a "MemberStatus" field.
When using the templates in edit mode, I am using a dropdownlist to change the member status.
e.g.
<asp:TemplateField HeaderText="Member status:" InsertVisible="False" SortExpression="MemberStatus">
<EditItemTemplate>
<asp:DropDownList ID="ddlMemberStatus" runat="server" DataSourceID="adsMemberStatus" CssClass="eitField" DataTextField="MemberStatus"
DataValueField="MemberStatusID" Width="120px" SelectedValue='<%# Bind("MemberStatusID") %>'>
</asp:DropDownList>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label6" runat="server" Text='<%# Bind("MemberStatus") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
What I would like to achieve is, if the MemberStatus is changed during edit mode, e.g. from "Active" to "Deceased"
I would like to enable certain fields e.g. txtBoxDateDeceased, and attach a RequiredFieldValidator for the textbox field.
I have a formview in which I have a dropdown list that displays a list of owners. In case the list does not have the correct owner for the user I have added functionality for them to add a new owner to the database table that populates the list. I did this by including a textbox and an Insert button in a panel. When the user clicks the new owner insert button I would like to re-databind the dropdown list so that they will see the owner they added and be able to select it.
When I add ddl_owners.databind to my button click code it gives me an error. "Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control."
I don't want to re-databind the entire formview because then it deletes all the information on the form that the user has already keyed in.
I am using grid view control with paging Like-:
protected
void grdUpdateColumn_RowCreated(object
sender, GridViewRowEventArgs
e)
{
if (e.Row.RowType ==
DataControlRowType.Pager)
{
DropDownList ddl
= new
DropDownList();
//adds variants of pager size
ddl.Items.Add(
"5"
);
ddl.Items.Add(
"10"
);
ddl.Items.Add(
"20"
);
ddl.Items.Add(
"50");
ddl.AutoPostBack = true;
//selects item due to the GridView current page size
ListItem
li = ddl.Items.FindByText(grdUpdateColumn.PageSize.ToString());
if (li !=
null
)
ddl.SelectedIndex = ddl.Items.IndexOf(li);
ddl.SelectedIndexChanged +=
new
EventHandler(ddl_SelectedIndexChanged);
//adds dropdownlist in the additional cell to the pager table
Table pagerTable = e.Row.FindControl("pagerTable")as
Table;
//e.Row.Cells[0].Controls[0] as Table;
TableCell cell =
new
TableCell
();
cell.Style[
"padding-left"] =
"15px"
;
cell.Controls.Add(
new
LiteralControl("Page
Size:"
));
}
protected
void ddl_SelectedIndexChanged(object
sender, EventArgs
e)
{
//changes page size
grdUpdateColumn.PageSize = int.Parse(((DropDownList)sender).SelectedValue);
ViewState["Index"]
= 1;
//binds data source
this.GetChangesRecord();
}
Grid view Like -:
<PagerTemplate>
<asp:Table
ID="pagerTable"
runat="server"><asp:TableRow>
</asp:TableRow>
It's working fine but problem is that if i select 10 and record from dropdown and record also has 10 then paging is not showing.
That's mean i select 10 from dropdown and record is 10 then dropdown also disable with numbers, suppose i need to select again 5 then i can't do this.
How can i refresh(Asych) the contents of my Datalist on the parent page from a data change in a page that is displayed in an iFrame on the parent page.
I have movie names with image in the data list that is on parent page.
there another page is openend in the parent pages in an iFrame control.
in that sub page i upload image and other data related to a new movie.
What i want is that when i submit that information in an iFrame page, the DataList should update(Asych) itself on the parent page showing new updated info.
the structure is like;
[code]...
OnSelectedIndexChanged event for the dropdown is the fired.
I have set the autopost back value = "true", EnableViewState ="true" for page tag and gridview tag.
i am created a user control(.ascx)
<span><asp:DropDownList ID="Drop_DocType" runat="server" DataTextField="DOCTYPE"DataValueField="DOCTYPE"/></span>
how to fill it rom database and where i put soure code
i have a dropdown with month names if the user has data for the month tht is selected then gridview displays the rows with day nos as per the month but if the gridview has no data for the same the dropdown or gridview via some event should call a insert procedure to insert data into the table for tht month with daynos ad rebind the gridview witht the rows just created
View 6 RepliesHow to refresh the xsd Typed DataSet when I change an id field from normal to autoincrement? I'd the INSERT statement to remove the 'id' field in its statement from files *.Designer.cs and *.xsd.
View 2 RepliesI'm trying to follow this article on cascading dropdown list in a GridView control in edit mode (except I'm using C#) [URL] I keep getting this error message "ProjectID is neither a DataColumn nor a DataRelation for table DefaultView."
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if ((e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit)
{
DataRowView dv = (DataRowView)e.Row.DataItem;
//// Preselect correct value in Projects list
DropDownList listProjects = (DropDownList)e.Row.FindControl("DropDownList1");
listProjects.SelectedValue = dv["ProjectID"].ToString(); // *****************this is where I get the error *********
// Databind list of categories in dependent drop-down list
DropDownList listCategories = (DropDownList)e.Row.FindControl("DropDownList2");
SqlDataSource dsc = (SqlDataSource)e.Row.FindControl("sdsDDL2");
dsc.SelectParameters["ProjectName"].DefaultValue = dv["ProjectName"].ToString();
listCategories.DataBind();
listCategories.SelectedValue =(dv["CategoryID"].ToString());
}
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>" SelectCommand="SELECT
TE.TimeEntryID,
P.ProjectName,
CAT.CategoryName,
TE.TimeEntryDescription,
TE.TimeEntryDuration,
TE.TimeEntryDate
FROM dbo.aspnet_starterkits_TimeEntry TE inner join
dbo.aspnet_starterkits_ProjectCategories CAT on
TE.CategoryID=CAT.CategoryID inner join
dbo.aspnet_starterkits_Projects P on
CAT.ProjectID=P.ProjectID
Where TimeEntryUserID=(SELECT UserId FROM dbo.aspnet_Users WHERE
UserName=@UserName) AND
TE.TimeEntryDate=@WeekEnding
" OldValuesParameterFormatString="original_{0}" UpdateCommand="UPDATE dbo.aspnet_starterkits_TimeEntry
SET
TimeEntryDescription=@TimeEntryDescription,
TimeEntryDuration=@TimeEntryDuration,
TimeEntryDate=@TimeEntryDate
WHERE
TimeEntryID=@original_TimeEntryID">
<SelectParameters>
<asp:ControlParameter ControlID="UserList" Name="UserName"
PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="WeekEnding2" Name="WeekEnding"
PropertyName="Text" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="TimeEntryDescription" />
<asp:Parameter Name="TimeEntryDuration" />
<asp:Parameter Name="TimeEntryDate" />
<asp:Parameter Name="original_TimeEntryID" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" BorderWidth="0px"
BorderStyle="None" Width="100%" CellPadding="2" PageSize="25"
DataKeyNames="TimeEntryID" onrowdatabound="GridView1_RowDataBound"
onrowupdating="GridView1_RowUpdating" >
<Columns>
<%--<asp:CommandField ShowEditButton="True" />--%>
<asp:BoundField DataField="TimeEntryID" HeaderText="ID"
SortExpression="TimeEntryID" InsertVisible="False" ReadOnly="True"
ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:TemplateField HeaderText="Project" SortExpression="ProjectName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList1"
runat="server"
DataSourceID="sdsDdlProjectsEdit"
DataTextField="ProjectName"
DataValueField="ProjectID"
AutoPostBack="True"
onselectedindexchanged="DropDownList1_SelectedIndexChanged">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDdlProjectsEdit"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT ProjectID,ProjectName FROM dbo.aspnet_starterkits_Projects">
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("ProjectName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Category" SortExpression="CategoryName">
<EditItemTemplate>
<asp:DropDownList
ID="DropDownList2"
runat="server"
DataSourceID="sdsDDL2"
DataTextField="CategoryName"
DataValueField="CategoryID">
</asp:DropDownList>
<asp:SqlDataSource
ID="sdsDDL2"
runat="server"
ConnectionString="<%$ ConnectionStrings:ttuser %>"
SelectCommand="SELECT CategoryID,CategoryName FROM dbo.aspnet_starterkits_ProjectCategories WHERE ProjectID=@ProjectID">
<SelectParameters>
<asp:Parameter Name="ProjectID" />
</SelectParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryName") %>'></asp:Label>
</ItemTemplate>
<ItemStyle HorizontalAlign="Center" />
</asp:TemplateField>
<asp:BoundField DataField="TimeEntryDescription" HeaderText="Description"
SortExpression="TimeEntryDescription" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField DataField="TimeEntryDuration" HeaderText="Hours"
SortExpression="TimeEntryDuration" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:BoundField ApplyFormatInEditMode="True" DataField="TimeEntryDate"
DataFormatString="{0:d}" HeaderText="Week Ending"
SortExpression="TimeEntryDate" ItemStyle-HorizontalAlign="Center" >
<ItemStyle HorizontalAlign="Center"></ItemStyle>
</asp:BoundField>
<asp:CommandField ShowEditButton="True" HeaderText="Edit" ButtonType="Image" EditImageUrl="images/icon-edit.gif"
UpdateImageUrl="images/icon-save.gif" CancelImageUrl="images/icon-cancel.gif" />
</Columns>
</asp:GridView>
I have a gridview where i have two fields. one is product and second is sub category.
I need to do 2 things.
1. I need to populate the two combos from the database. But depending what is selected in dropdown 1 this will determine what needs to be populated in drop down 2?
how can i achieve this?