I have two dropdownlists and one datagrid...I want to bring data from dropdownlists to grid.After selecting items in both the dropdownlists , I want to add the two selected items from dropdownlists in a datagrid row in two diffrent columns.And I want to add next selected data from the two dropdownlists to the second row of grid and so on.
View 5 RepliesHow to bring the data from database in the dropdownlist. C# coding i need.
View 4 Repliesi have the following gridview i would like the Vistidate column to be a link2) as you can see each patient can have multiple visit dates. when for example i click on 12/08/10 which is going to be a link i would like a new page to open and bring all the details from that visit into the various textboxes that i have such as DOB, telephone etc.
View 10 RepliesI have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
I have 2 grids gvParent & gvChild I would like to filter gvChild when a row is selected in gvParent the linking fields are contractNo
I added a column for selecting:
<asp:TemplateField ShowHeader="False">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Select"
OnClick="LinkButton1_Click" Text="Select"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
I know how to handle the filtering of the grid (create a criteria and set to rowfilter of the dataview) But, I dont know how to get the value of the column of the selected row.
I have Datagrid , i want to clcik on row and get data in textbox , but my textbox is FreeTextBox control,i tried to use javascript but work for asp.net control not working for freetext box control, how i can capture this code is sample code but it work for asp.net control but not working for my freetextbox
[Code]....
Simply put... I want to duplicate the example found at this link, in VB.net rather than C#.
[URL]
I would like the selectedvalue of the dropdown to display additional data base on its selection in multiple text boxes.
I have tried using the DropDownList OnSelectedIndexChanged property, within a DataGrid EditiItemTemplate, but I cannot retrieve data from the selection. (AutoPostBack is "True"). I can however use a button onclick event to fire a "prre-defined" selection value.
I have 2 datagrid (using .net 1.1). I need to access column of second grid ( i need to make a column of second grid as disabled) when i click "Cancel" link button in First Grid. How can this be done?
View 7 Repliesam having three dropdownlists on my webform. On the based on their selection I am retriving records from a databas table. my code for retrieving records as follows.when I didnt select ant dropdownlist ans click the search button then it featch all records. but when i select an option from suppose i select from ddlDivision, even there is many records related to selected Division but it shows sorry no record found.
View 4 RepliesI have a FormView in InsertItem that contains one DropDownList linked to a Table Datasource to display ItemCodes. In that "lookup" table I also have a Retail and Cost field.When the user selects the item from the drop down, how can I have these to field carry over into my new record that is being inserted. The new record also has a Retail and Cost field that are TextBoxes.Basically I am populating the new fields with the default values from the DropDownList.
View 1 Replies I need to filter data in a View using three dropdownlists that are populated independently of one another. The items in the second ddl are not based on the items in the first, etc. Each ddl is populated using its own sql statement. I want to be able to use each of these dropdownlists independently of the other two, but I want the data that is returned to be based on the values already in the other dropdownlists when I make a selection change.
For example: DDL1 is populated with Horsepower values from its own SQL statement.
DDL2 is populated with Gallons per Minute from its own SQL statement, unrelated to what is chosen in DDL1.
DDL3 is populated with Diameter values from its own SQL statement, unrelated to either of the other DDLs.
I want to be able to make a selection from any of the DDLs and filter data based on the selection, and whatever the current value is for the other two DDLs.
I'm coding in C# and I think I may need to create a delegate and an event to listen for when the SelectedIndexChanged event fires on any of the DDLs. This is slightly more complicated than anything I've coded up to this point, I'm a beginner, and I'm not even sure I'm aiming in the right direction for a solution.
I want to filter my gridview using two parameters that come from Dropdownlists. I bind these drops with two linq queries and next I would like to filter my gridview with query that has two parameters that comes from selected values from those drops. Everything is inserted in UpdatePanel. Here is my code:
asp:UpdatePanel
ID="UpdatePanel1"
runat="server"
>
[Code]....
I don't know how to get selectedvalues from dropdownlist and pass them to Bind() function which binds grid view
I have a gridview that is currently showing 20 lines per page. Each line has several fields in it, three of which are dropdownlists. These dropdownlists are populated with a SQLDataSource and then the selected value is bound to one of the gridview datalements.
The problem I'm running into is that the page is very slow to load. I believe this is because of the large dropdownlists (and possibly because there are roughly 60 of them, each of which is executing a SQL query to populate the list of available values). The file size that is being transmitted over the web is just over 1.25MB in size, again from the large amounts of data in the dropdownlists.
Is anyone aware of a technique by which I could only execute the query from the SQLDataSources that populate the dropdownlists' available values once and then reuse the results of that query to populate the relevant dropdowns? Ideally I would do this on the client side so it would also limit the amount of text being transmitted to the client browser.
I have two DropDownLists, and each one has a Control Parameter that references the other.
The idea is that if you select a value in either one of them, it restricts the possible values you can select in the other. And the user may select either one of them first.
Each one has an "All" option for selecting all values. (They are both used to restrict rows that populate a GridView).
This is all done using SQLDataSources.
The problem is that it doesn't seem to work at all. Both DropDownLists are empty, and the SQL that populates them never hits the SQL Server. But there is no error displayed.
If I have it going only one way, it does work, so I think the problem is the recursive nature of having them reference each other.
It would seem to be quite a common requirement, so its there any way of getting this to work?
I have a gridview with 4 dropdownlists and 1 label in each row. Suppose , text fields of each dropdownlists are a,b,c and value fields are 1,2,3 respectively.
In each row,label text is the sum of value fields of selected text fields of 4 dropdownlist.
For example,If selected text of 4 dropdownlists of a row are-b,a,b,c.
Then the label text of that row will be 8.(value field of b=2,a=1,c=3 , so b+a+b+c=8)
Whenever the selected text of any dropdownlist changes,corresponding label field also will change.
How can we do this in asp.net with C#?
I'm comfortable populating dropdownlists in a standard webform, but I seem to be having trouble populating them from within a gridview or listview.I know that I'll probably need to use the find control method, I've had a stab at it with the following:
[Code]....
The purpose of this is to allow someone to look at a bunch of records, and in a dropdownlist add an item to a group, but this "group" is in a separate table, so I want to take whatever value that select in the dropdown menu, lookup their user id, and add both bits of information to the other table, so it's technically not even editing, even though i suspect I'll need to use the edititem template?
Here is the case:
I use Visual Studio 2008 ASP.NET 3.5
I have a DetailsView control with several fields that is in insert mode. Three of them are the source of my problems and headaches.
I have three DropDownLists in template fields.
The first one is OK, bound to it's designated field in table1 in the database. The next two however have to change their bound tables according to the SelectedValue.
So far, I've managed to get it working, BUT when I insert the data I've entered, these two DropDownLists are not entered into the database.
DropDownList3 - the list that controls the other two DDLs
DropDownList4 and DropDownList5 - the list that need to change their items accordingly
DropDownList3 has six different values, so I have 6 tables for each of the other two DDLs
However I have only tried with one to see if it would work, that's why the Sub seems incomplete.
Here is the relevant part of the code:
[Code]....
And the DropDownList3_SelectedIndexChanged sub:
[Code]....
If I leave SelectedValue='<%# Bind("shelves") %>' and SelectedValue='<%# Bind("type") %>' in the <asp:DropDownList> tag of the two DDLs that change values, I get an error when the first one does the postback.
The error is:
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control. This error, I spent a whole day looking through forums and knowledge bases, but I could find nothing that solves my problem. Maybe the problem is me, but my boss wants this done, despite it is not my area of expertise to write code.
On one of my pages I display a Gridview. This contains a list of questions generated by a SQLDataSource, with a dropdownlist on each row containing the answers for that question. The answer values can be different depending on the question, so I populate them in the RowDataBound event for the gridview, using question information.
As the list of questions is longer than the page I have placed the gridview within a Div which allows me to use scrollbars to navigate the gridview. I also use some methods to preserve the location of the last question answered - so that on answering a question, the gridview does not reset to show the first part of the gridview.
This works fine for IE7, which is what I have been using for the development, and which part of my customer base uses. However, the other part of my customer base uses IE6, which causes a problem.
When an IE6 user attempts to answer some questions, they run into issues. Should they scroll down the gridview, when they select a value from a dropdownlist (Effectively, when they answer a question), there is a postback and all of the visible (i.e. onscreen) dropdownlists appear to be cleared. However, on mousing over any of the dropdownlists, their value is then shown. On using either the scrollbar, or on using the mousewheel to scroll the gridview, all the dropdownlists are 'refreshed' and their values are shown.
At no point does the application appear to lose the data, it is just not showing it until there is a mouseover or the gridview is refreshed. Another odd aspect of this is that this does not apply to the first 5 rows of the Gridview. Any of these can be altered without there being this display issue. Should the gridview be scrolled enough to show some of the first 5 rows and some subsequent rows, only the subsequent rows will have this display issue.
I have tried various things to correct this - originally I called my retrievescrollposition method on the SelectedIndexChanged event of the dropdownlist, but have since moved it to Page_Load as the Else branch of if (!IsPostBack). I tried rebinding the DropDownlist in the SelectedIndexChanged event, but this only helped with the Question I was answering - the display of any other onscreen questions was still affected.
I had called the data from query to data table and now i have a gridview in which i am using one datalist and 2 text boxes and and reming coloumns are bounded iahve to assiaign them values which datatable have either null or any value.
View 2 RepliesI have got 2 Drop Down Lists on my Form and 1 GridView. I want GridView to display the data according to selection from the Drop Down Lists.
For Example, One Drop Down List contains Names and other contains Dates. Both the Drop Down Lists can post back. So if i select a name from 1st Drop Down list, the Grid View should show all the results according to that Name. Similarly if i select the Date from the other Drop Down List , the Grid View should show the results according to the dates. But i cant figure out as how to bind Grid View to respond to 2 Drop Down List.
BTW i am binding both the Drop Down Lists and the Grid View to the DataSource Objects, which is getting data from the database.
I am filling a gridview with data.
column 1 is a dropdownlist <ddlGrade>
column 2 is a checkbox <cbxNeverAttended> not visible
column 3 is a textbox <tbxLastDate> not visible
in the 'GridView_RowDataBound'
i determine if a ddlGrade value already exists and if so, make it selected in the dropdownlist
also, if the value of ddlGrade is a "U" I make cbxNeverAttended and tbxLastDate visible
However, if cbxNeverAttended or tbxLastDate are both empty strings (and ddlGrade has the value "U"), I want to disable all instances of ddlGrade in the gridview (essentially forcing the user to enter a value for cbxNeverAttended or tbxLastDate before moving on to enter another ddlGrade).
But I have been unable to figure out a way to accomplish this on the 'Gridview_RowDataBound',
I have 2 DropDownList and 1 button in admin.aspx page
1=DDLtradeO and 2=DDLclassO
users should select Item from both of them I use RequiredFieldValidator for both of them and when they click on button in HOuse_info Table it insert their data here when users select first item from DDLtradeO (that text is="State" )
{ DDLclassO.Enable=false}
below is code
<asp:DropDownList ID="DDLtradeO" runat="server" CssClass="DPCDDLs" AutoPostBack="true" OnSelectedIndexChanged="DDLtrade_SIC">
</asp:DropDownList>
and behind code
protected void DDLtrade_SIC(object sender, EventArgs e) {
if (DDLtrade.SelectedItem.Text != "State") {
BindTrade();
DDLclass.Enabled = true;
Rfv11.Visible = true;
} else {
DDLclass.Enabled = false;
Rfv11.Visible = false;
}
here RFV11 is RequiredFieldValidator for DDlclasso..problem is here when users select other item from DDltradeO and they select Item form DDLcalssO when they click on button it insert data into House_info table correctly but when they select "STATE" Item from DDLtradO (they can't select Item from DDlcalssO) when they click button this error occurrence Server Error in '/behtop website' Application.
String or binary data would be truncated. The statement has been terminated.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. Data. SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. Source Error:
Line 312:
Line 313:
Line 314: int result = Convert.ToInt32(_cmd.ExecuteScalar()); Line 315: _cn.Close();
Line 316: //LBLERROR.Text = _cmd.Parameters["@Success"].Value.ToString();
I think its depend to RequiredFieldValidator but I want if users select other Item from DDltrade they select Item from DDLcalssO. Server Error in '/behtop website' Application.
String or binary data would be truncated.The statement has been terminated. 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.Data.SqlClient.SqlException: String or binary data would be truncated. The statement has been terminated. Source Error:
Line 312:
Line 313:
Line 314: int result = Convert.ToInt32(_cmd.ExecuteScalar()); Line 315: _cn.Close();
Line 316: //LBLERROR.Text = _cmd.Parameters["@Success"].Value.ToString();
hope you guys are doing well! I have a question and no answer yet how to do it. Right now i can have 1 dropdownlist and when i press on my search button its show the result of the query the user ask
but how to do it with two seperates dropdownlist ? isnt it with inner join ? also if the value is null what to do ?
here is my sample little code for a sample search
[Code]....
I've got 3 SqlDataSource controls, and 2 dropdownlists and 1 detailsview on a page. The first SqlDataSource is associated with the first dropdownlist, and second SqlDataSource (which is filtered based upon the selection chosen in the first dropdownlist) is associated with the second dropdownlist and the third SqlDataSource (which is filtered both by the selection of the first dropdownlist and the second dropdownlist) is associated with the detailsview. The idea is the user selects something in the first dropdownlist, and it is supposed to update what is returned by the second SqlDataSource control and second dropdownlist, and that in turn is supposed to change what is returned in the third SqlDataSource control and it's associated detailsview. All of the dropdownlists have AutoPostback set to True.
View 11 RepliesI have a datagridview control that I'm using to display cache data to the end used on a web form. The issue that I'm having is that every time I re-run the application, and the cache data is re-generated... it loads duplicate data that's being displayed to the end user. I can't seem to figure out how to keep this from happening.
What I would like to have happen is that only unique data rows be returned and cached for the end user. Unless there are new data rows on the database that needs to be included in the cache data results...the previous data results should not be duplicated. I've tried to change a few properties on the datagridview control, but nothing seem to keep this from happening.
[code]....