Download the Sample from the link
http://www.codeproject.com/Articles/33553/Creating-Shopping-Cart-UI-using-JQuery-in-an-Hour
Replace the Below code with this code:
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
GetProducts();
}
}
private void GetProducts()
{
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
string sqlStatment = "SELECT Code,Name,Description, Price FROM Product";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand(sqlStatment, con))
{
using (SqlDataAdapter da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
da.Fill(ds);
dlProducts.DataSource = products;
dlProducts.DataBind();
}
}
}
}
SQL:
CREATE TABLE [dbo].[ShoppingCart](
[Code] [varchar](50) NULL,
[Name] [varchar](50) NULL,
[Description] [varchar](50) NULL,
[Price] [money] NULL
) ON [PRIMARY]
GO
Thank You.