i wants to retrive data from database to dropdownlist, which is the best way to useits SqlDataSource or we can right strored procedure and retrive to dropdownlist. looking forward ur valuable
View 4 Replies
I am trying to retrieve a specific record from the data which is displayed in gridview. I am using the selectedindexchanged event for this. whenever I select the 'select' link in the gridview control that perticular record should be displayed in the textboxes. This is my code:
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
try
[code]...
[Code]....
using asp.net with c#
iam retreving image from database but i want to display in image1.imageurl but it is not displaying image can you correct my code
I my website i have 2 dopdownlost i want when i change the value of one.. The other one loads data depending on the first one value
the both of the dropdownlists is in ajax update panal and i do have script manager
i used this code but not working
protected void floor_ddl0_SelectedIndexChanged(object sender, EventArgs e)
{
floor_ddl1.DataBind();
}
i have 2 DDL in my page that when users select item from ddldistric1 item in ddlcity1 will change these are my code
protected void DDLcity1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrictC();
}
private void BindDistrictC()
[code]...
I am having two dropdownlist in my project,one dropdownlist for empid, another dropdownlist for month, if the user select the empid, the values are retrieved in the textbox.
In the second dropdownlist, if the user select the month in the dropdownlist it will display the leave details, its all working fine, if the user again select the first dropdownlist that means empid, I want to show the second dropdownlist as select month, how can do this.....
I have a table and 7 column name.
I bind the 7 column name in one dropdownlist.
Now the problem is,how do I extract the data value in a dropdownlist?
For example,
Dropdownlist contain 7 column name
-subject_name
-subject_code
-venue
-time
-seat_no
-admission_no
-subject_id
when I click the subject_name,I want it to appear in a gridview
Example
Math|9.00-10.00|Hall|18|09090J|...
Below is my current codes which I have a problem.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "SELECT '" + dd_list.SelectedValue+ "' FROM examtimetable ";
adapSel = new SqlDataAdapter(mySQL, conn);
conn.Open();
DataSet dsSel = new DataSet();
adapSel.Fill(dsSel);
GridView1.DataSource = dsSel;
GridView1.DataBind();
conn.Close();
}
Previously I have bind 7 column name in my dropdownlist
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack == false)
{
SqlConnection conn = new SqlConnection("Data Source= EN\SQLEXPRESS;" + "Initial Catalog=ms;Integrated Security=SSPI");
SqlCommand sqlCmd = new SqlCommand("select column_name from information_schema.columns where table_name='examtimetable' and COLUMN_NAME not like '%ID'", conn);
conn.Open();
SqlDataReader ds;
ds = sqlCmd.ExecuteReader();
dd_list.Items.Clear();
dd_list.DataSource = ds;
dd_list.DataTextField = "Column_Name";
dd_list.DataValueField = "Column_Name";
dd_list.DataBind();
dd_list.Items.Insert(0, "Select Option");
ds.Close();
conn.Close();
}
}
Currently,below is my code.
protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection("Data Source= E\SQLEXPRESS;" + "Initial Catalog=k;Integrated Security=SSPI");
SqlDataAdapter adapSel;
string mySQL = "select column_name from information_schema.columns where table_name='examtimetable' '" + dd_list + "'";....
I receive an error "Incorrect syntax near 'System.Web.UI.WebControls.DropDownList'."
I want to making another dropdownlist visible=false when clicking in dropdownlist on the same detailsview?
View 4 RepliesI am using 3 dropdown list in a gridview and the values for the dropdownlist is dynamic from database.based on first dropdown list selected value the values must fill to second dropdown and based on second dropdownlist selected value then items should load to 3rd dropdown and same for 4th dropdown list. Here if i select age,gender,sex, fist name, last name from the template name Human. The first drop down only populate the fields like Age,gender,Sex and so on., When the second dropdown list populate from the fields corresponding Template name Human, Finance, and so on.
View 3 RepliesUsing dropdown in gridview and bind the values in dropdown then based on dropdown display the value in another column.
View 1 RepliesI am having a 2 dropdown list, in the first dropdown I have 3company names,for each company I am having separate tables,every table have a empcode, if the user select the company name in the 1st dropdownlist, as per company selected the 2nd dropdownlist it will fill the list of employee codes as per the selection..
View 1 RepliesI want to bind data(For ex: Employee name, Employee ID from Employee) to a dropdownlist and the data should be displayed in dropdownlist as two columns. I don't want to separate this columns by using any special characters like | or '-'. I want to display them as different columns in a dropdownlist.
How can i achieve this using .net and the data i need to retrieve using SQL server 2008.
I am having a problem with disabling DropDownList based on the chice of 1st DropDownList, there is no post back occuring, and it is a template based web app here is the current code:
<script type="text/javascript">
$(function() { var dropDownList1 = $('#<%= ddlUserType.ClientID %>');
var dropDownList2 = $('#<%= ddlMember.ClientID %>'); dropDownList1.change(function(e) {
if ( jQuery("#ddlUserType").val() != "ETOC") dropDownList2.removeAttr('disabled'); e.preventDefault();
else
dropDownList2.removeAttr('enabled'); e.preventDefault(); }
} );
</script>
what is happening now is page is blank and if I remove the above code everything shows, where I am going wrong. here is the plain and final javascript code which worked:
<script language="javascript">
function CheckDropDownState(lstbox)
{
if (lstbox.selectedIndex == 3) { document.forms[0].ddlMember.disabled = 1; }
else { document.forms[0].ddlMember.disabled = 0; }
}
</script>
and thew .aspx code: <asp:dropdownlist id="ddlUserType" runat="server" onclick="CheckDropDownState(this);"></asp:dropdownlist>
i use 2 dropdownlist with 2 object data source first dropdownlist to display departments name using object datasource (field to display DeptName , value of field DeptID)
second dropdownlist to display Employee name but depend on departments (field to display EmpName , value of field EmpID)
how to display employee name in dropdownlist depend on departments name in the other dropdownlist
2 tables
1 table deprtments with column (DeptID , DeptName , DeptDescription)
2 table Employee with column (EmpID , DeptID , EmpName)
protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e)
{
BindDistrict();
}
[Code]......
here when i click on ALL item from ddlzone1 it just "ALL" item in ddldistrict
i want when i select "ALL" item from ddlzone1 in ddldistrict14 show all data from database
i have 3 drop down list in my page
1-ddlzone1
2-ddldistrict1
3-ddlstore1
this is ddlzone1 code
protected void DDLzone1_SelectedIndexChanged(object sender, EventArgs e) {
DDLstore1.Items.Clear();
DDLstore1.Items.Add(new ListItem("select center", ""));
DDLstore1.AppendDataBoundItems = true;
SqlCommand _cmd = new SqlCommand("selectcenter", _cn);
[CODE].....
I have a gridview with 3 nested dropdownlists in one cell on edit like this:To get the exact fields when the user clicks on edit I used the following code(yes it's messy)
[Code]....
The BLLOnderhoud is a class and the getReserveInfo is used to get the Model - Brand(merk) Information.Since the dropdownlists are nested in the gridview I can't call them directly and they can't call any of my functions.And this is the problem, when I change the dropdownfield Model the Auto field wich is the last dropdown(in the picture is a typo) should be binded like in the following code:
[Code]....
But the dropdownlist onDataBound event can't call any of my functions that are in my class.So my question is how can the onDataBound event of the second dropbox trigger a function? The only thing that the function has to do is to bind the 3rd dropdownlist
I had use a combox to let user select staff name and then it will automatically retrive the responsible recommending officer and approving officer to display in other 2 dropdownlist.
my code works fine but when user select staff name each time, the page will reload once to refresh the dropdownlist.
user complaint and don't want the page reload every time, how can i disable the postback? I need to use ajax?
[Code]....
[Code]....
what i m trying is i hav two dropdownlists inside the gridview... namely say ddonsiteoffsite and ddhours... now what i want is if the selectedtext of ddonsiteoffsite is "onsite" the ddhours should b disabled... i tried the code snippet but ... its not disabling the ddhours... can someone help me please..
<asp:TemplateColumn HeaderText=" OnSite/OffSite" >
<ItemTemplate>
<asp:DropDownList ID="ddOnsiteOffside" runat="server" onchange="ToggleOnOff(this)">
[code].....
I try to create a asp.net mvc 2 application.
My DropDownList won't be validated!
I have a core model class called Animal with some attributes and the same for the class Genus. These classes are mapped to nHibernate.
[code]....
I have a problem with my dropdownlist on edit he doesn't want to add any of his parameters to the update. I tried controlparameter and normall parameter both didn't work The folowing I have: Dropdownlist with Datasource: I Have a gridview with templatefields: I have the following asp.net code:
[Code]....
I have the following Business Layer where it connects to:
[Code]....
I have a dropdownlist and a button(btnSend).
protected void btnSend_Click(object sender, EventArgs e)
{
InsertIntoTemporary();
LoadAddressdetails();
MassSendOut();
}
What i need to do is as follows;
1) Once i select the item in the dropdownlist, it will extract data from my sql query which is :
string mySQL = "SELECT * FROM examtimetable WHERE subject_name= '" + dd_cat.SelectedValue + "'";
Once seleted,it will display everything in a gridview1.
subject_id subject_name admission_no date venue seat_no
I have data coming from two tables with a foreign key relationship - one User table containing users of the web application, and one Page table containing details about pages visited by each user.I would like to be able to view these data in a gridview or the like on a page. It's easy enough to just show the User table data like so (I'm using the Entity Framework and LINQ):
[Code]....
But how can I show the Page details? I'm not bent on any particular way of showing it, but the only idea I've been able to come up with is to have a dropdown list for each user in a column. But I can't figure out how to get the page data into such a dropdown list. The tables are associated with the primary/foreign key UserID.The closest I've come to finding something similar to this is this for Linq2SQL: http://weblogs.asp.net/scottgu/archive/2007/07/16/linq-to-sql-part-5-binding-ui-using-the-asp-linqdatasource-control.aspx , and this using more traditional data access: ttp://www.highoncoding.com/Articles/169_DropDownList_Inside_GridView__Method_1_.aspx . Either way, regardless of data access technology, I can't relate these solutions to my example and get it to work
I have requirement to bind ASP.Net DropDownList control in EditItemTemplate of GridView.
I preferred the tutorial:
[URL]...
i have followed same steps just but difference is i have a edit imagebutton with commandname="Edit".Also dropdown needs to be binded from different table(directory) and not the table through whicch grid is binded(details).
if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState & DataControlRowState.Edit) == DataControlRowState.Edit && GridView1.EditIndex == e.Row.RowIndex)
{
DropDownList DStatusEdit = (DropDownList)e.Row.FindControl("DStatusEdit");
string query = "select distinct status from directory";
SqlCommand cmd = new SqlCommand(query);
DStatusEdit.DataSource = GetData(cmd);
[CODE]..
the page is running but when i click edit image button the dropdwn shows but no data in dropdown binded it is empty.
My gridview is inside update panel.
How can i achieve this?
Should dropdownlist in my case be binded inside rowcommand and how?
