i am getting a OleDbException that states "No value for one or more required parameters"
here is the code:
and one more thing i am using the CalenderMonth component how will it return the date in string i used clenderMonth.ToString() but it dosnt work the way i want it to ...Code:using System; using System.Windows.Forms; using System.Data.OleDb; using System.Data; class CompanyDetails { public CompanyDetails(){} public CompanyDetails(string companyName, string add1, string add2, string phone, string fax,string city , string state, string email, string website, string cPerson, string cPhone ) { this.companyName = companyName; this.add1 = add1; this.add2 = add2; this.phone = phone; this.fax = fax; this.city = city; this.state = state; this.email = email; this.website = website; this.cPerson = cPerson; this.cPhone = cPhone; } public void enterCompanyDetails() { OleDbConnection conn = null; try { conn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; User Id =; Password=; Data Source=C:\professional\pro.mdb" ); conn.Open(); OleDbCommand cmd = conn.CreateCommand(); cmd.CommandText = @"INSERT INTO Company( CompanyName,Address1,Address2, PhoneNo,FaxNo,City,State,Email, Website,ContactPerson,ContactPersonPhone ) VALUES (companyName, add1, add2, phone, fax, city, state,email, website,cPerson,cPersonPhone )"; cmd.ExecuteNonQuery(); } catch(OleDbException error ) { MessageBox.Show("OleDbException: " + error.Message,"Error", MessageBoxButtons.OK,MessageBoxIcon.Error ); } finally { if ( conn != null ) conn.Close(); } } }



LinkBack URL
About LinkBacks


