Don't what is the error in my code thats not worked any idea?

[idsanjeevjha]

sorry for posting second question on same topic becouse second is for display data is posted by mistake and try to modify in edit mode thats is not shown ,

'this code is worked
isql="Insert Into students(id, first_name, last_name, major,current_credits) values (?, ?, ?, ?, ?)"
idbcomm=new odbccommand(isql,dbconn)
idbcomm.Parameters.Add("id", id.Text)
idbcomm.Parameters.Add("fname", fname.text)
idbcomm.Parameters.Add("lname", lname.Text)
idbcomm.Parameters.Add("major", major.Text)
idbcomm.Parameters.Add("credits", credits.Text)
idbcomm.ExecuteNonQuery()
'This code is not working reports error
'lsSQL ="Insert Into stud(id,firstname,lastname,major) values (@id,@fname,@lname,@major)"
'idbcomm=new odbccommand(isql,dbconn)
'idbcomm.Parameters.Add( "@id",id.Text)
'idbcomm.Parameters.Add( "@fname",fname.text)
'idbcomm.Parameters.Add( "@lname",lname.Text)
'idbcomm.Parameters.Add( "@major",major.Text)
idbcomm.ExecuteNonQuery()

sanjeev

[Lost User]

Please Check your data type against your Variable data. and why you use Paramenters. It is meaning less. Anubhava

[N a v a n e e t h]

idsanjeevjha wrote:

'This code is not working reports error

What is the error ? You have use @ symbol for parameter. I believe you should use ? symbol for parameters in Odbc.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions

[idsanjeevjha]

i am getting ERROR [42000] [Microsoft][ODBC driver for Oracle][Oracle]ORA-00936: missing expression. ya i have to use ? symbol for parameter in odbce but why @ is used in sql or msaccess thanks

sanjeev

[Chinners]

It may not help much, but when using an old version of sqlce, I used to use the following to add a parameter to the query:

cmd.Parameters.Add(New SqlCeParameter("id", SqlDbType.Int)).Value = nextID

maybe you can modify to get it working?

[N a v a n e e t h]

That depends on the databases. SQL and access uses @ symbol.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia How to use google | Ask smart questions