如何在C＃中使用Where语句有多个条件？ [英] How Do I Have Multiple Conditions Using Where Statement In C#?

问题描述

我需要在单个更新语句中使用where条件有多个条件？

 sql =  更新[Sheet1 $]设置FinalStatus ='成功'，其中Name ='mahesh'; 

update [Sheet1 $]设置FinalStatus ='成功'，其中Add ='CMB'，FinalStatus ='成功'，联系人='1234';

解决方案

设置FinalStatus ='成功'，其中Name ='mahesh';

update [Sheet1

设置FinalStatus ='成功'，其中Add ='CMB'，FinalStatus ='Success'，Contact ='1234';

< blockquote>使用和

  update  [Sheet1 
 
 
i need to have multiple conditions in single update statement using where condition?



sql = "Update [Sheet1$] set FinalStatus='Success' where Name='mahesh'";




update [Sheet1$] set FinalStatus='Success' where Add='CMB', FinalStatus='Success', Contact='1234';
解决方案
set FinalStatus='Success' where Name='mahesh'";

update [Sheet1

set FinalStatus='Success' where Add='CMB', FinalStatus='Success', Contact='1234';

use "and"

update [Sheet1

这篇关于如何在C＃中使用Where语句有多个条件？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！