如何将数据插入localdatabase表以及如何获取它？ [英] How to insert data in to localdatabase table and how to get it?

问题描述

数据没有插入我的localdatabase.Form包含一个文本框和一个按钮



我尝试过：

 SqlCeConnection conn; 
  string  dsc = Application.StartupPath +   \\Database1.sdf; 
 conn =  new  SqlCeConnection（  DataSource =  + dsc）; 
 conn.Open（）; 
 
 
 
 SqlCeCommand cmd; 
  string  strInsertCmd =   INSERT INTO表[ id]，[key] VALUES（id，key）;; 
 cmd = conn.CreateCommand（）; 
 cmd.CommandText = strInsertCmd; 
 
 cmd.Parameters.Add（  id，SqlDbType.Int） ; 
 cmd.Parameters.Add（  key，SqlDbType.NVarChar）; 
 
 cmd.Parameters [  id]。值=  1 ; 
 cmd.Parameters [  key]。Value = textBox1.Text; 
 
 cmd.ExecuteNonQuery（）; 
 conn.Close（）; 

解决方案

您需要区分列名和参数。例如

  string  strInsertCmd =  < span class =code-string> INSERT INTO table [id]，[key] VALUES（@ id，@ key）;; 
 cmd = conn.CreateCommand（）; 
 cmd.CommandText = strInsertCmd; 
 
 cmd.Parameters.Add（  @ id，SqlDbType.Int ）; 
 cmd.Parameters.Add（  @ key，SqlDbType.NVarChar）; 
 
 cmd.Parameters [  @ id]。值=  1 ; 
 cmd.Parameters [  @ key]。Value = textBox1.Text; 

另外 .Add 显然已被弃用（或以此方式标题）。你可能会更好用

 cmd.Parameters.AddWithValue（  @ id， 1 ）; 
 cmd.Parameters.AddWithValue（  @ key，textBox1.Text; 

Data is not inserting in my localdatabase.Form containing one textbox and one button

What I have tried:

SqlCeConnection conn;
                string dsc = Application.StartupPath + "\\Database1.sdf";
                conn = new SqlCeConnection("DataSource = " + dsc);
                conn.Open();



                SqlCeCommand cmd;
                string strInsertCmd = "INSERT INTO table [id],[key] VALUES (id,key);";
                cmd = conn.CreateCommand();
                cmd.CommandText = strInsertCmd;

                cmd.Parameters.Add("id", SqlDbType.Int);
                cmd.Parameters.Add("key", SqlDbType.NVarChar);

                cmd.Parameters["id"].Value = 1;
                cmd.Parameters["key"].Value = textBox1.Text;

                cmd.ExecuteNonQuery();
                conn.Close();

解决方案

You need to distinguish between your column names and your parameters. E.g.

string strInsertCmd = "INSERT INTO table [id],[key] VALUES (@id,@key);";
                cmd = conn.CreateCommand();
                cmd.CommandText = strInsertCmd;
 
                cmd.Parameters.Add("@id", SqlDbType.Int);
                cmd.Parameters.Add("@key", SqlDbType.NVarChar);
 
                cmd.Parameters["@id"].Value = 1;
                cmd.Parameters["@key"].Value = textBox1.Text;

Also .Add is apparently deprecated (or heading that way). You might be better off with

cmd.Parameters.AddWithValue("@id", 1);
cmd.Parameters.AddWithValue("@key",textBox1.Text;

这篇关于如何将数据插入localdatabase表以及如何获取它？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！