i need to extend this so that i can inlcude another column from a different table. so let's say i have a colume in table Price and the column i want to display in datagrid header is cost, how can i do this? there is code backend but could i simply code the below to include this column?
[code]....
I have "Order" object with Columns Ticket,OTP and CustomerName etc.Intially on DataGrid, I'm binding Ticket only , when user clicks on "Column Chooser" button, another windows appears to pickup CustomerName,OTP columns to add specified column dynamically on Datagrid. Environment : Asp.net ,C# with Object Data source
Public Class Order
{
publc void Order()
{
}
public string Ticket
{
get
{
return this.strTicket;
}
set
{
this.strTicket = value;
}
}
public string OtpNumber
{
get
{
return this.strOtpNumber;
}
set
{
this.strOtpNumber = value;
}
}
public string CustomerName
{
get
{
return this.strCustomer;
}
set
{
this.strCustomer = value;
}
}
}
}
I can't found solution... i have set 4 columns in DataGrid view but when i am using SqlDatAdapter and DataTable it displaying all columns.
View 3 RepliesI am upgrading a classic asp page, the page uses response.write to make a table, as soon as a null value comes up for a month the columns of the grid then stop. The sql is below
SELECT sName, Strategy,
Sum(case when Month([Date])=1 then Rtn else null end) as Jan,
Sum(case when Month([Date])=2 then Rtn else null end) as Feb,
Sum(case when Month([Date])=3 then Rtn else null end) as Mar,
Sum(case when Month([Date])=4 then Rtn else null end) as Apr,
Sum(case when Month([Date])=5 then Rtn else null end) as May,
Sum(case when Month([Date])=6 then Rtn else null end) as Jun,
Sum(case when Month([Date])=7 then Rtn else null end) as Jul,
Sum(case when Month([Date])=8 then Rtn else null end) as Aug,
Sum(case when Month([Date])=9 then Rtn else null end) as Sep,
Sum(case when Month([Date])=10 then Rtn else null end) as Oct,
Sum(case when Month([Date])=11 then Rtn else null end) as Nov,
Sum(case when Month([Date])=12 then Rtn else null end) as Dec
FROM Chess
If this is run in oct i only have data from jan -0ct , how do i not display nov and dec so that its dynamic?
Does anyone know of a data control that displays the columns vertically?
Example
First Name Bill Bob
Last Name Smith Jones
Middle Initial A C
I'm trying dynamically to change the HeaderText of one of my DataGrid's columns but have some problem.
I'm making the change on button click event.
At the first click nothing happened, but at the second click the change is made correctly.
Why only at the second click the change is made?
can i implement multiple column sorting in an ASP.NET DataGrid.Datagrid contains Template columns.
View 5 RepliesI put in my page 1 table like grid with this style:
header of columns are select from table persons(so number of them are dynamic)
header of each row are select from table goods(so number of them are dynamic)
in table , in each cell,show the price & the date ,that this person,buy this goods
for example,in may 2008 ,Jack&sara buy pencil.so in front of pencil&buttom of jack we write his price and in front of pencil&buttom of sara we write her price.
so this table has 2 column & 1 row
in may 2009,
Jack&sara buy pencil.so in front of pencil&buttom of jack we write his price and in front of pencil&buttom of sara we write her price.
and jhon buy pen & suzzan buy book so this table has 4 column & 3 row
Price Date
Price Date
Price Date
Price Date
Pencil
Pen
book
then I want in each cell,I have 1 CHECKBOX that user of my program,checked each on that want. how can I design my page?
is ther any component?or I must create <TABLE> dynamically
can i display columns inside the datagrid footer? if can.. i can i have the syntax?
for example: i have a columns in the datagrid which is binded to database. at the column footer.. i want to display another column.
I have a datagrid which displays a list of user data, such as name, his or her status, age. I have created a list of rows of user data but where the column shows status for example Single, Married, i want it to create a dropdown list where i can easily change the user status by selecting it from a dropdown and clicking the update button at the top of the datagrid. The update button will update all records that have been changed not just from the dropdown. I assume the dropdownlist requires a columnbinding event but i can't find any straight forward tutorials.
View 2 RepliesI'am developing a commercial website using vs2005 and sql2005 in which i want to display the images from the datagrid in three columns,as
1 2 3
4 5 6
7 8 9
I have to freeze the first column in a data grid. i have done freezing part but the issue is vertical and horizontal scroll bar movement getting slow. in my data grid each row contains 18 textboxes and 18 image buttons.if number of rows count around 15 then the scroll bars working almost properly.issue in
morethan 15 rows
For freeze i am using CSS.Platform is asp.net1.1
in CSS i am using below given codes.
div#div-datagrid {
width: 200px;
height: 200px;
overflow: auto;
}
/* Locks the left column */
td.locked, th.locked {
position:relative;
cursor: default;
left: expression(document.getElementById("div-datagrid").scrollLeft-1);
}
/* Locks table header */
th {
font-size: 14px;
font-weight: bold;
text-align: center;
background-color:Navy;
color: white;
border-right: 1px solid silver;
position:relative;
cursor: default;
top: expression(document.getElementById("div-datagrid").scrollTop-4);
z-index: 10;
}
/* Keeps the header as the top most item. Important for top left item*/
th.locked {z-index: 99;}
I have a datagrid whose columns are autogenerated (based on the results from an SQL SELECT query). However, I need to retrieve values from certain cells across the datagrid, using the following code to step through the results.
[Code]....
I need to specify all my columns using TemplateField?
Here is the situation:I have a Datagrid which is going to display a number of rows. I want to click a button on the datagrid and have the following occur
open a row underneath the row clicked, without hiding or replacing that row Open this row so that it spans all of the columns as one continuous row where i can put form fields and/or just data formatted as I would like and not just in columns.Be able to close that new row. While I do most of my work in VB.NET, don't think that is a requirement for answering this.I have managed to currently take the first column (with the "Edit" button) and when clicked to
Hide the rest of the cells in that row Expand the button column to run all the way across the table Unfortunately I loose the clicked row's data, and I've only started getting this to work so I haven't tried too much, or getting data to bind to fields "on the fly"
I had called the data from query to data table and now i have a gridview in which i am using one datalist and 2 text boxes and and reming coloumns are bounded iahve to assiaign them values which datatable have either null or any value.
View 2 RepliesI have a datagrid with two columns ( File Name, and Date Created ). I want them to be sorted when clicked (ASC or DESC). I went into the design view and added the allow sorting feature and added the column names, so they are clickable in the header of the data grid. I also already added the onsortcommand as well.
My datagrid is named dgFileList and the onsortcommand method is named dgFileList_SortCommand.
The procedure that is already loading on page load is a DataSet. (where I think my problem is)I dont have anything in the back end beside the dgFileList_Sortcommand method. From what I have read, it seems like I can't use a DataSet to be sorted...I'm using visual studios 2005, C#, not VB.
I also have a working application that popukates my datagrid with valid data rows from my DataBase. What I cant figure out is how to get each of the hyperlink lables to NAVIGATE to the correct and corresponding aspx page!
For example I have 5 rows in the datagrid and each row has its own hyperlink, each row contains contact and a short profile on 5 diffrent companies. For example when i click on let say row 3 that has (eg) Jimmy's Big Prawn's Restaurant listed in the the datagrid, I want to be navigated to a webform page dedicated to Jimmy's Big Prawn Restaurant.
[Code]....
I am guesing it has to do with the bolded text above, but "details.aspx" is just an empty webform, I would like the hyperlink to point to (eg) JimmBigPrawnRestaurant.aspx.
I am new to asp.net. to draw the following table using datagrid?
[Code].....
how to pass a row in the datagrid from another table?
like when i type the data in the column and press "Tab", i want it to retrieve a row from another table.
and my data is already bind to table to make it more clear i have student table, and courses taken by student and the courses table so the courses taken by student is bind to student table, when i navigate between students it also navigate throw courses taken by student, which i like but when i want to add a new course to the table, i add the course_code, and i want it to fill (Course_name, course_type, course_chs) when i press "tab" in courses taken by student table from the courses table.
how can i do this?
How to add new row in a database table using DataGrid like following way?
View 3 RepliesI am having datagrid in that I have one column that should have table. Now I want to know that how can I include table in datagrid. My table values may differ from each rows in datagrid. So that also should be accomplished.
View 3 RepliesI have a stored Procedure, which copies the data in one table to another table in other DB.
I have the query to copy the records to other table.
But, tomorrow, new columns are added to the source table, then, how to dynamically copy the data from those columns to the destination column..
I have a datagrid which pulls data from a single database table to display it. However, this database table also contains information on the thumbnail URL for each record, and I would like to display the thumbnails for each record in the 1st column of the datagrid.
At present I have added the following to my datagrid:
[Code]....
So I presume the main challenge now is to set the Thumbnail.ImageUrl property to the correct file path in the VB.NET code. But how do I do this for each record? I am using a function to retrieve data for the gridview, which is based on the following:
[Code]....
I wonder how to muliply two columns in a table and the result is displayed in the blank column and be specified by its row..
View 3 RepliesI just want a function which exports the table in the datagrid view into a text file or excel file on button click.
View 3 Replies