Iam trying to understand why my sqldatasource control bound to gridview will not return data while i have cascading dropdownlist coded in pageload and selected events respectively?
from which sqldatasource control stored procedure obtains its parameter values.
only when i select items from second dependent dropdown does the grid display data?
I want delete, edit, select items is in grid view i have to do in c# code it will reflect to database also
View 3 RepliesHave a GridView with a templated select button hidden and using
e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .
When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .
I have this shopping cart that i have created, It is nearly done. The only thing that is bugging me is that i can only add one item to the cart. This was working when i was using a dropdown list, now that I have added a gridview instead, it only adds one item.
Below is my code.
[Code]....
I believe the problem lies in one of these lines here
I need to know how can I select a gridview row based on a query string data. In my case, the query string will contain the id that exist in the Table related to that grid. Is there a way to do this from the code behind? In other words, if I click a link with that specific query string, can I open the page and tell my grid to select a specific row based on the table row id?
View 1 RepliesI have a Gridview that show the values from mysql database .Can U tell me whn I click on linkbutton on grid view then Display the pop Box nd Data show in textboxes in pop box
id 01
Name GD
Ph 09582901670
Im coding in VB Im looking to transfer data from a gridview to a table. In the grid view i have enabled Selection, and on the code behind, as i need help getting started selecting the attributes adding it to a table. The grid is being populated from a table however i would like to take the information selected and store it in another table, which will have some more attributes. i have found a way which will add the row by an sql query from one table to another however i would like to give the user the option to select and add data to the table.
And i was thinking i could use this SQL query in the code behind but im not sure how to add it to the code behind of the select.
[Code]....
I am experimenting with 3 dropdowns bound to 3 different datasources. I want the contents in each dropdown depending on what is selected from the above dropdown and the datasource queries reflect this.
<asp:DropDownList ID="DropDownList_CostCentres" runat="server" Height="16px"
Width="138px" DataSourceID="CostCentreDataSource" DataTextField="CostCentre"
DataValueField="CostCentreID">
</asp:DropDownList>
<asp:SqlDataSource ID="CostCentreDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [CostCentreID], [CostCentre] FROM [CostCentres]">
</asp:SqlDataSource>
<br />
<br />
<asp:Label ID="Label2" runat="server" Text="Manager:" Font-Bold="True"></asp:Label>
<br />
<asp:DropDownList ID="DropDownList_Managers" runat="server" Height="16px"
Width="138px" DataSourceID="ManagerDataSource" DataTextField="EmployeeName"
DataValueField="EmployeeID">
</asp:DropDownList>
<asp:SqlDataSource ID="ManagerDataSource" runat="server"
ConnectionString="<%$ ConnectionStrings:corkABCConnectionString %>"
SelectCommand="SELECT [EmployeeID], [EmployeeName] FROM [Employees] WHERE ([CostCentre] = @CostCentre)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList_CostCentres" Name="CostCentre"
PropertyName="SelectedValue" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
However, the second dropdown does not load with the relevant data when I select a value from the first dropdown (stays blank). Must I still provide an event handler and how do I combine this with the sqldatasource?
how can i get selected checkbox item from grid view if the user click on the buttion , i tryied this but i dont know how to get the values from columns.
my columns are Id,FirstName.the function called from the buttion not from the gridview.
my code is:
[Code]....
the secound one, when i am trying to insert a new values to db and the new values get id automaticly by sqlserves 2005,how can i get this id because i want to save in other table to.
Actually I and doing my college Project and I have some Problem.I have 3 sections in my web page:1. The Search Part, which search a product by its name or Id.2. Result Part, which is a grid view showing Product ID,Product name ,its stock and Price.3. Billing Part, where The bill will be created which contains Sr.no. ,Product Id, Product name, Qty,Price,Total Price as attributes.Now I want that if any one search the product then result is shown in result part and then from the list of the products i click a product and add it in the bill list.But I am not able to understand here how to access a data from the grid view i.e. accessing Product Id,Product name, Price and add it to bill.
View 5 RepliesI have the Grid with Check box. here i want the Total of checked rows "CheckAmount".checkamount is one column in the grid i am able to getting the Total in single page(grid page=1). i am not able to getting the total of "CheckAmount" in multiple pages like (Grid Page=1 and Page=2 ) when i go to the second page i am not getting the 1st page Total.
View 3 Repliesi want to change , the displaying items in a grid view and on the way the text value of a lable at the same click on a link ... ? it means that i need the connectionstring or somthing in the properties to change with the link click
View 5 Repliesi need to select multiple items in a dropdownlist. This is my code,
<asp:DropDownList ID="ddllocation" runat="server" Width="80px">
<asp:ListItem>Chennai</asp:ListItem>
<asp:ListItem>Madurai</asp:ListItem>
<asp:ListItem>Coimbatore</asp:ListItem>
<asp:ListItem>Nilgiris</asp:ListItem>
<asp:ListItem>Palaghat</asp:ListItem>
</asp:DropDownList>
How can i add tat option.
I want to select the multiple items in the listbox.....for eg in my listbox there are five items
apple,pear,lotus,red,blue.on button click i want to select two items from the listbox.
How to do....
I'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 have two questions concerned with the GridView Data Control:1) I have displayed the data in four different columns in the GridView. My requirement is when I click anywhere within a row, its data should be retrieved. I can retrieve that data myself but don't knowhow to select a row in Grid view.I don't have to use the Select button here to select a particular row.2) I have a checkbox list. I want to retrieve the 'names' of the columns from a table and add these names of the Check Box list.How do we get the names of columns instead of data from a table?
View 6 RepliesI have a number of dropdown lists which are populated from a database. They load depending on what the previous dropdown selection was so for example if the system was car based and I had chosen Ford then the next dropdown list would populate all cars made only by Ford. What I'm wanting to do is add a select all to one of the dropdown lists. Does anyone know how this would be done?
View 1 RepliesI have a DropDownList inside the EditTemplateItem (if the user clicks edit) in a GridView.The DropDownList receives all available rows from the database. My problem is,if the user clicks Edit in the GridView to edit a row and opens the DropDownList Box the original item is not selected but the first one.That means the items are sorted. Have someone an idea how I can solve this issue that the right item / the original is selected if I change to edit mode of the grid view?
View 2 RepliesIn a gridview i am having two dropdownlist.in page load first dropdown will be populated and when an item is selected with in that based on dat selection i need to bind second drop down list.My problem is that selectedindexchaged event is not firing for first dropdown.The codings i used is below
aspx
************
<asp:GridView ID="gridview1" runat="server" AutoGenerateColumns="false"
onrowcommand="gridview1_RowCommand"
>
[code]...
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 want to select the row of telerik radgrid and get the value of column 1For thi can't use select or deselect columns, Here i want to select row by clicking only.here I also require code to get the value of column 1 of selected row
View 4 RepliesI am using a gridview where there are 6 cols and the last col consist of checkboxes. I wrote a code such that all the checkboxes in the col are selected or deselected at once by clicking the header checkbox. Now the issue is since I am using paging for the Gridview, once I select the checkboxes in the last col and go for the next page and come back to the previous page the checkboxes are deselected. I want to keep the checkboxes selected even after pagination.
View 1 RepliesI have a date list in DropDown and there is no blank item in it. Dropdown item seems to be following:
01-02-2010
02-02-2010
03-02-2010
04-02-2010
DropDown is bounded by sqlDataSource.
If 04-02-2010 is the last date for today then I want to display 04-02-2010 by default in the dropdown if the page load.
We are updating data on daily basis. So on next day the date will be 05-02-2010 so when the data updated then 05-02-2010 should be shown iby default in the dropdown.
On my website, registered users can make a profile about themselves suchas name, Favoirite color, hobbies, etcI have a DataTable called User which hold this information.also there are other datatables for Hobbies and Colors which list all possible options.To let the user update their choices I have a FormView in Edit mode on the aspx page whichis binded to the UserTable with a GetProfileByUserId Method and objectdatasource.
Within the formview, i have added drop down lists that are binded to the hobbies and Colors tables so they can edit their previous selection.On clicking Uodate update formview calls an Update Method that adds new selections to the User databaseNow I have two questionsIs it possible to show in the dropdown list the selected value that the User has already made?If the user only changes hobbies and not colors when they click update will a null value be passed into the data table for colors that replaces their previous selection?
how to write a code to search the data and display it in the grid view when a search button is clicked ..
View 2 Replies