How to insert the data from the textbox into the empty rows of grid

Question

2.00/5 (1 vote)

See more:

I want to show 16 empty rows in a gridview of asp.net. I have a button and textbox outside the grid, on a button click, I have to insert the data from the textbox into the grid but the problem is that the data inserted after the 16 rows. How the data will be inserted in empty rows first.? I bound the datasource with null but the grid is not visible so i create the rows on pageload event.

C#

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               DataTable dtSource = new DataTable();
                    dtSource.Columns.Add("DateTime");
                    dtSource.Columns.Add("Detail");
                    dtSource.Columns.Add("Status");
                    dtSource.Columns.Add("Cancel");
                   for (int i = 0; i <= 15; i++)
                     {
                       dtSource.Rows.Add("", " ", " ", " ");
                     }
                    ViewState["dtSource"] = dtSource;
                    gridItem.DataSource = dtSource;
                    gridItem.DataBind();

            }
        }

and here is the code for the button

C#

protected void btnAdd(object sender, EventArgs e)
        {
            DataTable dtSource = ViewState["dtSource"] as DataTable;          
            DataRow dr = dtSource.NewRow();
            dtSource.Rows.Add(DateTime.Now, itemDetail, "", "");
            gridItem.DataSource = dtSource;
            gridItem.DataBind();
            ViewState["dtSource"] = dtSource;
        }

Posted 28-Sep-15 6:43am

F.mas27

Add a Solution

Comments

JagadishBB 28-Sep-15 13:06pm

Before adding to the row to table , clone a new table without blank rows and add it , balance again you can add it again

F.mas27 28-Sep-15 13:12pm

I am new to this. Wil you please elaborate it with example. Thankyou

Rojalin Sahoo 29-Sep-15 2:12am

Don't known about your requirement.you can try dynamic grid-view. visit this may help you https://rojalinsahoo.wordpress.com/2015/08/01/dynamic-gridview/

2 solutions

Solution 3

Try this
Change your variables accordingly

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
DataTable dtSource = new DataTable();
dtSource.Columns.Add("DateTime");
dtSource.Columns.Add("Detail");
dtSource.Columns.Add("Status");
dtSource.Columns.Add("Cancel");

ViewState["dtSource"] = dtSource;
gvCustomers.DataSource = dtSource;
gvCustomers.DataBind();
}
catch (Exception ex)
{ }
}
}

protected void btnClick_Click(object sender, EventArgs e)
{
try
{
DataTable dtSource = ViewState["dtSource"] as DataTable;
dtSource.Rows.Add(DateTime.Now, txtFill.Text, " ", " ");
gvCustomers.DataSource = dtSource;
gvCustomers.DataBind();
}
catch (Exception ex)
{ }
}

Posted 28-Sep-15 21:09pm

Vipul6264

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Rojalin Sahoo · Accepted Answer · 2015-09-28T20:19:00

As per your code you written

DataRow dr = dtSource.NewRow(); // this line add new rows to grid-view
dtSource.Rows.Add(DateTime.Now, itemDetail, "", "");

May this solution help you:

C#

protected void btn1_Click(object sender, EventArgs e)
        {
            if(!string.IsNullOrEmpty(text1.Text))
            {
            string itemDetail = text1.Text;
            DataTable dtSource = ViewState["dtSource"] as DataTable;
            if(dtSource.Rows.Count<16) //change the values in blank field
            {
              foreach(DataRow dr in dtSource.Rows)
              {
                if (dr["DateTime"].ToString() == "" && dr["Detail"].ToString() == " ")
                  {
                    dr["DateTime"] = DateTime.Now.ToString();
                    dr["Detail"] = itemDetail;
                    break;
                    }
                }
            }
            else{ // add new row if no rows are blank.
              DataRow dr = dtSource.NewRow();
              dtSource.Rows.Add(DateTime.Now, itemDetail, "", "");
            }
            grid1.DataSource = dtSource;
            grid1.DataBind();
            ViewState["dtSource"] = dtSource;
        }
        }