SqlCommand INSERT INTO查询不执行 [英] SqlCommand INSERT INTO query does not execute

问题描述

大家好，我有以下代码：

Hello guys I have got this code:

SqlCommand scom = new SqlCommand(
                                "INSERT INTO klient(name,surname) 
                                values(@kname,@ksurname)", 
                                conn);

scom.Parameters.AddWithValue("@kname", kname.Text);
scom.Parameters.AddWithValue("@ksurname", ksurname.Text);
conn.Open();
DataTable dt = new DataTable();
SqlDataAdapter SDA = new SqlDataAdapter("SELECT * FROM klient", spojeni);
SDA.Fill(dt);
conn.Close();

它应该从文本框中插入数据：kname，ksurname，但是它关闭了表单而不在MS中显示它们SQL表klient

It should insert data from textboxes: kname, ksurname, but it closes the form without showing them in MS SQL table klient

推荐答案

缺少ExecuteNonQuery调用

Missing the ExecuteNonQuery call

SqlCommand prikaz = new SqlCommand("INSERT INTO klient(name,surname) values(@kname,@ksurname)", spojeni);

prikaz.Parameters.AddWithValue("@kname", kname.Text);
prikaz.Parameters.AddWithValue("@ksurname", ksurname.Text);
spojeni.Open();
prikaz.ExecuteNonQuery();
......

应该执行命令来更新数据库。

A command should be executed to update the database...

这篇关于SqlCommand INSERT INTO查询不执行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！