How to write Storedprocedures in Ms-Access

A stored procedure in Access is called a Query and you call it just like any other stored procedure.

Dim cmd As OleDbCommand = New OleDbCommand()   
        Dim sConStr As String = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db1.mdb"   
        Dim conn As OleDbConnection   
  
        conn = New OleDbConnection(sConStr)   
  
        cmd.Connection = conn  
        cmd.CommandType = CommandType.StoredProcedure   
        cmd.CommandText = "yourqueryname"  
  
        conn.Open()   
        cmd.ExecuteNonQuery()   
        conn.Close()  

See
http://www.stardeveloper.com/articles/display.html?article=2001050101&page=1[^]
http://msaccessmemento.hubpages.com/hub/Stored_Procedure_in_MS_Access[^]
http://devcity.net/Articles/18/msaccess_sp.aspx[^]

[Edit]

using (OleDbConnection conn = new OleDbConnection(ConnString))

{

  using (OleDbCommand cmd = new OleDbCommand(SqlString, conn))

  {

    cmd.CommandType = CommandType.StoredProcedure;

    cmd.Parameters.AddWithValue("FirstName", txtFirstName.Text);

    cmd.Parameters.AddWithValue("LastName", txtLastName.Text);

    conn.Open();

    cmd.ExecuteNonQuery();

  }

}

Hi All,

i have wrote parameterized query in ms-access.
can any one tell me that, how can i call that query in windows vb.net

___Query

UPDATE Wsr_UserDetails SET Wsr_UserDetails.[Password] = [Pwd]
WHERE (((Wsr_UserDetails.UserId)=[Uid]));

-----------


Thanks in advance