Date: 01/09/06 (C Sharp)    Keywords: database, sql

Okay, I'm stumped.

I'm using Intersystems Cache, for which there seem to be no peer help fora anywhere on the net, though theoretically it shouldn't matter, should it? ODBC is ODBC, I hope. In any case, here's a quick code snippet:

       private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string InsertString = "INSERT INTO Erasmus.Publisher(Name, PublisherURL) VALUES(@Name,@URL)";
                ErasmusTransaction = ErasmusConnection.BeginTransaction(IsolationLevel.ReadCommitted);
                ErasmusInsertCommand = new OdbcCommand(InsertString, ErasmusConnection, ErasmusTransaction);

                OdbcParameter prmName = new OdbcParameter();
                prmName.Direction = ParameterDirection.Input;
                prmName.OdbcType = OdbcType.VarChar;
                prmName.Value = txtName.Text;
                prmName.ParameterName = "@Name";
                ErasmusInsertCommand.Parameters.Add(prmName);

       private void btnSave_Click(object sender, EventArgs e)
        {
            try
            {
                string InsertString = "INSERT INTO Erasmus.Publisher(Name, PublisherURL) VALUES(@Name,@URL)";
                ErasmusTransaction = ErasmusConnection.BeginTransaction(IsolationLevel.ReadCommitted);
                ErasmusInsertCommand = new OdbcCommand(InsertString, ErasmusConnection, ErasmusTransaction);

                ErasmusInsertCommand.Parameters.Add("@Name", OdbcType.VarChar, 100).Value = txtName.Text;

Source: http://www.livejournal.com/community/csharp/46500.html