populating the dropdownlist with column name. I have a gridview that has 7 columns . I want to have a textbox search and dropdownfield where user can select column name and type a word in search box and click search so that text for that column name is being search and displayed in grid. how I can fetch just column names from DB and search ?
View 8 RepliesI would like the user to select an item from a drop down list. Next to the drop down is a textbox or label control. From the ddl selection I would like to populate the textbox or label from a database with a corresponding field from the database the dropdownlist was populated from. On selectindexchange event I can populate the textbox with the Unique id from the value, but I need to input a different field into the textbox. Can I use some sort of variable to assign the Textbox.Text = ?
View 6 RepliesI have one database in which student enroll no with his sem is stored . I want that if i enter stud enroll no then in dropdown list all the sem related to that stud should come. My databaseÂ
Stud enroll no     sem1      sem2       sem3      sem4
    1          July 2013   Jan 2014    July 2014   Jan 2015
    2          Feb 2013   Aug 2014    Feb 2014   Aug 2015Â
     3         July 2012   Jan 2013   July 2013   Jan 2014
my c# web app containing a gridview template field with one column as dropdownlist,drop down list contains 3 items such as disposed,fitted to,battery room,when i click edit button corresponding row is selcted bt dropdown list contain its first value ie disposed instead of actual values in database, i used the following code for retrieving values from dropdown during updation
DropDownList tb3 = (DropDownList )GridView1.Rows[e.RowIndex].FindControl("drpstat")
;
my html code for my gridview is :-
[Code]....
need to get selected value from dropdownlist,textbox and bind in grid
View 1 Repliesthere is a radio button, a dropdownlist. radiobuttons are OY, OTY,VDA ( in my database there are fields named OY.OTY,VDA) if i select OY in my radio button the data should be displayed from field OY in dropdownlist and if i select OTY in my radio button the data should be displayed from OTY field in dropdownlist is it possible. there is a sqldatasource for dropdownlist .
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:MS16ConnectionString %>"
SelectCommand="SELECT DISTINCT OY FROM COURSE_INTAKE">
</asp:SqlDataSource>
THE SELECTED DROPDOWNLIST DATA IS REQUIRDE TO BE DISPLYED IN A GRIDVIEW.
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 want a word search i doing the search like this , but it is giving character wherever there is in the string,if i give two character like ok it is searching for a full string where ever Ok is there select * from table1 where textfield like '%word%' this query would match word but also wordabc how can i make it aware of delimitions
View 3 RepliesI have 2 dropdownlist, one is to dropdown department, and another dropdown staffnames. the secong dropdownlist will based on the selection of department as each department has different staffs i have 2 tables department and staff in my database , in my department table i have departmentid as PK and departmentname, in my staff table i have staffname and departmentid as FK. So my ques is how am i going to populate staffname in the dropdownlist according to the selection of department.
View 9 RepliesI have a DetailsView on the page and I have made one of the fields a TemplateField. In the EditItemTemplate and InsertItemTemplate I have a DropdownList that is databound to a table in my Sql Server database. I wanted to add an initial value to the DropdownList
namely "- select -" .
I set the AppendDataBoundItems property to true and added the initial value as a ListItem.Markup of the DropdownList
<asp:DropDownList ID="DropDownList_HP" runat="server"
AppendDataBoundItems="True" DataSourceID="SqlDataSource_HP" [code]...
This works fine for new input. The problem is however that the database already has records that were entered through a Windows Application and many of these records has a null value in this field and exceptions are thrown when I tried to open these records
and the system tried to set the SelectedValue of the DropdownList.After some more searching I found this help
http://msdn.microsoft.com/en-us/library/ms366709.aspx
So I changed the ListItem in the DropDownList markup to the following:
<asp:DropDownList ID="DropDownList_RefHospDV4" runat="server"
AppendDataBoundItems="True" DataSourceID="SqlDataSource_RefHosp" [code]...
This now solved the problem of opening a record where the value is null in the database, BUT now the RequiredFieldValidator is not validating anymore to make sure that a databound item is selected for this field and not the initial value "- select -". So basically now it is not checking anymore to see if valid input has been entered for the DropDownList and it accepts "- select -" thus it acts as if the field is not a required field anymore.
In short what is required is that I want to make sure that the user enters a valid selection in the DropDownList, but it must also cater for old records that do not have this field entered yet so that those old records can be opened in the DetailsView .Opening Old records (with null in that field):When these old records are opened in the DetailsView the DropDownlist should show "- select -" when the value in the database is null.
Saving records (old or new records):When saving the record in Insert mode or Update mode the RequiredFieldValidator should show that a valid input is not selected if the DropDownList is still on "- select -".
I have a textbox1, button1 and a GridView1.
I have configured a datasource for gridview1 to execute a Stored Procedure on a SQL Server Database passing a parameter with the value from textbox1.
My question is, how do I code the button1 Click Event to populate the GridView1?
GridView1 already has the datasource configured, I just need to trigger it via the button1 Click Event.
I have a created a aspx page called SearchTeam and in my database I have my image titled called fld_Kit Image which records the name of nameofimage.jpg. In my Solution Explorer I have the images in separate folder and have used a processhandler.
SearchTeam.aspx@
Page
Title=""
Language="VB"
MasterPageFile="~/MasterPage.master"
AutoEventWireup="false"
[code]...
i have been learning asp.net 3.5 and i have ? if someone could help me out
i have a datagridview using a sql database and using textbox lastname
i have been trying to setup a second textbox for first name
what im trying to acomplish is being able to populate the gridview if only one textbox has a name in it
it works fine if i put in a first name in textbox1 and a lastname in texbox2 if i leave one textbox empty it want populate nothing.
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 have a textbox and a gridview which is bound to a table what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;
1. Book
2. Red
I have set up the sql data source and everything and my like operator is this.
LIKE '%' + @record + '%'
how can I solve this problem?
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();
}
}
I'm currently learning more about C#.Net via video tutorials (I'm a visual/hands on learner) and I'm learning more about Console.WriteLine functions.
What I want to do is take this code (see below) wich is a bunch of console writelines and make it so that each time the button on my page is clicked the lable field is populated with a new random number.
I understand how to use the lable field with static data (Label1.Text="") but I just can't figure out how to get the method that I want to execute into that label upon a button click.
It is somewhat difficult to explain what I am trying to do. but, essentially I just want a lable saying "Random Number Function" then a button that says "Generate Random Number" and a non-labeled lable that will populate a random number upon clicking the button. With a little help, I can get this and then I'll be able to create all the rest of my console.writeline functions into my asp page for later reference :D
And I do appologize if this is in the wrong section. I am very green to this. I've only take a half semester of C#.Net and half of Java. My Asp.Net and Visual C#.Net are self taught. And, I often hit walls with using google for what I'm after, probably due to my lack of termonology knowledge.
[Code]....
I have a gridview which is binded to a Sqldatasource. I would like to replace a column data field value to 'Not Applicable' if that column has got a value of 2 in database.
View 2 RepliesI have been alerted to the Query Extender control through previous posts, but I am still seeking the final part of my desired solution.
NB the following is written in conceptual English (programming specification) format, rather than actual asp code.
While I fully understand that I can use the QueryExtender control to pass a parameter from one web page to another, I do not see, and maybe this is not even possible, how I can pass a parameter of which field I want to select on.
Ideally I would like to be able to implement a query which is
SELECT tiles where 'Passed Variable Name' contains 'Passed Test Value'
such as would then generate, for example -
[code]....
I have only mentioned three in the concept above but there are actually about half a dozen different calling pages, and there could develop a few more over time.
I am in VS2008 and in ReporViewer's Design page.
I have "Fruits" as column fields and Months as row fields and Sales as data field.
I have these columns:-
Apple, Orange, Pear.
However, I want it be displayed as
Orange, Pear, apple.
Any work around ?
Also I need a 4th column adding the Apple, Orange and Peer numbers total. How to do it in design view in VS2008 ?
I have an email contact form that I have successfully populated the account users Username and email address into text boxes
I also use a text box and session variables to send parameters to a stored procedure and return a single row result in a form view.
The thing I am having an incredibly hard time figuring out is how to populate a single textbox with the data from any of those fields. or the whole control as a single summary.
Just for starters I am actually an IT Manager and NOT a coder so this is entirely a hack job if there ever was one...
here is my aspx code
<%@ Page Language="C#" AutoEventWireup="true" MasterPageFile="~/RMSWeb.master" CodeFile="Service2.aspx.cs" Inherits="_Default" %>
I have the following code in the .aspx page:
<asp:TemplateField
HeaderText="Summary"
SortExpression="INTERPRETATION_SUMMARY"><ItemTemplate>
<asp:Label
ID="lblSummaryView"
runat="server"
Text='<%# HighlightText(Eval("INTERPRETATION_SUMMARY")) %>'></asp:Label
[Code]....
1) 1 dropdownlist - department
2)Search button
3) 1 listbox that will display all the staff according to the selection of its department
So when i select the department and click search button, the listbox will be populated with the staff names.
I am trying to populate a dropdownlist with the current date (Month and Year only) and also the previous 9 months and year. I need it to change when a new month starts to always be the current and previous 9. Cant get my head round it.
View 2 RepliesI've been trying to find a solution to my problem for about 2 days now, and have found nothing. I am new to .net and not really sure how to accomplish this. I have 4 tables in a database, Vendors, RepairCos, Cons, ConRepairHistory. What I'm trying to do is make a page called SendOutForRepair.aspx that has a insert item template where the first control is a dropdownlist that is attached to the Cons table (got this figured out) and is populated with the Serial Number field. I would like the selection from the dropdownlist to populate the 2nd control (VendorID) that is also from the Cons table.
example record from Cons Table: Serial number VendorID
508585 1
so when 508585 is selected in the dropdownlist, it would populate VendorID with 1 (this is my issue)once this happens, the user would fill in the other fields (hours, issue, repairco (also a dropdownlist linked to RepairCos table), RA Number, DCI, DPU, DRB, Cost, Record (which is a identity field and primary key for table) and when the insert link is pressed will insert all 11 fields as a new row in the ConsRepairHistory table. so the new record in the ConsRepairHistory table would look like:
Serial Number VendorID Hours Issue RepairCoID RA Number DCI DPU DRB Cost Record
508585 1 2250 alarming 2 20222 11/16/2010 11/17/2010 null null 3
the RA Number, DCI, DPU, DRB, Cost all allow null values.