now i m working in ASP.Net i created tables named customer and Product now the task is to create a web form for bill based on the products that was bought.Please help me....

Recommended Answers

All 4 Replies

Please help us!
Post this on the ASP.NET forum.
Show some code where you have problems with.

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
            SelectCommand="SELECT a.custid, a.custname, b.prodid, b.rate AS per_rate, 1 AS qty, 5 * b.rate AS Rate FROM customer AS a INNER JOIN product AS b ON a.custid = b.custid">
        </asp:SqlDataSource>

public partial class Default2 : System.Web.UI.Page
{
    DataSet ds = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void TextBox7_TextChanged(object sender, EventArgs e)
    {
        
        TextBox7.Text = "Rate";
        
    }
    protected void TextBox1_TextChanged(object sender, EventArgs e)
    {
        TextBox1.Text = "Customer Name";
       
       
    }
    protected void TextBox2_TextChanged(object sender, EventArgs e)
    {
        TextBox2.Text = "Customer ID";
    }
    protected void TextBox5_TextChanged(object sender, EventArgs e)
    {
        TextBox5.Text = "Product ID";
    }
    protected void TextBox6_TextChanged(object sender, EventArgs e)
    {
        TextBox6.Text = "Quantity";
     
     }
    protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Redirect("Default3.aspx");
    }
}

in this i don no how to calculate the bill from the SQL SERVER 2005 database.......

commented: post to ASP.NET forum -2

there is a dedicated forum for Asp.NET, you should post this thread to there.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.