insert in data base in C#

I try to use Dataset to do the most basic functions (INSERT,EDIT,DELETE,UPDATE).

See:

http://csharp.net-informations.com/dataset/csharp-dataset-tutorial.htm[^]

And this:

http://www.dotnetperls.com/dataset[^]

First check whether connection to database is done or not?
And put your code in try & catch.And explain Your problem?

dont solved my problem with this way also what am i doing

public int ExecuteMyQuery(string StrQuery, string ConnStr)
    {

        try
        {
            SqlCommand SqlComm = new SqlCommand();
            SqlConnection SqlConn = new SqlConnection(ConnStr);
            SqlConn.Open();
            SqlComm.CommandText = StrQuery;
            SqlComm.CommandType = CommandType.Text;
            SqlComm.Connection = SqlConn;

            return SqlComm.ExecuteNonQuery();
        }
        catch (Exception ex)
        {

            throw new Exception(ex.Message);
        }
    }

private void BtnOk_Click(object sender, EventArgs e)
{
string InsertQuery = "INSERT INTO order1 VALUES('10','20','o','u')";
ExecuteMyQuery(InsertQuery,ConnStr);
}

with this way also not solved my compelete code is:

static public SqlCeConnection Qconnection = new SqlCeConnection();
       static public SqlCeCommand Qcommand = new SqlCeCommand ();
       private void button2_Click(object sender, EventArgs e)
       {

           string str = "Data Source=|DataDirectory|\\Database1.sdf;Persist Security Info=False;";
            Qconnection.ConnectionString = str;
           Qcommand.Connection = Qconnection;
           Qconnection.Open();

             string commandText = "INSERT INTO order1 VALUES(@RID,@amount,@type,@date)";
               Qcommand.CommandText = commandText;
               Qcommand.CommandType = CommandType.Text;

               Qcommand.Parameters.AddWithValue("@RID",1 );
               Qcommand.Parameters.AddWithValue("@amount", 1);
               Qcommand.Parameters.AddWithValue("@type", "12wd");
               Qcommand.Parameters.AddWithValue("@date", "dfds" );
               Qcommand.ExecuteNonQuery();
             //  Qcommand .

           Qconnection.Close();
       }

Execute reader is the wrong command: ExecuteNonQuery is correct.
However it is a very good idea to name the fields as you insert them, and (as you tried) to use parametrized queries.
Look at this template - it should give you the idea:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con))
        {
        com.Parameters.AddWithValue("@C1", myValueForColumn1);
        com.Parameters.AddWithValue("@C2", myValueForColumn2);
        com.ExecuteNonQuery();
        }
    }

If you are using SDF files, you probably should be using SqlCEConnections, and SqlCECommands rather than the SqlConnection and SqlCommand in the above though.