ListView选择 [英] ListView select

问题描述

你好，

我有一个listView，一个按钮

当我单击该按钮时，将执行该操作并在数据库中插入一行.

Hello,

I have a listView, a button

When I click the button is executed and insert a row in my data base.

void TrimiteInService(object sender, EventArgs e)
        {
            Program.Connection.CommandText = "insert into ProdusReparat(DataTrimitereService,DataIesireService, ProdusID, UserName) values (@DataTrimitereService, @DataIesireService, @ProdusID, @UserName)";
            Program.Connection.AddParameter("@DataTrimitereService", txtDataTimp.Text);
            Program.Connection.AddParameter("@DataIesireService", "Produs în service");
            Program.Connection.AddParameter("@ProdusID", codProdus.Text);
            Program.Connection.AddParameter("@UserName", UserName);
            Program.Connection.ExecuteNonQuery();
            AfiseazaProduseReturnate();
        }

如果DataIesireService ==服务中的产品"
，如何禁用不插入新的ron的按钮

我的英语不好

How can I Disable the butten to not insert a new ron if the DataIesireService == "Produs in service"


my english is bad

推荐答案

尝试使用IF语句.

即

Try using IF statement.

i.e.

void TrimiteInService(object sender, EventArgs e)
        {
            Program.Connection.CommandText = "if(@DataIesireService <> 'Produs in service') insert into ProdusReparat(DataTrimitereService,DataIesireService, ProdusID, UserName) values (@DataTrimitereService, @DataIesireService, @ProdusID, @UserName)";
            Program.Connection.AddParameter("@DataTrimitereService", txtDataTimp.Text);
            Program.Connection.AddParameter("@DataIesireService", "Produs în service");
            Program.Connection.AddParameter("@ProdusID", codProdus.Text);
            Program.Connection.AddParameter("@UserName", UserName);
            Program.Connection.ExecuteNonQuery();
            AfiseazaProduseReturnate();
        }

这篇关于ListView选择的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！