首页 > 解决方案 > 连接到数据库时未插入 Windows 窗体应用程序数据

问题描述

最后让应用程序连接到服务器上的 SQL DB。但是现在测试数据不会插入。

我没有收到任何错误

private void BtnUpload_Click(object sender, EventArgs e)
    {
        btnUpload.Enabled = false;
        Application.DoEvents();

        UploadFile(txtFTPAddress.Text, txtFilePath.Text, txtUsername.Text, txtPassword.Text);
        btnUpload.Enabled = true;

        string connString = ConfigurationManager.ConnectionStrings["connString"].ConnectionString;
        using (SqlConnection Conn = new SqlConnection(connString))
        try
        {
            Conn.Open();
            string insertURL = "insert into modelGEOmodelData (ID, Name, Location, modelGeoURL) values (@ID, @Name, @Location, @modelGeoURL)";
            SqlCommand command = new SqlCommand(insertURL, Conn);
                string id = "1234";
                string name = "pump";
                string local = "redford";
                command.Parameters.Add(new SqlParameter("@ID", id));
                command.Parameters.Add(new SqlParameter("@Name", name));
                command.Parameters.Add(new SqlParameter("@Location", local));
                command.Parameters.Add(new SqlParameter("@modelGeoURL", FileURLtxt.Text));
                Conn.Close();
        }
        catch
        {

        }

标签: c#sqlwinforms

解决方案


推荐阅读