Solved

Adding to Gridview from empty table

Posted on 2007-11-13
7
1,304 Views
Last Modified: 2013-11-26
Hello,

I'm trying to use a Gridview to add data to a dataset Datatable starting with a blank Gridview.  I know the columns for it and they fixed.  What I would like to do is be able to have a blank row in the Gridview show up on page load and then be able add N number of rows.  In the end, i'd like to do some calculations on the data and then submit it to a DB.  but thats later on down the road.  My first step is to show a blank GridView and be able to add to it.  Any ideas?  

thanks,
0
Comment
Question by:kevinmeredith
  • 4
  • 3
7 Comments
 
LVL 3

Accepted Solution

by:
ITTechSolver earned 205 total points
ID: 20275177
1) empty row insert:
Try to look at this. Btw there are many of modified gridviews, maybe you can find even better or somebody recommends his best.
http://www.codeproject.com/useritems/GridView_with_insert_line.asp
0
 

Author Comment

by:kevinmeredith
ID: 20275612
thanks ITTechSolver.

I'm trying to look for something that will work using just the GridView and add another control like this is doing.  Any ideas?

thanks
0
 

Author Comment

by:kevinmeredith
ID: 20275715
I was also wondering how i could do this using a DataSet in and not use a SQL DB.  thanks again for your help, i reallly appreciate it
0
The New “Normal” in Modern Enterprise Operations

DevOps for the modern enterprise offers many benefits — increased agility, productivity, and more, but digital transformation isn’t easy, especially if you’re not addressing the right issues. Register for the webinar to dive into the “new normal” for enterprise modern ops.

 
LVL 3

Expert Comment

by:ITTechSolver
ID: 20275932
I think you can use only a table from a dataset, but you can use ObjectDataSource and use some methods there. Then you can write down method that will cooperate with whole dataset.
My colegue is like you, yesterday he asked me the same question and my answer was to use no data - gridviewrow that have display: disabled; style setup. I will ask him after 8 hrs, how he solved that.
I think you can access at event RowDataBound, GridViewRow and set the style for it. I know, this is poor sollution. ;)
0
 

Author Comment

by:kevinmeredith
ID: 20276979
thats what i want to do is use a table from a dataset.  definitely let me know what he says.  thanks!
0
 
LVL 3

Expert Comment

by:ITTechSolver
ID: 20296836


So the first row is some nodata row at the table.

I think, You can bind DataTable to the GridView as DataSource - from ResultSet get your disered table. You have to manually call DataBind(). I know, that I did some DataTableDataSource, if it will not work..
// He used system that I proposed, but instead of style setup, he used Visible change (this is his code):
 
        protected void gv_RowDataBound(Object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow && ((GridView)sender).Rows.Count < 1)
            {
                e.Row.Visible = false;
            }
        }

Open in new window

0
 

Author Comment

by:kevinmeredith
ID: 20298756
thanks ITTechSolver
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entity Framework is a powerful tool to help you interact with the DataBase but still doesn't help much when we have a Stored Procedure that returns more than one resultset. The solution takes some of out-of-the-box thinking; read on!
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question