Continuation question....

[DC]

Thank you very useful.

Just another quick question, Im now getting

" Compiler Error Message: CS1502: The best overloaded method match for
'System.Data.OleDb.OleDbCommand.OleDbCommand(string,
System.Data.OleDb.OleDbConnection)' has some invalid arguments"

When I run the following code

string strConnectionString, strQueryString;
strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0; Data
Source='C:\\Program Files\\Common Files\\ODBC\\Data
Sources\\seminars.mdb';";

DateTime dtAddSeminarDate = new DateTime();
dtAddSeminarDate = DateTime.Parse(tbSeminarDate.Text);

string AddSemSql = "INSERT INTO SeminarList (Speaker, SpeakerEmail,
SpeakerInstitution,"
+ "SeminarTitle, SeminarDate, SeminarTime, SeminarLocation,
SeminarDetails, SeminarHost,"
+ " SeminarHostEmail, SeminarType, OrganisationNotes)"
+ " VALUES (" + tbSpeaker.Text + "," + tbSpeakerEmail.Text + "," +
tbSpeakerInstitution.Text +","
+ tbSeminarTitle.Text + "," + dtAddSeminarDate + "," +
tbSeminarTime.Text + "," + tbSeminarLocation.Text + ","
+ tbSeminarDetails.Text + "," + tbSeminarHost.Text + "," +
tbSeminarHostEmail.Text + "," + tbSeminarType.Text + "," +
tbOrganisationNotes.Text +")";

OleDbCommand cmd = new OleDbCommand(AddSemSql, strConnectionString);

Any ideas?


--
_______________________________________________

DC

"You can not reason a man out of a position he did not reach through reason"

"Don't use a big word where a diminutive one will suffice."

"A man with a watch knows what time it is. A man with two watches is
never sure." Segal's Law

 

[Marina]

You need to pass an actual connection object in, not a connection string.

 

[DC]

Cheers I replaced it with

OleDbConnection Conn = new OleDbConnection(strConnectionString);

OleDbCommand cmd = new OleDbCommand(AddSemSql, Conn);

and its working fine now. Think Ive gone a bit codeblind

You need to pass an actual connection object in, not a connection string.

--
_______________________________________________

DC

"You can not reason a man out of a position he did not reach through reason"

"Don't use a big word where a diminutive one will suffice."

"A man with a watch knows what time it is. A man with two watches is
never sure." Segal's Law