Add new row to existing DataTable using C# .Net

ullas.kr...

SOLVED CLOSED ACTIVE ANSWERED
User: ullas.kris
Posted: on Jul 27, 2015 09:08 AM
Forum: Data Controls
Answer: 1
Views: 7056

Hi,

I have a DataTable which having some rows which bind from database.

I would like to add some new rows to that datatable.

I used the following code.

conn.Open();
SqlCommand cmdDownload = conn.CreateCommand();
cmdDownload.CommandType = CommandType.Text;
cmdDownload.CommandText = "select SKUCode,'Image Available' as [Status] "
                                    + "from tblName"
                                    + "where SKUCode in (" + lblSearch.Text.Trim() + ") "
                                    + "order by Brand;";
cmdDownload.CommandTimeout = 0;
SqlDataAdapter daDownload = new SqlDataAdapter(cmdDownload);
DataTable dtDownload = new DataTable("Images");
daDownload.Fill(dtDownload);
string[] str = lblText.Text.Trim().Split(',');
foreach (string n in nfs)
{
    DataRow dr = dtDownload.NewRow();
    dr["SKUCode"] = n.ToString();
    dr["Status"] = "Image not available";
}
using (XLWorkbook wb = new XLWorkbook())
 {
    wb.Worksheets.Add(dtDownload);

    Response.Clear();
    Response.Buffer = true;
    Response.Charset = "";
    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
 Response.AddHeader("content-disposition", "attachment;filename=Excel1.xlsx");
    using (MemoryStream MyMemoryStream = new MemoryStream())
    {
        wb.SaveAs(MyMemoryStream);
        MyMemoryStream.WriteTo(Response.OutputStream);
        Response.Flush();
        Response.End();
    }
}
conn.Close();

But the new rows are not adding to the datatable.

Please help me out.

Thanl you.

Download FREE API for Word, Excel and PDF in ASP.Net

Shashika...

0 1

Reply
ANSWER
User: Shashikant
Replied: on Jul 27, 2015 09:35 AM
Report

Here I have created sample that full-fill your requirement.

HTML

<div>
    <asp:TextBox ID="txtText" runat="server" />
    <asp:Button Text="Add" runat="server" OnClick="Add" />
    <br />
    <br />
    <asp:GridView ID="gvData" runat="server" />
</div>

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        DataTable dt = new DataTable();
        dt.Columns.AddRange(new DataColumn[2] { new DataColumn("SKUCode", typeof(string)),
                        new DataColumn("Status", typeof(string)) });
        dt.Rows.Add("SA1", "Selected");
        dt.Rows.Add("SA2", "Selected");
        dt.Rows.Add("SA3", "Rejected");
        dt.Rows.Add("SA4", "Rejected");
        ViewState["Data"] = dt;
        gvData.DataSource = dt;
        gvData.DataBind();
    }
}

protected void Add(object sender, EventArgs e)
{
    if (!string.IsNullOrEmpty(txtText.Text))
    {
        DataTable dt = (DataTable)ViewState["Data"];
        DataRow dr = dt.NewRow();
        string[] str = txtText.Text.Trim().Split(',');
        if (str.Length > 1)
        {
            dr["SKUCode"] = str[0];
            dr["Status"] = str[1];
        }
        else
        {
            dr["SKUCode"] = str[0];
            dr["Status"] = "Image not available";
        }
        dt.Rows.Add(dr);
        ViewState["Data"] = dt;
        gvData.DataSource = dt;
        gvData.DataBind();
    }
}

Screenshot

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Add new row to existing DataTable using C# .Net

Company

Explore

Follow us

Contact Us