Welcome to Sign in | Help

Re: Parametrii OldDbParameter, Update query si baza de date Access

  •  10-01-2007, 3:34 PM

    Re: Parametrii OldDbParameter, Update query si baza de date Access

    using System;
    using System.Collections.Generic;
    using System.Text;
    using System.Data;
    using System.Data.OleDb;

    namespace ConsoleApplication1
    {
        class Program
        {
            static void Main(string[] args)
            {
                string strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=H:\\bd\\test.mdb";
                string strSQL = "UPDATE Factura SET CodFactura = CodFactura*10 WHERE CodFactura = ?";
                OleDbConnection objCon = new OleDbConnection(strCon);
                OleDbCommand objCmd = new OleDbCommand(strSQL, objCon);
                objCmd.CommandType = CommandType.Text;
                objCmd.Parameters.AddWithValue("PrimulParametru", 100);
                objCon.Open();
                int iRez = objCmd.ExecuteNonQuery();
                objCon.Close();

                Console.Write("Rezultat executie UPDATE {0}", iRez);
                Console.ReadLine();
            }
        }
    }

    ExecuteNonQuery returneaza numarul inregistrarilor care au fost modificate (UPDATE) in acest caz. Daca ExecuteNonQuery returneaza 0 inseamna ca nu au fost modificate inregistrarile (nici o inregistrare) si asta pentru nu exista valori care sa verifice conditiile din WHERE pentru a putea fi realizata minim o modificare. Daca ai campuri de tip CHAR/VARCHAR si derivate implicate in conditiile din WHERE atentie la spatii.

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems