0

hi everyone,
I'm new to Asp.Net and I have to write a virtual store project.
I have a DB and can read from it but can't do anytjing else no matter how I try.

I also think I am getting a little lost in all the forms amd partial code.

please, if anyone can take a look at my project and maybe tell me what I should do next.
I would really appreciate the help.
it's driving me crazy!!!!!!!!!!!!!!!!!!

2
Contributors
4
Replies
5
Views
11 Years
Discussion Span
Last Post by yavanna
0

What do you want to do with the code?

Whats your next step? Can you be specific what you are asking for?

0

my main problems currently are not beeing able to update my members in the DB and I can't verifi credit card info.

so far I was able only to read from my DB not write to it.

0

my main problems currently are not beeing able to update my members in the DB and I can't verifi credit card info.

so far I was able only to read from my DB not write to it.

In your Project under the File Sales,

I found out these code,

this.oleDbInsertCommand1.CommandText = "INSERT INTO tblSales(CountSale, Date_sale, Sale_Cus_Code, Sale_movie_code) VALUES" +
				[B]" (?, ?, ?, ?)"[/B];

And the Parameter assigning is given something like this,

this.oleDbInsertCommand1.Parameters.Add[B](new System.Data.OleDb.OleDbParameter("CountSale", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "CountSale", System.Data.DataRowVersion.Current, null));[/B]
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Date_sale", System.Data.OleDb.OleDbType.DBDate, 0, "Date_sale"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sale_Cus_Code", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Sale_Cus_Code", System.Data.DataRowVersion.Current, null));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Sale_movie_code", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "Sale_movie_code", System.Data.DataRowVersion.Current, null));

Problems
1.I dont see where the parameter is declared.
2.I dont see where the parameter is Assigned.

Can you verify that?

0

thanks, I changed the code in the new member form which was almost the same, and now it works.

private void fillin_Click(object sender, System.EventArgs e)
{		
     AddProduc(this.id.Text,this.firstname.Text,...,this.email.Text);
}

private void AddProduct(string id,string fn,string ln,...,string email)
{
   string sql = "insert into tblCustomer (Id_cus,...,Emai_cus) " +" values ('{0}'...'{10}') ";
   sql = String.Format(sql,id,...,email);
   UpdateDB(sql);
}

but now I have problems with adding and deliting movies.
It keeps saying :
Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.

and points to these code lines:

Line 33: DataSet ds=new DataSet();
Line 34: atmovies MovTbl=new atmovies();
Line 35: MovTbl.moviesadp.Fill(ds);
Line 36: DDMov.Items.Add("בחר סרט מהרשימה");
Line 37: DataTable MovDetales = ds.Tables["tblmovie"];

these workes well in my new member form and I don't know why they won't work here.

This article has been dead for over six months. Start a new discussion instead.
Be sure to adhere to our posting rules.