I have an entity "Order", which contains a set of states. Every state has date and name.
I want show grid with all orders and in grid one column with last state of order. But I dont understand how to do it.
I have a gridview and in this grid one link button "view" is in each row
when we click on view button we want to show the another grid in the same column
I have gridview and want to show datalist in grid view view column on click of linkbutton show.
[Code]....
below data are getting from the db
COL1 Col2
a b
c d
i want to bind the col1 and col2 value in one template field column inside gridview .is this possible means how to do this below is the format i expected. i don;t want to do this in db ..
COL
a(b)
c(d)
i have one grid and one button when i click on that button then it expand and showing another grid under the row of parent grid how to do that.
View 2 Repliesi have a grid view with some coulmns like Name,Phone no etc with Edit,Delete column in grid view. I click a row in grid view to Edit,it goes another page where i can edit all fields .Once i update i redirect the page to gridview. I want the grid view to remain in that particular page say 4 of the grid view
View 5 RepliesI have data in mydatabase. My AnswerText in the database is test1,test2,test3 While retrieving it is displaying as test3,test1,test2. I am using the below code to display the data.
Dictionary<string, string> dicKeyValues = new Dictionary<string, string>();
for (int i = 0; i < cnstsData.Answer.Count; i++)
{
dicKeyValues.Add(AnswerText, AnswerImage);
}
DataList.DataSource = dicKeyValues;
DataList.DataBind();
I want to display the AnswetText as test1,test2,test3. Basically i want the same order which i added to the database while retrieving also.
I have efficiency issue.I created DataTable and insered some data, now I want to order my data and connect it to my Grid.I created a function that returns sorted datatable, but it not working. I know that I can create another datatable and do select form first one, but I don't think that this is efficient way.How can I sort my dataTable and return it to my gridview
View 3 RepliesI'm getting some Xml back from a service. I would like it to be the datasource of a grid view on my aspx page. Here is a sample of the Xml
<?xml version="1.0" encoding="utf-16" ?>
<ArrayOfTripTollCompleteDC xmlns:xsi=[URL]"
xmlns:xsd=[URL]>
<TripTollCompleteDC>
<TripTollId>5</TripTollId>
<DMSLaneModeID xsi:nil="true" />
<HOVOnly>false</HOVOnly>
<CreateDateTime>2010-06-07T15:54:01.023</CreateDateTime>
<ConfigVTMSDelaySeconds>5</ConfigVTMSDelaySeconds>
</TripTollCompleteDC>
and here is my code that parses the xml and tries to bind the grid. What am I missing here?
var retVal = service.GetTripDetailsByTripID(tripId);
var xmlTrips = XDocument.Parse(retVal);
var tripTolls =
from t in xmlTrips.Elements("TripTollCompleteDC")
select new {
TripTollId = (int)t.Element("TripTollId")
, DMSLaneModeID = (int?)t.Element("DMSLaneModeID")
, HOVOnly = (bool)t.Element("HOVOnly")
, CreateDateTime = (DateTime)t.Element("CreateDateTime")
, ConfigVTMSDelaySeconds = (int)t.Element("ConfigVTMSDelaySeconds")
};
grdTripDetails.DataSource = tripTolls;
grdTripDetails.DataBind();
I realize these are anonymous types. Is that a problem? I have verified the service is returning the Xml as stated above. Can anyone out there point me in the right direction? Just for completeness, here is the grid markup <asp:GridView runat="server" ID="grdTripDetails" />
Have a GridView with a templated select button hidden and using
e.Row.Attributes.Add("onclick",Page.ClientScript.GetPostBackEventReference(this.grdMaster, "Select$" + e.Row.RowIndex.ToString())); to select a row .
When user like to update the datasource he will select one row from gridview then in selected indexchanged event i would display the selected row values beneath the form under the grid , Then user will update the contents displayed from grid and click an update button which is outside the grid . After updating the displayed row , i got to get the values of the next row in the grid and display them for next updation , i'e if users maually selects row 3 from grid then he can update the values using the update button and then on update click itself i'll have to display next row contents of row 4 and this process could go on .
I have Parent/Child Grid (also called Nested Grids).
Parent Grid (PG) :: PG has two template fields. 1st template field has "Category ID" and 2nd template has Child Grid
Child Grid (CG) :: CG is populated in PG's RowDataBund event based on "Category ID". In CG's DataBound event, I am doing something which I need to display in CG's footer row.
Problem :: In the footer row of each CG, I have to show the "Category ID" which is in PG' row. How can I get hold of the PG's row which hascurrent nested grid (there will 'n' child grids, one for each 'Category ID' in the PG ) so I can read the "Category ID"
I was thinking if I could do something (DataBound event of CG) like this..
string catId = ChildGrid.Parent[get the index of the current row in PG].Cells[0].Text;
i am trying to add subtotal in gridfooter with has grid inside grid
View 1 RepliesI have class Person, having two properties First Name and Last Name, if I set array of person as Data Source to GridView how can I show both First Name and Last Name in one column?/
View 2 RepliesI am trying to create a second grid in the same page with detailed info for a given record of the first Grid, but when I press select in the first grid nothing happens. I follwed everything I read.
<asp:GridView runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" style="margin-right: 0px" Width="659px"
AutoGenerateDeleteButton="True" AutoGenerateEditButton="True"
AllowSorting="True" DataKeyNames="accession_num,organ"
EnablePersistedSelection="True" EnableSortingAndPagingCallbacks="True" onselectedindexchanged="Unnamed1_SelectedIndexChanged"
>
<Columns>
<asp:BoundField DataField="organ" HeaderText="organ"
SortExpression="organ" />
<asp:BoundField DataField="weight" HeaderText="weight"
SortExpression="weight" />
<asp:BoundField DataField="unit" HeaderText="unit" SortExpression="unit" />
<asp:BoundField DataField="accession_num" HeaderText="accession_num"
ReadOnly="True" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:pdmstestConnectionString %>"
SelectCommand="GetGrossOrgan" SelectCommandType="StoredProcedure"
UpdateCommand="UpdateGrossOrgan" UpdateCommandType="StoredProcedure"
DeleteCommand="DELETE FROM [Pathology_Gross_Organ] WHERE [accession_num] = @accession_num AND [organ] = @original_organ"
OldValuesParameterFormatString="original_{0}"
> <SelectParameters>
<asp:ControlParameter ControlID="accession_num" Name="accession_num"
PropertyName="Text" Type="String"/>
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="accession_num" Type="String" />
<asp:Parameter Name="original_organ" Type="String"/>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="accession_num" Type="String"/>
<asp:Parameter Name="organ" Type="String"/>
<asp:Parameter Name="weight" Type="Int16" />
<asp:Parameter Name="unit" Type="String"/>
</UpdateParameters>
</asp:SqlDataSource>
I have a grid view that does add, edit update and delete. ( I draged the grid to the aspx page ) it is working. I would like to have the following : once I lick on edit, I open a form inside the grid view to edit the fields. How can I do that.
View 4 RepliesI'm using ASP.NET/VB and am wanting to nest a grid inside of another grid. I've seen them but am unsure how to make them work. I have a Orders table with an OrderID and it is linked to a Orders_Detail table. I would like to be able to select the order and see the details. I've done it differently with 2 grids outside of each other, but this isn't the solution I need.
View 1 RepliesIn gridview I am able to sort on 1 column as mentioned below, I want to add one more column in sorting, what is the best way to do this,
[Code]....
how to Add images in column but the column have data and the images will added with data but each data in cell have image
Example
i have phone and there is
Missed Call
Incoming Call
Outgoing Call
in same column
how to add image per data cell
How add programatily or dynamic column in grid view
i have an sql table of 3 colums
ID,Product,Week
every time i insert a a row inmy database table
i want to add this column to gridview
in another way gridview will be expandable
this is the layout of the grid:
ID ProductName Week1
Second time i added week2 to database row grid layout like this:
ID ProductName Week1 Week2 (here i want to add week2 column because a new row is inserted to my sql table)
grid now have 5 columns (the fifth is week5)
ID ProductName Week1 Week2 week5
i have a grid view myGridView. I populate this gridview in the page load event as:
myClass newObj = new myClass();
myGridView.datasource = newObj.getItems();
myGridView.databind();
Now I wanted to hide some of the columns of the grid view. How I can do that?
I need to add dynamic header column to grid Urgent from database table
how can i achieve this
my gridview should be expandable horizantally
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 want to select the row of telerik radgrid and get the value of column 1For thi can't use select or deselect columns, Here i want to select row by clicking only.here I also require code to get the value of column 1 of selected row
View 4 Replieshow 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'm currently binding a simple grid and show. And a separate dropdown and show. Now I want to place dropdown in grid and bind also I will able to change value of dropdown and save.Problem in grid binding drop down not able to find datasource.my code as -
<asp:TemplateField HeaderText="REPORTING TO" Visible ="true" SortExpression="reporting_to">
<ItemTemplate>
<asp:Label ID="Lnk_ReportingTo" unat="server" text="<%# bind('reporting_to' ) %>" ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
//Binding grid
public void BindData()
{
//Calling To Dal From BLL LAYER
DataSet ds = musergroupBLL.GetUserGroup(0, UserFk, 0);
Grd_UserRole.DataSource = ds;
Grd_UserRole.DataBind();
}
For dropdown fill in page on .aspx
<asp:DropDownList ID="DDManager" runat="server" onselectedindexchanged="DDManager_SelectedIndexChanged"></asp:DropDownList>
On .cs
protected void FillDD()
{
DataSet ds = MUsrBll.GetUser(MUsrolEnt);
DDManager.DataSource = ds;
DDManager.DataTextField = "usr_id";
DDManager.DataValueField = "usr_PK";
DDManager.DataBind();
}
Till here every thing is workingfor simple grid.
<asp:TemplateField HeaderText="REPORTING TO" Visible ="true" SortExpression="reporting_to">
<ItemTemplate>
<asp:Label ID="Lnk_ReportingTo" unat="server" text="<%# bind('reporting_to' ) %>" ></asp:Label>
</ItemTemplate>
</asp:TemplateField>
Now changing above code from below aspx code for dropdown place in grid. But not getting how to call datasource and selected value in grid. Data source is same as FillDD()function above for dropdown.
<asp:TemplateField HeaderText="REPORTING TO" Visible ="true" SortExpression="reporting_to">
<ItemTemplate>
<asp:DropDownList ID="Lnk_ReportingTo111" SelectedValue='<%# bind('reporting_to' )%>' DataSource = "<%# bind('usr_PK' )%>" DataTextField = "usr_id" DataValueField = "usr_PK" runat="server" ></asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
