i have one master table containing names of city and id. i have another master table containing routeid , destination (id of city from city master), departure (id of city from city master) now i have to display in dropdownlist combine names of departure and destination for selecting route to create schedule. i have to do this using LINQ.
View 1 RepliesNewbie here, I'm trying to setup a webpage using the following tutorial posted on this website:http://www.asp.net/(S(pdfrohu0ajmwt445fanvj2r3))/learn/data-access/tutorial-07-cs.aspxThe problem is when i try to add the fields on 2 columns on my table and then populate a dropdown list with the concatenated columnie. my table has the columns ID and Name. I want to display it as:"ID - Name" in my dropdownlist in stead of just Name. eg: "AB - Treatment Centre"I've been googling and so far the only solution i've come across is to generate a TableAdapter with the following query:
View 3 RepliesHow to show in dropdownlist text arabic and english in asp.net ....
View 1 RepliesHow to bind two database field in single listbox in display field.
Is it possible ??
If yes then how can we implement it?
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();
}
}
want to display gridview column heading when mouse over to the particular column in the gridview.
View 9 RepliesI have a gridview with 3 columns. In second column I want to display some text in 2 rows and then a gridview.
Here is my code:
[Code]....
The problem is my third row is displayed as a row under first column. How do I make it a separate column in my girdview. Not sure what is going wrong.
I want to display gridview column heading when mouse over to the particular column in the gridview.I am working in VisualStudio 2005 with MS.Net2.0 framework.I don't want to use ajax.
View 4 RepliesI have a listview with following structure :
column1 column2 column3
row1 dropdownlist1 dropdownlist3 dropdownlist5
dropdownlist2 dropdownlist4 dropdownlist6
row2 dropdownlist7 dropdownlist9 dropdownlist11
dropdownlist8 dropdownlist10 dropdownlist12
Now, what i want is that , when a user select something from any dropdownlist , a fuction should be called in which I can get column and row of that dropdownlist.
I can get the dropdownlist's id in that function along with row and column of dropdownlist.
What I have is a GridView with a DropDownList in an ItemTemplate (not an EditItemTemplate). My datasource is not a control, rather in the code-behind.
[Code]....
My main problem is that VS is not seeing that I have the dropdownlist, meaning I can not access any of the events in the code-behind. What I want to do is, when the value of the DropDownList is changed (SelectedIndexChanged), I want to grab the value of the RowIndex of the GridView.
My web page consist of GridView with 2 columns:
Column 1 : SesStartTime[BoundField]
Column 2: Status [TemplateField] with DropDownList inside
When user select on the DropDownList i need to check the selected row's SesStartTime must earlier that current time.
Else i need to prompt alert to user.
I dont know how to work on this. Can someone guide me on this or provide me with sample of code.
Below is my aspx page code:
<%@ Page Language="VB" MasterPageFile="~/MllpMain.master" AutoEventWireup="false" CodeFile="LearnersDetail.aspx.vb" Inherits="WEBUI_Learners" %>
<%@ Register Assembly="System.Web.Extensions, Version=1.0.61025.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Namespace="System.Web.UI" TagPrefix="asp" %>
[Code]...
in 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 have a gridview bound to a dynamic query which produces a total row as part of the bound data. I am making links out of some of the cells and want to do a check to see if the bound data matches certain criteria to allow linking to it. My code looks something like this:
[Code]....
What I want is to change the item template to not include the <a href> if the value of the Eval("Category") statement is "Total".
I tried doing something like <% if (Eval("Category") != "Total") { //do something } %> but that throws an error: Databinding methods such as Eval(), XPath(), and Bind() can only be used in the context of a databound control.
I AM STUCK IN DISPLAYING SUM OF COLUMN ITEM TEMPLATE IN THE FOOTER OF GRIDVIEW
this is how i am getting the data
[code]....
I am displaying some data in a grid view. I want to add another column in the grid which displays a check box for each row in the grid.
1. How do I give a new name to each textbox? example could be corresponding Case No value could be the text box name.
2. I have a button to read what checkboxes have been checked and initialize a string accordingly. For each checkbox checked it should add the corresponding row's "case no" value to a string.
[code]....
I have a table with the following structure:
Attribute
-------------
AttributeId
WeekNo
DayNo
Attribute1
Attribute2
Attribute3
Attribute4
Attribute5
........ likewise.
I want to display these data in a gridview in the following manner
Sunday Monday Tuesday ............ (till Saturday) - should be gridview columns, I can retrieve this using dayno
Attribute 1
Attribute 2
Attribute 3
Attribute 4
like wise attributes should be taken in to rows.Is this possible in a gridview, if so how can I do that?
is it possible to display Null. if my sql data is null while binding it with gridview in asp.net
[Code]....
[Code]....
for example like this
[IMG]http://i53.tinypic.com/n51ogh.jpg[/IMG]
These are the part of the javascript:
var gridViewCtl2 = null;
var selRow = null;
var gridViewCtlName2 = 'GridView2';
gridViewCtl2 = document.getElementById(gridViewCtlName2);
selRow = gridViewCtl2.rows[2];
Now I want to diaply a particular column (eg. 5th column) into a HTML text box or asp control (Label).
eg.
Text1.value = selRow.......
How can I do that?
how to retrieve the column number in gridview
i am able to get the row number using this syntax <%# Container.DataItemIndex + 1 %>
but what about column number?
how to display the sum of the grid values (column).
I have 2 datagrids and i want to show the total of the values in a particular grid column.
in a column, each row has vaules E.g. 4 , 6, 7 etc .
I want to show them in a label as the total of the above ie, 17
i have created university timetable.
how to display data.?
days show in row wise and period showin column wise aur every period have particular course..
gridview..detalview or any thing..?
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
My requirement is i have to display column wise records in GridView control.
I am thinking to create a user control for this.
See the attachment of sample screen.
Sandeep
My requirement is i have to display column wise records in GridView control.
I am thinking to create a user control for this.
See the attachment of sample screen.
Sandeep
I am having trouble with displaying double data in gridview bound coulumn. I want it to display as it is... But it gets rounded off when displayed.
Like my 1.34 displays 1.00
1.57 - 2.00
and so on. But i want it to display as it is i mean with decimal points, without rounding it off.
Is it possible to display two column values from a SQL database in to one DDL? I have been trying to write a SQL query, where in I select two fields to be displayed in the DDL but when I run the application it only displays one. Not sure why. Here is my code below:
<asp:DropDownList ID="DropDownList8" runat="server"
DataTextField="LATA"
DataValueField="LATA"
onselectedindexchanged="DropDownList8_SelectedIndexChanged"
DataSourceID="SqlDataSource1">
</asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:Inventory_DBConnectionString %>"
SelectCommand="SELECT DISTINCT [LATA], [LATA Name] AS LATA_Name FROM [CA] WHERE ([SWITCH ID] = @SWITCH_ID)">
<SelectParameters>
<asp:QueryStringParameter Name="SWITCH_ID" QueryStringField="ddl1"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>