CREATE DATABASE test.dbc

SET DATABASE TO TEST


CREATE TABLE login(userName c(20),age n)


Then edit stored procedure and add new procedure:

PROCEDURE vfpInsertProc

   LPARAMETERS tcName, tnAge

   INSERT INTO login values(tcName,tnAge)

ENDPROC

string str;

str = "Provider=vfpoledb.1;Data Source=d:\\test.dbc";

// the aboce line can be re-written as 

//str = @"Provider=vfpoledb.1;Data Source=d:\test.dbc";


OleDbConnection conn = new OleDbConnection();

conn = new OleDbConnection(str);

// you need to inculde the following line in try - catch block

conn.Open(); 

MessageBox.Show(conn.State.ToString()); 

if (conn.State == ConnectionState.Open) // check if connection is opened

{

   OleDbCommand cmd = new OleDbCommand();

   cmd.Connection = conn; 

   cmd.CommandType = CommandType.StoredProcedure;

   cmd.CommandText = "vfpInsertProc";

     cmd.Parameters.Add("tcName","Singh");

     cmd.Parameters.Add("tnAge",27);

   //cmd.CommandTimeout = 30;

   cmd.ExecuteNonQuery(); 

   conn.Close(); //close the connection

}