insert in data base in C#

Question

0.00/5 (No votes)

See more:

i want to insert in db in C# windows application here is my code:

C#

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('10','20','o','u')";
                Qcommand.CommandText = commandText;
                Qcommand.CommandType = CommandType.Text;
              
               // Qcommand.Parameters.AddWithValue("@RID",10 );
               // Qcommand.Parameters.AddWithValue("@amount", orderColection.list[i].amount);
              //  Qcommand.Parameters.AddWithValue("@type", orderColection.list[i].type);
              //  Qcommand.Parameters.AddWithValue("@date", orderColection.list[i].date );
                //Qcommand.ExecuteNonQuery();
                Qcommand.ExecuteReader();
         
            Qconnection.Close();

but nothing will happen. and my table is empty

Posted 6-Sep-12 21:26pm

f.sarikhani

Add a Solution

Comments

__TR__ 7-Sep-12 3:36am

Use
Qcommand.ExecuteNonQuery();
instead of
Qcommand.ExecuteReader();.

7 solutions

Solution 6

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

Posted 7-Sep-12 0:23am

astika

Solution 7

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[^]

Posted 7-Sep-12 0:50am

hh_7

Solution 2

with this way also not solved my compelete code is:

C#

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();
       }

Posted 6-Sep-12 21:43pm

f.sarikhani

Comments

[no name] 7-Sep-12 11:43am

You should comment this or improve your question.
The solutions are just for answers.

Solution 4

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);
}

Posted 6-Sep-12 22:50pm

StackQ

Solution 5

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

Posted 7-Sep-12 0:12am

f.sarikhani

Solution 8

i am using from try cache to execute insert command and in cache write this command:

C#

catch (Exception ex)
            {
 
                throw new Exception(ex.Message);
            }

but no message showing to me and nothing writed in tabel

Posted 7-Sep-12 3:24am

f.sarikhani

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2012-09-06T21:36:00

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:

C#

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.

insert in data base in C#

7 solutions

Solution 1

Solution 6

Solution 7

Solution 2

Solution 4

Solution 5

Solution 8

Add your solution here

Preview 0

Existing Members

...or Join us