Save multiple rows from GridView to Database using C# in ASP.Net

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Dec 30, 2016 01:53 AM
Forum: Data Controls
Answer: 1
Views: 6892

see below code:

<asp:Label ID="LblName" runat="server"></asp:Label>

using (SqlConnection conn = General.GetConnection())
{
    using (SqlCommand _cmd = General.GetCommand("Downloadurl_insert", conn))
    {
        string ipAddress;
        ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
        if (ipAddress == "" || ipAddress == null)
           ipAddress = Request.ServerVariables["REMOTE_ADDR"];
           conn.Open();
           _cmd.Parameters.AddWithValue("@downloadTitle", LblName.Text);
           _cmd.Parameters.AddWithValue("@url", "~/downloads/neda.rar")
           _cmd.Parameters.AddWithValue("@DownloadToken", GetDownloadToken(10));
           _cmd.Parameters.AddWithValue("@IpAddress", ipAddress);
           _cmd.Parameters.AddWithValue("@Hits", "0");
           _cmd.Parameters.AddWithValue("@Downloaded", "false");
           _cmd.ExecuteNonQuery();
     }
}

now I want put label in gridview:

<asp:TemplateField ItemStyle-Width="24px" ItemStyle-VerticalAlign="Middle">
  <ItemTemplate>
     <asp:Label ID="LblName" runat="server"></asp:Label>
  </ItemTemplate>
</asp:TemplateField>

now I want put all data from gridview in database I mean how I can change below code :

_cmd.Parameters.AddWithValue("@downloadTitle", LblName.Text);

in below metod:

using (SqlConnection conn = General.GetConnection())
{
   using (SqlCommand _cmd = General.GetCommand("Downloadurl_insert", conn))
   {
       string ipAddress;
       ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
       if (ipAddress == "" || ipAddress == null)
          ipAddress = Request.ServerVariables["REMOTE_ADDR"];
       conn.Open();
       _cmd.Parameters.AddWithValue("@downloadTitle", LblName.Text);
       _cmd.Parameters.AddWithValue("@url", "~/downloads/neda.rar")
       _cmd.Parameters.AddWithValue("@DownloadToken", GetDownloadToken(10));
       _cmd.Parameters.AddWithValue("@IpAddress", ipAddress);
       _cmd.Parameters.AddWithValue("@Hits", "0");
       _cmd.Parameters.AddWithValue("@Downloaded", "false");
       _cmd.ExecuteNonQuery();
   }
}

that insert all data(lblname) from grid view in database:

best regards

neda

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

Indresh

0 3

Reply
ANSWER
User: Indresh
Replied: on Dec 30, 2016 07:00 AM
Report

Hi nedash,

nedash says:
using (SqlConnection conn = General.GetConnection())

        {

            using (SqlCommand _cmd = General.GetCommand("Downloadurl_insert", conn))

            {

   foreach (GridViewRow row in GridView1.Rows)

                {

                    string ipAddress;

                    ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];

                    if (ipAddress == "" || ipAddress == null)

                        ipAddress = Request.ServerVariables["REMOTE_ADDR"];

                    string name = (row.FindControl("LblName") as Label).Text;

                    _cmd.Parameters.AddWithValue("@downloadTitle", name);

                    _cmd.Parameters.AddWithValue("@url", "~/downloads/" + name + ".rar");

                    _cmd.Parameters.AddWithValue("@DownloadToken", GetDownloadToken(10));

                    _cmd.Parameters.AddWithValue("@IpAddress", ipAddress);

                    _cmd.Parameters.AddWithValue("@Hits", "0");

                    _cmd.Parameters.AddWithValue("@Downloaded", "false");

                    conn.Open();

                    _cmd.ExecuteNonQuery();

                    conn.Close();

                }

}

}

Replace above code with below.

using (SqlConnection conn = General.GetConnection())
{
    foreach (GridViewRow row in GridView1.Rows)
    {
        using (SqlCommand _cmd = General.GetCommand("Downloadurl_insert", conn))
        {
            string ipAddress;
            ipAddress = Request.ServerVariables["HTTP_X_FORWARDED_FOR"];
            if (ipAddress == "" || ipAddress == null)
                ipAddress = Request.ServerVariables["REMOTE_ADDR"];
            string name = (row.FindControl("LblName") as Label).Text;
            _cmd.Parameters.AddWithValue("@downloadTitle", name);
            _cmd.Parameters.AddWithValue("@url", "~/downloads/" + name + ".rar");
            _cmd.Parameters.AddWithValue("@DownloadToken", GetDownloadToken(10));
            _cmd.Parameters.AddWithValue("@IpAddress", ipAddress);
            _cmd.Parameters.AddWithValue("@Hits", "0");
            _cmd.Parameters.AddWithValue("@Downloaded", "false");
            conn.Open();
            _cmd.ExecuteNonQuery();
            conn.Close();
        }
    }
}

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

Save multiple rows from GridView to Database using C# in ASP.Net

Company

Explore

Follow us

Contact Us