I have a gridview that is loaded with data from a dataset and when editing a row, i need to have a drop down list populated with another dataset with the appropriate information. I am trying to implement this on the Row_Editing event. Here's my ASP and VB codebehind for this page.
ASP.NET Code
[Code]....
VB Codebehind
[Code]....
on my aspx I have the below DDL
<asp:DropDownList ID="ColorDDL" runat="server" DataSourceID="ColorObj"
DataTextField="Size" DataValueField="BustId" Width="150px"
AppendDataBoundItems="True">
<asp:ListItem Value="-1">(Optional)</asp:ListItem>
</asp:DropDownList>
If the user does not select an item I get an exception when i call the ObjectDataSource Method and DAL as below to insert into database
ProfileObj.InsertParameters["ColorId"].DefaultValue = ColorDDL.SelectedValue.ToString();
What I want to do is insert a database NULL instead.
I am using DropDownlist to validate culture as follows. <asp:DDL ID="ddlculture" runat ="server" /> for this ddlculture data is comming from sql database like this
dim dt as datatable
dim dr as datarow
dr(0) = ""
dr(1) ="--select culture"
dt.Rows.InsertAt(dr, 0)
ddlculture.DataTextField = "CultureName"
ddlculture.DataValueField = "Culture"
ddlculture.DataSource = dt
ddlculture.DataBind()
everything is ok... but i am trying to validate it using Required Field Validator or compare validator or javascript. it is not validating. what is the problem
how to create Hierarchy Drop Downlist
View 8 RepliesI have a dropdown list. This is a bound to a column in Table which has around 200 entires.Now when a user clicks on the drop down list I want him to see not more than 10 rows. The rest he should navigate by using scroll bars.
View 5 Repliesif there is a way upon clicking on a hyper link to set drop downlist to visible in code behind or asp?
<asp:HyperLink ID="HyperLink2" runat="server">View More Workout Programs »</asp:HyperLink>
when i just click on the DropDownListBox then it populates the list of items.
when i move on the on of item then color of that item changes to blue i want to assignthe tooltip for this perticular item.bcoz my text of listitem is too large which is greater than width of listbox.s there any event to capture the moved listitem
how to check performance of sql server query with load ,also wants to create load by any tolls like load runner,if any url for download load runner or any other tolls by which we can create load please give me some idea related to it.
View 1 RepliesI am attempting to add a drop down menu to a gridview once the user slects the "Edit" button for the gridview. I want the value, before the edit button is selected, to be the value in one table and once the "Edit" button is selected I want to show values from another table in a drop down menu so the user only has specific values to edit the selected row with.
2 tables:
table 1) tbl_FormalizeRawData - List of columns from a table inside a database
table 2) tbl_StandardColumns - list of standard column names for system tables.
I want the user to be able to specify which raw non standard columns corospond to the standardized system table columns.
example:
RawClientTable.MiscColumn1 = SystemTable.Member_First_Name
RawClientTable.MiscColumn2 = SystemTable.Member_Last_Name
my code for the gridview is as follows. I am looking to see what else I need to do in order to allow the gridview to be edited on the final column by a dropdown menu populated by a seperate table but display the item in the main table with all the non standard column names:
[Code]....
a boot in the rright direction. I attempted to go through the "Walkthrough: Displaying a Drop-Down List While Editing in the GridView Web Server Control" at the website[URL] as it was geared toward a drop down menu added to a gridview both using the same table.
Has anybody managed to incorporate drag and drop functionality between cells in a gridview or repeater?
View 2 RepliesI am trying to populate a drop down of gender inside gridview but on edit i never update the value any idea wht i am doing wrong?
[Code]....
I have a GridView that displays records from an Access database, and I want to filter the records using a selection from a drop-down list. The GridView populates on page load with all of the records. The drop-down list is populated at page load from a different table in the same database. The functionality of creating a new GridView filtered by the selection in the drop-down list is working. However, when a different page number is selected from the Pager of the GridView, the GridView "disappears," or isn't redrawn. The selected name remains selected in the drop-down list, but there are no GridView elements displayed. If I select another item in the drop-down list, I get a new GridView with the correct records, but then choosing a different page results in no GridView. I'm guessing there's something wrong with my OnPageIndexChanging for the GridView event code, but I'm not sure what. My code is below (C#, ASP.NET 2.0):
using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
[Code]....
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
The above error occurs with gridview control , when used with template field columns with item template / and edit templates etc.
updating a row within gridview, at the time of loadiong it loads perfectly fined, but when tried to modify an existing row within gridview control, then it produces the error. Make sure the grid view control has to be a child control which manages the child table info with in a master form. to reproduce the above problem the grid view must be loading the child records info of a master within the masterform, meaning both master data and gridview data all to be managed in one single form.
I had to replace gridview control with datagrid and then it worked perfectly fine. I wasted almost 4 days of my time., there is no way we could figure out the problem. here is the full info of the problem.
Server Error in '/' Application.
Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.
Source Error:
[Code]....
Stack Trace:
[HttpException (0x80004005): Failed to load viewstate. The control tree into which viewstate is being loaded must match the control tree that was used to save viewstate during the previous request. For example, when adding controls dynamically, the controls added during a post-back must match the type and position of the controls added during the initial request.] System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +306 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +134 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +221 System.Web.UI.Page.LoadAllState() +312 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1661
Version Information: Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
I have a gridview that has a sqldatasource for it's data and it works well. I also have four dropdown lists that I need to have filter the data in the grid if they have a value selected. Here's my query:
[Code]....
What I need is if a user selects an Asset_Tag from a dropdown list the gridview should requery with the Asset_Tag as a parameter so only that record gets called up. Is there a way to do this in the selected indexchanged event? The same would hold true for the other DDLs. It seems like if I assigne the datasourse programmatically I lose the builtin sorting ability which isn't acceptible for this application.
I am trying to bind a GridView to a MDX query using VB.NET. The MDX query is valid, as I am able to run it and get the desired results using the Microsoft Analysis Services MDX Sample Application - but I just can't figure out how to go about connecting to it in the VB code for my aspx page and then binding it to a GridView. I have been searching for a while now and keep hitting dead ends, and to be honest, a lot of what I have found has been over my head.
how to run a simple MDX query from VB.NET and bind it to a GridView?
I'm just trying to run a simple updatepanel based on the pbs database, and I cant seem to get the Row_Updating function right. Here is my code:
[Code]....
and here is my C# code:
[Code]....
The textboxes appear just fine when I click Edit, but when I change some text and hit "Update" nothing happens. How can I be sure that the UPDATE query did anything? How can I output the text of that query?
In my page I would like to load multiple gridview one by one (with or without update panel). Once the page loads I want gridview one to start loading then the next one load and so for the other gridviews.
While the gridview is loading the gridview should show loading gif.
Is there a way to load a gridview with a button rather than on page load?
Right now I'm trying by making enabled = false and visibile = false and then changing them via c# on the button_click event but its not working out. I get the error:
Data keys must be specified on GridView 'GridView1' before the selected data keys can be retrieved. Use the DataKeyNames property to specify data keys.
The gridview is dependent on several dropdown boxes which is why it shouldnt load until the button is pressed.
I just using Drag and Drop Gridview with Jquery from aspsnippets...now, my question is :how to get the data from gridview destination ? I tried before, but seems the data is null.
View 1 RepliesI ran into this kind of situation many times without a nice solution. Binding a data source to a gridview and one of the column require nested query. Is it possible to have a callback function other than Eval()?
something like CallbackFunc(Eval("SomeField"));
I have a 3 text boxes. When i enter datas in and click the button it displays the gridview with filtered data. Now my problem is if there is no data in gridview it has to show "no data" so I used emptydatatext property.. The problem is, in the page load itself it shows "no data"
View 3 Repliesi m working on application that works similar to our email i.e when user enter his emailid and password his inbox should be display and those unread should be in bold and i have a treeview forinbox,sent,deleted .when inbox is selected the inbox detail should be displayed using gridview by default like in email the inbox data shoul be display on pageload so i have written databind code for grid view in page load event
if(!Ispostback)
{
gridview databind code
[code...
In one of my application, I have around 2000 records which i am displaying in gridview with normal paging.
Now I want to change this paging facility and would like to show a "more" button at the footer(just like [URL] has). The moment user clicks it, the next set of data will be retreived. This will go on till all the records are fetched.
I have a gridview that I want to bind the results of a query to it once a user selects a value from a drop down list.
The query selects the same row from the same table but selects different fields based on the drop down list value selected
I get to the query selection but it does not refresh that page with the populated gridview.
Here's the code behind code
protected void ddlQuantity_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection connection = null;
connection = new SqlConnection(ConfigurationManager.ConnectionStrings["PSI_DB_1ConnectionString"].ConnectionString.ToString());
connection.Open();
String nEstno = Request.QueryString["id"];
int id = Convert.ToInt32(Request.QueryString["id"]);
string SQLquery = "";
switch (int.Parse(ddlQuantity.Text))
{
case 1:
SQLquery = "Select Quan1"etc...;
break;
case 2:
SQLquery = "Select Quan2"etc...;
break;
case 3:
SQLquery = "Select Quan3"etc...;
break;
case 4:
SQLquery = "Select Quan4"etc...;
break;
case 5:
SQLquery = "Select Quan5"etc...;
break;
}
SqlCommand Cmd = new SqlCommand(SQLquery, connection);
SqlDataReader Dr = Cmd.ExecuteReader();
if (Dr.HasRows)
{
gvEstQty.DataBind();
}
Cmd.Dispose();
connection.Close();
connection.Dispose();
}
i want to add a column on to the end of the gridview that runs an sql query based on that ID i.e! select * from thistable where id = (0). so basicaly i want to bind a sql query as a column!! how would i do this?
View 5 Replies