0

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....

4
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by Ramy Mahrous
-1
<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.......

Edited by John A: added code tags

Votes + Comments
post to ASP.NET forum
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.