Convert a DataTable from database to Text String using C# .Net

hugocc13

SOLVED CLOSED ACTIVE ANSWERED
User: hugocc13
Posted: on Feb 09, 2015 06:05 AM
Forum: Data Controls
Answer: 1
Views: 3169

Hi friends, I need your help, I have a products table with 3 fields name, price and quantity, I need to fill a datatable with those 3 fields and using a foreach build a chain. I build my chain currently using a datagrid with my following code

this code work good.

string item_name;
string amount;
string quantity;
string URL = "";
int i;

item_name = "&item_name_";
amount = "&amount_";
quantity = "&quantity_";
			
URL += "https://www.paypal.com/cgi-bin/webscr?";

i = 0;
foreach (GridViewRow row in this.Basket.Rows)
{
    Label name11 = ((Label)row.FindControl("lblName"));
    Label Amount11 = ((Label)row.FindControl("lblAmount"));
    Label quantity11 = ((Label)row.FindControl("lblquantity"));

    i = i + 1;

    URL = URL + item_name + i.ToString() + "=" + name11.Text;
    URL = URL + amount + i.ToString() + "=" + Amount11.Text;
    URL = URL + quantity + i.ToString() + "=" + quantity11.Text;
}

but I like to form my chain directly from datatable, not rely on a datagrid.

i am work whit paypal, thanks for all your help,.

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

Azim

0 1

Reply
ANSWER
User: Azim
Replied: on Feb 09, 2015 06:27 AM
Modified: on Feb 09, 2015 08:51 AM
Report

Database

I have made use of the following table Customers with the schema as follows.

I have already inserted few records in the table.

You can download database SQL from here.

Download SQL

Namespaces

using System.Configuration;
using System.Data;
using System.Data.SqlClient;

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
        using (SqlConnection conn = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand("SELECT * FROM Customers", conn))
            {
                using (SqlDataAdapter da = new SqlDataAdapter(cmd))
                {
                    DataTable dt = new DataTable();
                    da.Fill(dt);
                    string url = string.Empty;
                    url += "https://www.paypal.com/cgi-bin/webscr?";
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        if (i < 1)
                        {
                            url += string.Format("CustomerId={0}", dt.Rows[i]["CustomerId"]);
                        }
                        else
                        {
                            url += string.Format("&CustomerId={0}", dt.Rows[i]["CustomerId"]);
                        }
                        url += string.Format("&Name={0}", dt.Rows[i]["Name"]);
                        url += string.Format("&Country={0}", dt.Rows[i]["Country"]);
                    }

                    this.lblUrl.Text = url;
                }
            }
        }
    }
}

Screenshot

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

Convert a DataTable from database to Text String using C# .Net

Company

Explore

Follow us

Contact Us