使用npgsql从datagridview更新不起作用 [英] Update doesn't work from datagridview using npgsql

问题描述

我在使用Npgsql通过datagridview更新数据时遇到问题.我想从datagridview动态更新我的表.

I am having problem updating my data through datagridview using Npgsql. I want update my table dynamically from datagridview.

这是我要更新的代码:

NpAdapter.UpdateCommand = new NpgsqlCommand("update sessions set \"Visit Number:\" = :visit_num, \"ID:\" = :id, \"ENTERED BY:\" = :entered  " +
"where \"Visit Number:\" = :visit_num_old, \"ID:\" = :id_old, \"ENTERED BY:\" = :entered_old", this.dataconnect);
NpAdapter.UpdateCommand.Parameters.Add(new NpgsqlParameter("visit_num", DbType.Int32, 10) { Direction = ParameterDirection.Input, SourceColumn = "Visit Number:" });
NpAdapter.UpdateCommand.Parameters.Add(new NpgsqlParameter("id", DbType.AnsiStringFixedLength, 50) { Direction = ParameterDirection.Input, SourceColumn = "ID:" });
NpAdapter.UpdateCommand.Parameters.Add(new NpgsqlParameter("entered", DbType.AnsiStringFixedLength, 50) { Direction = ParameterDirection.Input, SourceColumn = "ENTERED BY:" });

NpAdapter.Update(dset, "sessions");

我不知道我在做什么错.谁能帮我.我试图弄清楚这个问题已经很长时间了.

I dont know what I am doing wrong. Could anyone please help me out. I trying to figure out this for a very long time.

推荐答案

这是我找到的解决方案.

Here is the solution I found.

NpgsqlCommand command = new NpgsqlCommand("UPDATE sessions SET \"Visit Number:\" = @visitnum,\"ENTERED BY:\" = @enteredby  WHERE \"Visit Number:\" = @visitnum", this.connection);

command.Parameters.Add("@visitnum", NpgsqlTypes.NpgsqlDbType.Integer, 12, "Visit Number:");
command.Parameters.Add("@enteredby", NpgsqlTypes.NpgsqlDbType.Varchar, 50, "ENTERED BY:");
NpgsqlParameter parameter = command.Parameters.Add("@oldvisitnum", NpgsqlTypes.NpgsqlDbType.Integer, 12, "Visit Number:");

parameter.SourceVersion = DataRowVersion.Original;
NpAdapter.UpdateCommand = command;
NpAdapter.Update(dset,"sessions");
MessageBox.Show("Data Updated!!!");

这篇关于使用npgsql从datagridview更新不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！