Exceute non query InvalidOperationException

本文关键字:InvalidOperationException query non Exceute | 更新日期: 2023-09-27 18:34:37

我正在尝试连接到sql服务器,但我有这个错误:

System.InvalidOperationException:ExecuteNonQuery 需要打开和 可用连接。连接的当前状态为关闭。 在 System.Data.SqlClient.SqlCommand.ValidateCommand(String method, 布尔异步( System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource'1 完成, 字符串方法名称, 布尔发送到管道, Int32 超时, 布尔异步写入( at System.Data.SqlClient.SqlCommand.ExecuteNonQuery(( at FattureServer.Form1.button4_Click(对象发送器,EventArgs e(

string dbserver2 = textBox4.Text;
string dbname2 = textBox1.Text;
string dbusername2 = textBox2.Text;
string dbpassword2 = textBox3.Text;

SqlConnection conn2 = new SqlConnection("Data Source=" + dbserver + ";Initial Catalog=" + dbname + ";User ID=" + dbusername + ";Password=" + dbpassword + "");
// SqlCommand cmd2 = new SqlCommand("INSERT INTO Cliente (IdCliente,IdUtente,RagioneSociale,Titolo,Indirizzo,Stato,Provincia,Citta,Comune,Cap,Telefono,Email) VALUES(@idcliente,@username,@password, @email)", conn2);
string query2 = "INSERT INTO Cliente (Titolo,RagioneSociale) VALUES(@Titolo,@RagioneSociale)";
SqlCommand myCommand = new SqlCommand(query2, conn2);
myCommand.Parameters.AddWithValue("@Titolo", titolo);
myCommand.Parameters.AddWithValue("@RagioneSociale", ragionesociale);
myCommand.ExecuteNonQuery();
conn2.Close();

如何解决此错误?

编辑:

如果我插入conn2.open((,我有这个错误:

System.Data.SqlClient.SqlException (

0x80131904(:无效的对象名称"Cliente"。 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction( at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction( at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose( at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&dataReady( at System.Data.SqlClient.SqlCommand.FinishExecuteReader (SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString( at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest( at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite( at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite( at System.Data.SqlClient.SqlCommand.ExecuteNonQuery(( at FattureServer.Form1.button4_Click(Object sender, EventArgs e( in C:''Users''riccardo''Desktop''FattureServer''FattureServer''Form1.cs:line 189 ClientConnectionId:02db8bd4-e91a-4b43-9ba9-e1717c9e96de 错误号:208,状态:1,类:16

Exceute non query InvalidOperationException

你忘了做一个conn2。打开((;在执行命令之前。

编辑。 大卫·布拉班特是正确的...您应该将所有内容包装在 using 语句中。

编辑 2.看起来您的表"客户端"是在数据库中创建的。您确定指向正确的数据库并且该表已存在吗?

无效的对象名称"客户端">

这是另一个问题。也许,是一个错字。客户?检查数据对象以避免拼写错误。

相关文章:
  • 没有找到相关文章