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 RepliesOnSelectedIndexChanged event for the dropdown is the fired.
I have set the autopost back value = "true", EnableViewState ="true" for page tag and gridview tag.
I'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 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'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 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 the gridview control with 2 dropdown list and 2 text boxes,When the textbox chnaged event happen 1 row will create and the dropdown back to initial values( its not retaining the selected values),I am binding the control after text changed method,Is there any properties needs to be set or any other way we can retain the values in postbacks?
View 4 RepliesI'm currently binding a simple grid and show. And a separate dropdown and show. Now I want to place dropdown in grid and bind also I will able to change value of dropdown and save.Problem in grid binding drop down not able to find datasource.my code as -
<asp:TemplateField HeaderText="REPORTING TO" Visible ="true" SortExpression="reporting_to">
<ItemTemplate>
<asp:Label ID="Lnk_ReportingTo" unat="server" text="<%# bind('reporting_to' ) %>" ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
//Binding grid
public void BindData()
{
//Calling To Dal From BLL LAYER
DataSet ds = musergroupBLL.GetUserGroup(0, UserFk, 0);
Grd_UserRole.DataSource = ds;
Grd_UserRole.DataBind();
}
For dropdown fill in page on .aspx
<asp:DropDownList ID="DDManager" runat="server" onselectedindexchanged="DDManager_SelectedIndexChanged"></asp:DropDownList>
On .cs
protected void FillDD()
{
DataSet ds = MUsrBll.GetUser(MUsrolEnt);
DDManager.DataSource = ds;
DDManager.DataTextField = "usr_id";
DDManager.DataValueField = "usr_PK";
DDManager.DataBind();
}
Till here every thing is workingfor simple grid.
<asp:TemplateField HeaderText="REPORTING TO" Visible ="true" SortExpression="reporting_to">
<ItemTemplate>
<asp:Label ID="Lnk_ReportingTo" unat="server" text="<%# bind('reporting_to' ) %>" ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Now changing above code from below aspx code for dropdown place in grid. But not getting how to call datasource and selected value in grid. Data source is same as FillDD()function above for dropdown.
<asp:TemplateField HeaderText="REPORTING TO" Visible ="true" SortExpression="reporting_to">
<ItemTemplate>
<asp:DropDownList ID="Lnk_ReportingTo111" SelectedValue='<%# bind('reporting_to' )%>' DataSource = "<%# bind('usr_PK' )%>" DataTextField = "usr_id" DataValueField = "usr_PK" runat="server" ></asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
i've created a webform with one gridview having connected with the database using datasource. i.e password database with three colomn .
now want to insert the custom dropdown button using server control for each column.
when i select the dropdown list the list should display the value as required.
e.g if i click the uname dropdownlist then it should show the list of names.
if i click on pwd dropdownlist then it should show the list of numbers.
if i select any one of the value in the dropdown list then it should insert into the
database.
can i get code on this type of question...?
I am new to this forum as well as Visual Studio and asp.
I am connecting to an access db using Visual Studio Express 2010.
I have a dropdownlistbox that pulls names from a database. When I select a name Gridview1 gets populated. Now I want to populate Gridview2 with more data when I click 'Select' link in Gridview1 but it's not working.
I am passing name (string) and number (number) fields to the gridview2 based on the gridview1.selectedvalue property and am seeing:
Input string was not in a correct format.
I have an application which has a default.aspx page. Inside the default.aspx page i have several <asp:placeholders>. I also created several webcontrols.
<asp:PlaceHolder id="headerPlaceHolder" runat="server">
I would like to use the gridview paging feature and have built a gridview with a user control. The data source has lots of columns, so to make it easier I want to return a LIST<MyObject> and just pass <Myobject> into the user control rather than all the data elements. Not sure how I access the object of the data source to bind to the control. Assume it would be during ondatarowbound.
Also, my guess is there is a better way to do this than gridview. I'd take either solution that allows me to have easy paging and pass the complete object into the user control
I am using lable control in itemtemplate tage in templatefield tag of gridview control for showing a field of my database .
I want if the lenght of string data is higher than 100 character the lable control doset show all of it ,
How can i set the value of literal control inside itemtemplate control of gridview from code behind ?(i am using vb.net)
View 1 Repliesi have a gridview control i added checkbox contrl dynamically but i am not getiing the reference of checkbox in button clilck event here is my code Gridvew
[Code]....
.vb code
[Code]....
The width of the gridview control got increased in the browser, Because of that I got Horizontal Scroll. I don't want to get Horizontal scroll in the browser.
Below is the code .
<table align="center" width="100%" style="table-layout:fixed;">
<tr>
<td style="width: 115px">
OR</td>
[Code].....
In my scenerio, i've a dropdownlistbox by which i want to filter, a textbox for the text to filter and two textbox for specifying from and to date.
A gridview control for displaying the filtered data and a sqldatasource control and a commandbutton called search.
The following code is used to filter the data in database and it works properly. But when i click on edit in gridview, the gridview displays no records and again when i click on search button the data is displayed on the gridview displayed with the selected row in editmode.
protected void btnSearch_Click(object sender, EventArgs e)
{
string query;[code]....
I have a grid view control button (edit mode) that I would like to use with a modal popup message.
The button was originally designed to open a panel with a detailsView control.
So could I grview Button -> modal popup with another panel (click on a ok button here) -> detailsview panel.
Here is the code I tried :
[Code]....
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]....
How 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.
I'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 Replies