插入SQL数据库并在ms SQL中显示 [英] Insert into SQL database and show in ms SQL sm

问题描述

当我将数据插入SQL数据库时，Microsoft SQL服务器管理器在编辑行中只显示一条记录，但在选择前1000行中显示所有记录哪里有问题？我做错了什么？

Imgur：图片 [ ^ ]



谢谢



我尝试过：



这是我的代码：

<私有子Button1_Click（发件人作为对象，e作为EventArgs）处理Button1.Click
Dim VLOZ作为新的SqlCommand（INSERT INTO TECH_TEST（CISLO_S，STROJ，PROJEKT）> br $>

Hi, when I insert data into SQL database Microsoft SQL server manager show me in edit rows only one record but in select top 1000 rows show me all records where is a problem? What Iam doing wrong?
Imgur: Image[^]

Thank you

What I have tried:

Here is my code:

Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
       Dim VLOZ As New SqlCommand("INSERT INTO TECH_TEST (CISLO_S, STROJ, PROJEKT) VALUES(@CISLO_S,@STROJ,@PROJEKT)", CONNECTION)

       VLOZ.Parameters.AddWithValue("@CISLO_S", TextBox3.Text)
       VLOZ.Parameters.AddWithValue("@STROJ", TextBox4.Text)
       vloz.Parameters.AddWithValue("@PROJEKT", TextBox5.Text)
       CONNECTION.Open()
       If VLOZ.ExecuteNonQuery() = 1 Then
           MsgBox("přidáno")
           Label1.Text = "HOTOVO"
       Else
           MsgBox("existuje")
       End If

       clear()
       Label1.Text = ""
       CONNECTION.Close()

推荐答案

检查你是否正在看同样的表，并打开一个新的EDIT查询窗口。

如果一切正常并且您仍然遇到问题，请关闭SSMS并再次打开它。

Check you are looking at the same table, and that you open a new EDIT query window.
If that all looks right and you still get the problem, close SSMS and open it again.

这篇关于插入SQL数据库并在ms SQL中显示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！