There are 2 DropDown one is "Category" other is "sub_category"
I want to show data in "sub_category" DropDown according to "category" Dropdown selected value.
But when "Category=C1" data should bind in DropDown from Database Table1 and when "Category=C2" or "Category=C3" data should bind in DropDown from Database Table2.
How to achieve this.
i want to bind gridview from different tables and as shown in following format only
Column1
Column2
Column3
Column4
Column5
Column6
Column7
Column8
i m trying to bind my both grid with two tables which are in dataset i m trying but when i m binding my gridview it's always binding the second table see code
[Code]....
i already tried to bind both the gv1 and gv2 they both are displaying same table i.e department
Is there any way to bind data to listview using tables?
Lest say I'd like to do more less something like this:
[Code]....
In vs2008 and sql2005, I want to edit gridview..
In edit template I want a dropdownlist that must show that row's cell's value as the first value and remaing values should come down in the dropdown.
Is it possible to bind two separated datasources to one dropdown list such that they are both alphabetically sorted and seprated by some sort of line. I know there is a way to insert elemets manually, but I'm not sure of the 2 separate datasources. I've serached this forum and while there were several posts none of them offered any workable solution.
View 5 RepliesI have a GridView contain ClientID, ClientName, CompanyID columns.
1. I want to display CompanyName by Company ID
2. In Edit Mode I want to show company Names in DropDown and by chaging dropdown Bind the value. I am displaying DropDown data with a separete datasource.
I have the following structure 3 Dropdown Boxes, the 2nd and 3rd dependant on the 1st and when I change the first combo the pages refreshes with error I am assuming it's happening when posting back. I have nothing in my code behind file for this page so far.
Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
This is a very Basic application that I am creating using Visual Basic and ASP.Net 3.5. Am using a SQL Datasource have searched for this error some of the answers seem extremely complex and I can't figure them out, surely a simple tasks like this has to be easy to bind back to the database from several drop down lists.
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 have "Testdtabse" it's consists of the Table like aaa,bbb,ccc,ddd,eee etc.. I want to bind that table names in to My droipdown list box..
View 5 RepliesHow to bind dropdown list in Gridview(without using asp.listitem)
View 4 RepliesI am attempting to bind data from a dropdown list that was populated from another datasourceID. I've bolded what I believe is relevant to this issue in the code below. But basicly its binding the proper county on the pull down menu but when I hit form submit it dosnt postback that info instead its null.
[code]....
I have created an asp.net customizable gridview where user will be able to add and delete data. Now I face some proplem with this gridview. now I want to add a dropdown list (which is dynamically bind with database) inside the grid. I created code and it bind well. when the page is post back previous selected dropdown list value lose and set to selectedIndex=0; For this reason I used if(!page.Ispostback) and put the dropdown binding code inside this. Here I faced a problem. The problem is when I want to add data inside grid the dropdownlist missin bind. How can I overcome this problem? For your kind observation I given entire code below:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellPadding="4" ForeColor="#333333" GridLines="None"
onrowdeleting="GridView1_RowDeleting"
onrowdatabound="GridView1_RowDataBound">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField HeaderText="SL">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("RowNumber") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("RowNumber") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Material">
<ItemTemplate>
<asp:DropDownList ID="drpMaterial" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Quantity">
<ItemTemplate>
<asp:TextBox ID="txtQuantity" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtQuantity" ErrorMessage="Required Field Missing">*</asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>...............................
I have dropdown and I have to bind that dropdown on the basis of user login so that when the page load the drop down should show only one item on the basis of user login and i may have use that dropdown item as a search parameter.I have a objectdatasource named TblFltReg having one of the fields named "Owner" which is the SectionId.
There is a table named TblSections having "SectionId" and "Description".User can be selected in a Session variable.I have another table "Users" having "UserName", "UProfile", "SectionId".Actually I dont know how can I get SectionId from Users table into Session variable.So I have two tasks: one to get SectionId into Session Variable and another is to show dropdown item on the basis of User login.Hope you understand.
How can I perform that task?
I would like bind grid view with 2 different tables that has no relation.
View 2 Repliesi will use advanced control like gridview or schedule , and the data that is supposed to be bound to this control is : data from set of tables in my database.not a single table.
what is the best form for this data?
what i thought about at first is:
stored procedure ,contains my logic (and i wanna to ask here about what is the best performance also)use temporary table or joins or ... etc.
what are the possible solutions and more performance rather than stored procedure( as this is a web application many users will use it).
I want to create a dropdown of Vendors. I have a Vendors table in my DB, containing a VendorID and a CompanyID. The Company table contains a CompanyID and a Name.
I would like to have a dropdown with items that have the VendorID as the value and the Company Name as the text. But I don't know how to get the Name field from the related table to put in the dropdown, so I have the VendorID as the value and text. Here's what I have right now.
I'm passing in a model that contains this:
public IEnumerable<Vendor> Vendors { get; set; }
In my controller, I'm setting the value of Vendors like this:
MyDBEntities _entities = new MyDBEntities();
Vendors = _entities.Vendors;
Here is my dropdown list on the page:
<%= Html.DropDownListFor(m => m.VendorId, new SelectList(Model.Vendors, "VendorID", "VendorID"), "- Select a Vendor -")%>
I thought I could create a custom function - GetVendorsForDropdown - that would return only the data I needed, and changing my model to contain IEnumerable<Something>. But I don't know what the return type should be.
how to bind selected values from two tables to gridview data source, that two tables are from two databases. i created a view by using these two.But error is getting with this query,that is invalid object derivdtbl_1.Expr1. how to fix this?
SELECT dbo.Station_Channel.St_id, dbo.Station_Channel.lid, dbo.Station_Channel.Edit, dbo.Station_Channel.lChannelName, dbo.Station_Channel.lShort, dbo.Station_Channel.lPosition, dbo.Station_Channel.lTransformData, dbo.Station_Channel.lUnits, dbo.Station_Channel.lDecimalPts,
dbo.Station_Channel.parameter, dbo.Station_Channel.function_value, derivdtbl_1.Expr1
FROM dbo.Station_Channel CROSS JOIN
(SELECT MAX(Fecha) AS Expr1 FROM MeteoStation.dbo.Datos) AS derivdtbl_1
WHERE (dbo.Station_Channel.Edit = 1)
i am really confuse about the html dropdown helper. i cant reli find one info which describe clearly about every overload and how to use them.currently i gone through a problem which i spent one day and still cant resolve it, really hope can get the help here since i need to make tis work for my final year project..i have a food table, and a foodtype table. each food will have a type, so the FoodTypeID is the FK for Food table.i want to have a create and edit page for Food. on the page, i want to provide a dropdownlist for user to select the food typethe FoodTypeName column that store the food type description is at the FoodType table, so i need to get the value of FoodTypeID based on user selection on the dropdown.I had tried for hourssss to do this bt i either get a compilation or cant save the new foodType selected in db
[Code]....
in fact, i not reli understand wat should be put inside the model => xxx and the dropdown helper overload, i am writing this based on the mvc tutorial
Suppose in .aspx page their is dropdown in which i want to bind two coloumn in that dropdown.for example :-
in database their two column of First_name ,Last_name .I want these two columns value come in a single dropdown using C#.
I declared my template as follows
<EditItemTemplate>
<asp:DropDownList ID="ddlYear" runat="server" DataSource='<%#GetYears() %>' DataTextField="year" DataValueField="year"></asp:DropDownList>
</EditItemTemplate>
I need to bind the data from the function i used GetYears()
I need the data for example name to be loaded in dropdown when i click on Edit of gridview is it the correct way or is there any best way to do this
i have dataset with two data tables inside
dt1
dt2
i want to bind data from both data table t gridview
for this how can i make join between two data tables inside dataset and retreive data
I have 10 tables in MSSQL I want to select some info from this tables and show on a webpage (formview maybe(based on user selection)). Also, Id like user to be able to EDIT this info, and it should go back to database.
The problem is that: the realtionships are pretty comprehensive. In sql management studio I saw awesome view creation, where u can drag and drop tables and select just the field u need, and it automatically do all joins for you.
View would work perfect for me, but i need to update database back. Maybe I can use linq classes?
I mean, its easy, but it takes a lot of time to do it by hand programatically. Is there some dragandgrop-like feature in visual studio?
what is the easiest way to bind multiple tables in one place with crud operations available?
sql datasource supports only 1 table at a time.
I Found on the web that we can use stored procedure? Do I need two stored procedures? for select and update? how we are going to bind update procedure with textobxes where user is going to edit info? Do you have some samples?
I have connected listview by using datasourceid that means by using "sqldatasource1" now i want to change value of listview at run time according to search so for that i am using datasource at codebehind. but it give an error
"listview have already bind with datasourceid you can not bind it with datasource"
what should i do for solving my requirement.
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 Replies