I have a dropdownlist, with list of Names and Id Nos. If i select the list item, i get its info from sql.Now i have created the pages for eash names based on their ids.
How can i creat a Hyperlink to redirect to the names pages.the following is the dropdownlist code:
[Code]....
I have a HyperLink control in a ListView, and I need to pass a couple of querystring parameters.
[Code]....
The first parameter is based on the current DataItem value in the LV.
Suppose I want to set a second parameter with a value from Selected.Item.Text in a DropDownList on the same page, how would the HyperLink look?
I have a DDL which pulls out its data from a backend MS ACCESS database, I want to add an additional item in the list which would be a hyperlink to another page. I am having a hard time doing it, I tried adding it as a ListItem but for no use.
[code]....
I would like to add a column in my datagridview that takes the value from the database and asigns it to the text of a linkbutton or make it a hyperlink. i know how to handle getting the value from the row but dont
know how to make a value a link, or set the text to a link button
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 RepliesI have created a gridView control and have successfully bound DataTable (dt) to it using
[Code]....
However, I want to add a dynamic hyperlink that will take the user somewhere based on the value of one of the columns in the selected row. I'm not sure how to do that.
1. First i am populating a datatable with two columns of type text. The second column is a hyperlink (but i am not specifying that datacolumn type as hyperlink).
2. After populating the rows, i am adding the datatable to dataset.
3. then binding this dataset to the gridview (the gridview's AutoGenerateColumns=true).
Question:
Obviously, the hyperlink column is represented as text in the gridview (non-clickable hyperlink).
here i am trying to convert this hyperlink column (data rows), from text to a hyperlink, so that the user can click directly and navigate to that url.
FYI, I cannot change this method of binding, and just want to convert this text hyperlink to a real hyperlink.
I would like column in a table to be a link(not using hyperlink field). What data type do I need to use to make this possible?
View 2 Repliesin asp.net i want to display a list of data in one column of listview with hyperlink. All the data should should apper in tabular format.
View 2 RepliesI am using DetailsView box (Visual Studio 2010) to display employee data based on Access table. One of the fields is an employee email, designed in the table as HyperLink. I want this field to be displayed in DetailsView as HyperLink also.
Is it possible to do this?
I have a Gridview with a hyperlink field. The hyperlink will open a pdf file from a folder in the root of the web if there is a corresponding file. My problem is that there may or may not be a corresponding file and if there isn't a file then a browser window opens up and the contents of the folder are displayed. This folder will be maintenanced from day to day adding and removing files. coding something that will either disable the hyperlink were there is no corresponding data or just pop up a message that there is no corresponding data to view.
View 7 RepliesI want make one of the field in my data grid in hyperlink after I retrieve the records from the database. I have EmpId and EmpName in the gridview but I want to make the EmpName field in hyperlink so that when I click a name, I can redirect at a page based on the data of that field. How can I suppose to do it??.
View 9 RepliesI have one asp.net C# page in which i have gridview..
This are the url comes from database and binded in gridview
www.xxxxxx.com/A/Default.aspx
www.xxxxxx.com/B/Default.aspx
www.zzzzz.com/C/Default.aspx
what i need is i need to show this url has like this
www.xxxxxx.com/A/Default.aspx is like Test1
www.xxxxxx.com/B/Default.aspx is like Test2
www.zzzzz.com/C/Default.aspx is like Test3
if user click Test1 it will open a new browser window with www.xxxxxx.com/A/Default.aspx
if user click Test3 it will open a new browser window with www.zzzzz.com/C/Default.aspx
how to make this in gridview
I am trying to use a repeater control that will display a hyperlink control. For the text of that Hyperlink control I would like to concatenate to fields from my data source (lets say First Name and Last Name). How would I do this appropriately for the Hyperlink control within an ItemTemplate?
View 3 RepliesI have a page called: TreatmentBrowse.aspx which has a GridView on it showing a name and description. The name is a Hyperlink and the DataNavigateURLFormat is set to: TreatmentMaintenance.aspx?treatmentId={0}. So if they click a name it goes to a TreatmentMaintenance and loads the name and description in the DataView with the records from the TreatmentBrowse.aspx. My problem is every time I click a hyperlink, no matter what one it always shows me the information for ID 1. How can I fix this to show me all data corresponding the the hyperlink treatmentId?
View 2 RepliesI would like to use the following hyperlink control as parameter values for the sqldatsource query bound to grid from the same page.
so when i click a link the page is refreshed with new results.
<a
href="products.aspx?category=1">Beverages
(32)</a>
<a
href="products.aspx?category=2">Condiments
(14)</a>
I have a webform that writes respondent info to a sql data base. I want to send a email campaign and use a unique identifier so that if
1. joe clicks on his link http://www.test1.aspx?209
2. tim clicks on his link http://www.test1.aspx?603
that when they click the form submit the data gets written into the correct row where 209 and 603 are their respondent numbers already in the data base. This is my first attempt using c# and I couldn't find anything in my books about it.
my code<asp:HyperLink ID="HyperLink8" runat="server" NavigateUrl='~/default.aspx?id=<%# Eval("id") %>&name=<%# Eval("name") %>'></asp:HyperLink>it don't work!
View 5 Repliesi have database like this (ID , NAME1 , NAME2 , CAT1 , CAT2 )
my database is for people that i have devied by two arguments , CAT1,CAT2
I would to do hyperlinks to access database with some argumets , for example , i want all the view all the people with CAT1=7 && CAT2=4
i have build function that get 2 arguments and return to me all the data i have try it with MICROSOFT SQL and the all work perfect
How Can I use a hyperlink in a gridview so that when a number is clicked on in that gridview it would direct me to a new page showing a new gridview
View 7 RepliesI am having a HyperlinkField in GridView
<asp:HyperLinkField HeaderText="Name" DataNavigateUrlFormatString="~/destination.aspx?j1={0}&c1={1}"
DataTextField="j1" DataNavigateUrlFields="j1,c1" />
I just want to do UrlEncode in DataNavigateUrlFormatString.
I have a manual binded grid view from a datatable. The datatable is also manually generated.
When I generate the datatable, I will have a datarow, and i was thinking to add a hyperlink the the last column of every row. I have something like this, but it just not giving my desired output.
[Code]....