[Solved] Database Programming in C#

See more:

C#

Hi all ,

I am stuck in some issue while my practice in database programming.

Below is my purpose :
1) I have member id and amount with me.
2) First throught C# i ran one query "SELECT * FROM Table1 WHERE ......"
3) Then if record found i want to update the record
4) If record not found then i want to insert the record in the table.


Please refer below code :

public static bool SaveMembersCollection(Int16 Id, double amt, DateTime dtofcollection)
       {
           OleDbCommand Com = new OleDbCommand();

           string sql;
           sql=String.Concat("SELECT * FROM MemberCollections WHERE MemberID='", Id.ToString(), " AND CollectionDate='", dtofcollection.ToString(), "'");
           Com.Connection = Conn;
           //OleDbParameter Param = new OleDbParameter("@titel", "");
           //Com.Parameters.Add(Param);
           //Param = new OleDbParameter("@locatie", c);
           //Com.Parameters.Add(Param);
           Com.ExecuteNonQuery();



           Conn.Close();


           return false;
       }