Forms Data Controls :: Add Two Lists To The Same Grid Which Are Returning Different Values And Display?
Dec 15, 2010
I have 2 two listitems. Each list returns different rows. I want to combine both the list rows and disaply it in single grid.
List<somedata> grid1=new List<somedata>
List<somedata> grid2=new List<somedata>
I am getting values in grid1 and grid2. Each list values i am binding to 2 different grids
I want to bind both grid1 and grid2 to the same grid
For example: something like this : grd.datasource=grid1+grid2;
grd.databind();
View 3 Replies
Similar Messages:
Oct 27, 2010
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
View 2 Replies
Mar 4, 2011
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)
View 3 Replies
Mar 13, 2010
I've got and SqlDataSource bound to a GridView, and I'd like to return the value of one of the fields from the SqlDataSource during GridView.RowCreated (I think). At the same time, one of the fields I'm returning to the GridView has a Null value, which I'm cool with, but Runtime is complaining about it so how can I get around errors relating to Null values in my tables?
View 8 Replies
Mar 12, 2010
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;
View 2 Replies
Sep 2, 2010
I'm trying to retreive values entered by users in the textboxes in the footer of the gridview and insert these values into another sql table.My code is as follows :-
protected void GridView2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if(e.CommandName.Equals("addnew"))
{
TextBox t1 = (TextBox)GridView2.FooterRow.FindControl("tfrm");
string frm = t1.Text;
TextBox t2 = (TextBox)GridView2.FooterRow.FindControl("tsub");
string sub = t2.Text;
string cmd = "insert into suggestions values('" + frm + "','" + sub + "','c','c')";
con.Open();
SqlCommand com = new SqlCommand(cmd,con);
int a = com.ExecuteNonQuery();
GridView2.DataBind();
con.Close();
}
}
But the strings 'frm' and 'sub' returns null values.
View 8 Replies
Feb 9, 2011
I am doing a online web application whereby user is able to enter in new template as well as search for template. The Add template is located outside the grid view and if user clicks on the button, it will load the grid view that is populated with data as there is a row of empty fields at the bottom. However when I click on the Add Template button, the grid view does not appear.
This is my business logic that I used it to search for records as well to click on the Add Template button to add in new records:
[Code]....
[Code]....
[Code]....
View 6 Replies
Jun 8, 2010
i have a grid view which displays only one value and i need to extract that value and display it in a textbox?
View 4 Replies
Feb 8, 2011
I'm designing a page which makes an ajax call (via jQuery.ajax) to a page method on the server side.On the server side, I have two classes: Agent and Channel.
In the page method, I'd like to return a List<Agent> and a List<Channel> to the client side. How can I return two lists to client side? should wrap them up in one class like:
[code]....
View 4 Replies
Jun 28, 2010
During rowdatabound event I am getting values for rowcount in debug mode but I am not getting values for the cells of the grid. But After rendering I am getting values for the grid in the browser. I am not using codebehind for databind() to the grid. Here is the code.
<asp:SqlDataSource ID="SqlDataSourceView" runat="server"
ConnectionString="<%$ ConnectionStrings:HariTechDBConnectionString %>"
electCommand="SELECT DISTINCT [JobTitle], [JobDescription] ,[JobId]FROM [ManageJob] WHERE ([InactiveDate] <= SYSDATETIME())">
[code]...
View 7 Replies
Mar 14, 2011
I have a grid view which displays some values. now i have to calculate row wise sum of those values for each row and then display against them.i tried this code but i am getting error as Input String Was not in Correct Format.
public void gv_RowCreated(Object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int total = Convert.ToInt32(e.Row.Cells[1].Text) + Convert.ToInt32(e.Row.Cells[2].Text) + Convert.ToInt32(e.Row.Cells[3].Text) + Convert.ToInt32(e.Row.Cells[4].Text) + Convert.ToInt32(e.Row.Cells[5].Text) + Convert.ToInt32(e.Row.Cells[6].Text) + Convert.ToInt32(e.Row.Cells[7].Text);
((Label)gv.FindControl("Label8")).Text = Convert.ToString(total);
}
}
View 2 Replies
May 14, 2010
I want edit the perticular row which i selected(clicked),
when ever i click on edit button which in Gridview ,all the values which relavant information should go in to Text boxes.
here is my code ASPX:
<asp:GridView ID="GridView1" runat="server"
View 7 Replies
Dec 8, 2010
I retrieving user selected values from my first page with session.
I need to list product details whcih user selected separately. I mean if user selected
Products 1,5,7 Second page listing product details separately 1,5,7 in gridview1, gridview2, gridview3.
View 6 Replies
Apr 15, 2010
I need to get data from all rows which are selected (check box enabled). Can anyone give me hint? I am killing myself for last 10 houres with this.
What i need to say is that datasource is xml file
View 4 Replies
Oct 24, 2010
I have 2 columns (name and address) in a gridview which are defined as linked buttons. Now when i click on a record in the first row (name) i am able to pass that value (selected name) to another page with rowcommand. Now i am trying to click on the second row (address) on a record but am not able to pass that value to the second page. Don't actually know how to define this in the code below. The first row (name) has to redirect to one page (this what i have already accomplished) and the second row (address) has to redirect to another page
<asp:TemplateField HeaderText="Name">
<ItemTemplate>
<asp:LinkButton ID="LnkBtnName" runat="server" CommandArgument='<%# Container.DataItem("Name") %>' Text='<%# Eval("Name") %>' CommandName="go" >LinkButton</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Address">
<ItemTemplate>
<asp:LinkButton ID="LnkBtnAddress" runat="server" CommandArgument='<%# Container.DataItem("Address") %>' Text='<%# Eval("Address") %>' CommandName="go" >LinkButton</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
Protected Sub GridView_RowCommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles GridView.RowCommand
Dim strName As String = CType(e.CommandArgument, String)
Response.Redirect(String.Format("Test.aspx?id={0}", strName, False))
End Sub
CODE ON PAGE II:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
LblName.Text = Request.QueryString("id")
End Sub
View 3 Replies
Dec 29, 2010
i want update record of Photo table with linq to sql so i create a sproc for it
i dispaly records of Photo table into the Gridview untill when user click on the update command
can updating selected row in a set of textbox
how can i fetch Fields value of selected row for put in the textboxs and updating them?
how can i bind DDLCategory to CategoryDatasource with coding?
i want when i select cotegory from DDLCategory ,gridview has been changed?
[Code]....
View 13 Replies
Mar 28, 2010
I have a grid view and I added edit and Save buttons to it. When I click on edit I am able to edit the data but when I click on save I amgetting the data before edit.
Please see my code below.
Eg: I have start date as 2005-10-10 12:00 AM so After I click On edit it is letting me to edit, So If I edit the start date to 2010-10-10 12:00 PM and click on the save button I am stil getting the old start date. which is 2005-10-10 12:00 AM instead of 2010-10-10 12:00 PM
<asp:GridView ID="gvPosHistory" runat="server" AutoGenerateColumns="False" AllowPaging="True"
AllowSorting="true" Width="650px" PageSize="20" CssClass="Gridview" Visible="false"
OnRowCommand="gvPosHistory_RowCommand"
OnRowDataBound="gvPosHistory_RowDataBound"
OnRowEditing="gvPosHistory_RowEditing"
OnRowUpdating="gvPosHistory_RowUpdating"
onrowcancelingedit="gvPosHistory_RowCancelingEdit" >
<Columns>
<asp:TemplateField HeaderText="Start Date" SortExpression="startDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblstartdate" runat="server" text='<%# Eval("StartDate")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtStartDate" runat="server" Text='<%# Bind("StartDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="End Date" SortExpression="endDate">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblenddate" runat="server" text='<%# Eval("EndDate")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtEndDate" runat="server" Text='<%# Bind("EndDate")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Functional Job Title" SortExpression="JobTitle">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblFunctjobTitle" runat="server" text='<%# Eval("FunctionalJobTitle")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtFuncJobTitle" runat="server" text='<%# Bind("FunctionalJobTitle")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Department" SortExpression="Department">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblDepartment" runat="server" text='<%# Eval("DeptName")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtDeptName" runat="server" Text='<%# Bind("DeptName")%>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Supervisor" SortExpression="Supervisor">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblSupervisor" runat="server" text='<%# Eval("Supervisor")%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtSupervisor" runat="server" Text='<%# Bind("Supervisor")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Bargaining Unit" SortExpression="bargainingunit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblbargainingunit" runat="server" text='<%# Eval("BargainingUnit")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtBargainingUnit" runat="server" text='<%# Bind("BargainingUnit")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="UCP Level" SortExpression="UCPlevel">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center"
VerticalAlign="Top" />
<ItemStyle Wrap="False" HorizontalAlign="Left" />
<ItemTemplate>
<asp:Label ID="lblUCPlevel" runat="server" text='<%# Eval("UCPLevel")%>' ></asp:Label>
</ItemTemplate>
<EditItemTemplate >
<asp:TextBox ID="txtUcpLevel" runat="server" Text='<%#Bind("UCPLevel")%>' ></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Edit" SortExpression="Edit">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<ItemTemplate>
<asp:LinkButton ID="LBPosHistoryEdit" Text="Edit" runat="server" CommandName="Edit" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Save" SortExpression="Save">
<HeaderStyle Wrap="False" Font-Bold="True" HorizontalAlign="Center" VerticalAlign="Top" />
<ItemStyle Wrap="True" HorizontalAlign="Left" />
<EditItemTemplate>
<asp:LinkButton ID="LBPosHistorySave" Text="Save" runat="server" CommandName="SavePosHistory" CommandArgument='<%# Eval("UCPLevel")%>' ></asp:LinkButton>
</EditItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
.aspx.cs
protected void gvPosHistory_RowCommand(object source, GridViewCommandEventArgs e)
{
if (e.CommandName == "SavePosHistory")
{
string arg = Convert.ToString(e.CommandArgument);
System.Web.UI.WebControls.LinkButton btnPosHistory = e.CommandSource as System.Web.UI.WebControls.LinkButton;
GridViewRow row = btnPosHistory.NamingContainer as GridViewRow;
TextBox tSdate = row.FindControl("txtStartDate") as TextBox;
TextBox tEdate = row.FindControl("txtEndDate") as TextBox;
TextBox tFuncJobTitle = row.FindControl("txtFuncJobTitle") as TextBox;
TextBox tDeptName = row.FindControl("txtDeptName") as TextBox;
TextBox tSupervisor = row.FindControl("txtSupervisor") as TextBox;
TextBox tBargainingUnit = row.FindControl("txtBargainingUnit") as TextBox;
TextBox tUCPLevel = row.FindControl("txtUcpLevel") as TextBox;
}
}
View 1 Replies
Feb 17, 2010
1, select Itemname,
2,based on Itemname it ll get the avaliable qty and serial no,
3, while click the select button, all the values ll stored in to grid view,
upto this i did and even i have check weather the serial no avaliable for duplication, but now i have situation like, when i select more then one serial no, it ll stored in the new row in the grid, so the item name and aveliable qty , repeatedly so now i want to change the display format, like.,
Item name Avaliable Qty Serial No
AA 3 12345,36545,
before it look like :
Item name Avaliable Qty Serial No
AA 3 12345,
AA 3 36545
AA 3 78954
so tell ur openion, and and how to handle this, and while submitting i have to send this as an XML format.
View 4 Replies
Sep 22, 2010
when the user chooses high priority ( may be as a radio button) in front end asp.net form, the database saves the priority state and according to it in the report form, based on the priority it should show a colored symbol : ex: for high priority red color dot.. and for low priority blue dot.. is it possible to implement using grid view?? im going to implement this in mobile...
View 4 Replies
Jun 22, 2010
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]....
View 6 Replies
Aug 14, 2010
I have a search button ..The result will be displayed in grid view if the button is pressed .. i am able to do it
But now i want to do like this ..that is my grid view is only displaying the ResultId .. I want to display the ResultName rather than resultID in the table
View 5 Replies
Jan 26, 2011
I have a GridView control that has a SQLDataSource.
The GridView provides me with a list of musical artists (from the tblArtists)
In the Grid, I have a field, FKGenreID, that is a Foreign Key value for music Genres.
(An example of the data in that field would be "7", which upon lookup would mean Classical in the
tblGenreList table.)
What I'd like to do is add a DropDownList control that looks up the tblGenreList table and populates the DropDownList with the ID and Description from the tblGenreList Lookup table.
Now the tricky part is that if the GridView field (FKGenreID) has a value, then I'd like the corresponding Genre Description to be displayed in the DropDownList
Alternately, if there is no value for FKGenreID in the GridView, then I'd like the DropDownList to show that nothing was selected, but have the list of Genres available.
Most importantly here, when the user makes a selection, I'd like the GenreID (from the DropDownList) to be entered into the FKGenreID field in the GridView field.
My thought is that a gridview record may or may not have a value in the FKGenreID field. Either way, the DropDownList is bound to that field. The DropDownList would display a list ofGenre Descriptions for the user to select from. Upon selection, the GenreID column of the DropDownList becomes the value in for the FKGenreID field in the GridView.
Is this possible?
In case it matters, I'm using ASP.NET 4, Visual Studio 2010, and coding in VB
View 1 Replies
Mar 28, 2010
I have a grid view and I am unable to get the values that I edited from the grid view using below code. Can Any one look into it and advise what is wrong with my code?
View 11 Replies
May 5, 2010
see a lot about gridview in pop up but in my case i have a grid view in main page with a textbox in its templete and a button when ever button for every row clicked the pop up window open user enter a value and press a button in pop up i want the text user enter in textbox in pop up to place in text box in the row that user click the button
View 2 Replies
Feb 23, 2011
how to write a code to search the data and display it in the grid view when a search button is clicked ..
View 2 Replies
