ASP.NET

ASP.NET RSS

need help - please

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2005

Posts: 3

Reputation: yavanna is an unknown quantity at this point

Solved Threads: 0

yavanna

Offline

Newbie Poster

need help - please

Oct 2nd, 2005

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

Attached Files

DVDPr.zip (236.3 KB, 3 views)

•

Join Date: Feb 2005

Posts: 175

Reputation: Letscode is an unknown quantity at this point

Solved Threads: 6

Letscode

Offline

Junior Poster

Re: need help - please

Oct 5th, 2005

What do you want to do with the code?

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

Save White Tiger

•

Join Date: Sep 2005

Posts: 3

Reputation: yavanna is an unknown quantity at this point

Solved Threads: 0

yavanna

Offline

Newbie Poster

Re: need help - please

Oct 9th, 2005

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.

•

Join Date: Feb 2005

Posts: 175

Reputation: Letscode is an unknown quantity at this point

Solved Threads: 6

Letscode

Offline

Junior Poster

Re: need help - please

Oct 13th, 2005

•

Originally Posted by yavanna

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,

Help with Code Tags

(Toggle Plain Text)

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

And the Parameter assigning is given something like this,

Help with Code Tags

(Toggle Plain Text)

this.oleDbInsertCommand1.Parameters.Add(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));
			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?

Save White Tiger

•

Join Date: Sep 2005

Posts: 3

Reputation: yavanna is an unknown quantity at this point

Solved Threads: 0

yavanna

Offline

Newbie Poster

Re: need help - please

Oct 16th, 2005

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

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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);
}
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.

Attached Files

project161005.zip (265.8 KB, 1 views)