Solved

Adding to Gridview from empty table

Posted on 2007-11-13
7
1,303 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
Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

This article is for Object-Oriented Programming (OOP) beginners. An Interface contains declarations of events, indexers, methods and/or properties. Any class which implements the Interface should provide the concrete implementation for each Inter…
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!
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

832 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