.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

how to One GridView (table ) Copy to other page Gridview (table)

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :ASP.Net

how to One GridView (table ) Copy to other page  Gridview (table)

View Complete Post

More Related Resource Links

gridview table alignment problem

hi all, i designed a gridiview, within that ItemTemplate i drew an table then tr then some of td's, now the problem is after every row im getting one empty row, what is the problem and how to resolve it. below is my code <ItemTemplate>                                             <table cellspacing="0" cellpadding="0" style="border-right:1px solid Black;" >                                                 <tr  >                                                     <td width="1%" align="center" style="border-right:1px solid Black;">          &n

Copy table (with content and links) from one page to another

Hi, I'm new to sharepoint and learning this software on my own.  I'm running WinXP Professional.  I've created a table on one page in a subfolder/directory (10Kgold) and would like to use the same table on a page in a different subfolder (24Kgold).  Both subfolders are in the same root folder.  Here are the steps I took: On 10kgold/bracelets.aspx page: right-click on element to copy --> select Copy On 24kgold/bracelets.aspx page: right-click --> Paste On the 24kgold/bracelets page, the "Paste" option was disabled, so then I knew I wouldn't be able to copy/paste the table I copied from 10K gold/bracelets page. I don't want to recreate this table again if I don't have to. Also, I've tried to copy and paste links within the same page, but that doesn't work either. Here are the steps: Select link (yellow-gold) on 10kgold/bracelets page: right-click --> Copy Scroll to where I want to paste the link Right-click (yellow-gold) on 24kgold/bracelets page: --> Paste Is there a way to copy and paste links and tables, etc. from one page to another, with the page/s being in either the same subfolder and/or a different subfolder as long as they are within the same root folder? Thanks in advance for your help.    

hoq to fill gridview dropdownlist from another db table

Hi, I have a gridview which gets its data from a database table now i ghave added a dropdownlist to this gridview but this dropdown should get the data from another table and should set its value automatically with a foreign key from the  gridview i have added the code like below in my rowDatabound but it just loads 1 field and then how should i get the selectedValue according to the gridview id field?? Protected Sub Friends_RowDataBound(ByVal sender As Object, ByVal e As GridViewRowEventArgs)             If e.Row.RowType = DataControlRowType.DataRow Then                 Dim conn As New SqlConnection(HttpRuntime.Cache("con"))                Dim sql As String = "select ID,ListName from FriendList order by ListName asc"                Dim cmd As New SqlCommand(sql, conn)                cmd.CommandType = CommandType.Text                conn.Open()             &

pull some data from a table twice for same gridview


 Hello all - I have been searching google for a solution to this problem but I'm having difficulty describing it in keywords.

environment:  VWD 2010 Express, VB, SQL Express, .NET 4.0

I have a gridview that currently pulls data from a table called CrossRef which has the ID numbers of tasks that need to go in a certain sequence.  So the gridview looks like:

Task 1       Sequence          Task 2           XRefID

10               BEFORE             22                 4

2                AFTER                6                  5

17              BEFORE              2        

How to INSERT GridView data into another table (besides the one it is bound to)??


Hi All,

I have a tricky situation that I just cannot seem to figure out.  I'm using ASP.NET 4.0.  I have two databases (let's call them Northwind and MyDatabase for simplicity).  I cannot modify the data in Northwind, but once I save a copy to MyDatabase, I can change it.

I have a GridView that shows all the tests associated with a patient.  I first populate the GridView, retrieving all the tests in Northwind.Test that are associated to a PatientID.  On a button click event, I need to:

  1. Create a new Patient record in MyDatabase.Patient (I've got this part done already).
  2. Use that newly created PatientID and INSERT all of the rows from the GridView into MyDatabase.Test.  I have the PatientID available, I just don't know how to retrieve the data from the GridView.
  3. (Ideally) I would like to then be able to load that patient record in the future from MyDatabase and be able to UPDATE the tests in the GridView to MyDatabase.Test.

I can load the tests into the GridView no problem.  But I have no idea how I would save that data to a different datasource.  Any ideas?  Should I even be using a GridView, or something else?

-Thanks in advance-

get a correct row index after refresh the gridview table


hi all,

i am facing a problem to get a correct row index after i filter the data in table, it always keep the history row index in the table  before i filter. i had a search button to filter the data in gridview,

below is my coding:


 <asp:Button ID="btn_reissue" runat="server" Text="Reissue" CommandName="reissue"  CommandArgument='<%# CType(Container, GridViewRow).RowIndex %>' OnClientClick="return window.confirm('Are you sure you want to reissue this record?');" Width="65px" />


    Protected Sub grdview_rowcommand(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewCommandEventArgs) Handles gridView1.RowCommand
        Dim cmd As SqlCommand
        If e.CommandName = "reissue" Then
            If Not pUser Is Nothing Then
                pDbUserCon = New SqlConnection(pDbESS)
                pDbUserTrx = pDbUserCon.BeginTransaction()
                    Dim index As Integer = Convert.ToInt32(e.CommandArgument)
                    Dim row As GridViewRow

GridView - table v/s SqlDataSource ?


Hi all,

I have a gridview which i need to populate from a products database, where a user can click on a certain

product (row) and gets directed to a new page with that product ID (where he will see the product details

and so on..)

while this seems easy if i bind the gridview to a SQL Datasource, i face few problems:

1- I need to trim the product descrption and only display the first 30 characters ; some products descrption

is much more than 30 characters and i dont want to display all of it in the gridview ..

2- there is a date/time field in my sql query, which appears in the gridview as "10/21/2010 12:00:00 AM". I

don't want to display the time stamp, but only the date. any idea how?

3- if there are no data to display , the gridview header (product name, product description, entry date,

etc..) will disappear and thus the user will be confused..

As a workaround, I'm thinking of capturing the date in a Datatable, after having manipulated it as required

above, and them running a databind on the gridview, which is feasible but has its own challenges:

1- how do u display a URL with the product ID as a variable?

I'm guessing the first method is better, but I couldn't figure it out...

Gridview Header & table data alignment problem



Newbie to ASP.net. Programming in C#.

I'm querying a SQL database and displaying the results in a gridview.

The results can be many records so I need to provide the facility to scroll. To display the headers when scroling I have implemented ( in my asp code) the headers in another table and the data is in another table. I see now I cannot align the column headers with the table data.

Appreciate any help to fix this issue.

If this method is not a good one to display headers with data please suggest another method.( Some example code guidance would really help)

Here is my ASP code.

<div id="divProjectTableHeaderFullDetail" runat="server" style="background-color: #993300;
            height: 40px; width: 770px; margin: 0;  padding: 0 ; " >
            <table style="font-family: Arial; font-size: 10pt; color: white;" cellspacing="0"

using data in a gridview to update a table



I have a gridview that gathers data from two tables, an orders table and a products table. I have an OrderQuantity from the Orders table and a StockQuantity from the Products table and a button to process the order.

I am trying to move through the GridView one line at the time, substract the OrderQuantity from the StockQuantity and update the Product table.

How do I move through the GridView?



aading daynamic row and accessing its value at server side(gridview/Table)


i am facing problam to create  a table/gridview having 3 colom  (1st check box,2nd Dropdown(populated from DB),3rdTextbox(empty))

i also want to ADD MORE ROW button to add new row with all 3 colom in newly created row in gridview.(using java script only/or client side )

how can i access this gridview and its control value(entered by User) at server side(asp.net C# .cs Page).

please paste any suitable code for this


Bulk Copy From Datatable To SQL Server Table


 I have read the data of a excle file and captured the data into the dataset to a datatable, now that data is to be inserted into a SQL Server table using bulk copy option. I am using -

 public bool BulkEnterData(DataTable dt, string tblName)
        SqlBulkCopy bulk = new SqlBulkCopy(con);
        bulk.DestinationTableName = tblName;

        return true;

ERROR Getting-
A transport-level error has occurred when receiving results from the server. (provider: Shared Memory Provider, error: 0 - The pipe has been ended.) 

How to resolve the above problem or any other solution is available.


update parentpage gridview with the values from child page?


hi   i am having a gridview on each row i am having a update and add button.

on click of either of the button i am opening a popup where the end user will enter data and on clck of ok button in the child page

based on the click ie

if i clicked update i need to update that particular row with the values from child page.

if i clicked on add i need to add a row below the row where i clicked add button .

can anyone help me with this?

Gridview extends past edge of div and page when editing users


I have a gridview pulling all data from one user. This gridview has an edit button and when that is clicked the gridview becomes too wide for the div/screen and I get a scroll bar. Since this gridview can only have one user in it anyway is it possible to display each field on seperate lines instead?

Adding table to a page, but the format lost when I use clear border



I added a table to a page, by default, the table layout is the light border. So, I add my content and the vertical align seems to set to the top. But when I changed it to clear border, the content of the table will set vertical align to center. Is there a way to change this back to top align but with the clear border. I don't think I can do this by what is available in the ribbon. Please advice.

Gridview Sorting and Page Orientation


Hi there,

I have looked at several posts on Gridview sorting but can't seem to get it to work in my code. I am using Subsonic objects as the DataSource. Every time I click on a page or sorting link it does a postback but the page orientation is left at the top, not where the gridview is on the page. Is there a way around this?

This is the code I have written for it:

        protected void PublicNoticeGridview_Sorting(Object sender, GridViewSortEventArgs e)
            MidvaleSiteDBDB db = new MidvaleSiteDBDB();
            SqlQuery pubNoticeQuery = db.Select.From<publicnotice>();

How to copy table data from test to production database

I'm using SQL Server 2008 R2 and I'd like to copy all data rows from one table of a test database to the identical table in a production database. The primary key of the table is referred to by other tables so a DELETE followed by a number of INSERTs won't do it because of referential integrity issues. What is the best method to replace the data rows in the destination database with the values from the source database? Thanks, Guido

Master-Detail GridView in Single Page example with paging throws error

___http://www.java2s.com/Code/ASP/Data-Binding/MasterDetailGridViewinSinglePage.htmI followed example at the link above.When I enablind paging=true (by pagesize=3).and clicking to pages 2|3|4 etc and so;error occuringIndex was out of range. Must be non-negative and less than the size of the collection.at cs line :sourceProducts.SelectParameters[0].DefaultValue = gridMaster.DataKeys[e.Row.DataItemIndex].Value.ToString();got any idea?what should I make to fix this ? is this error  fixable ?thanks much.
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend