C# SQL 筛选

最新推荐文章于 2024-09-29 06:40:56 发布

shanshan04132

最新推荐文章于 2024-09-29 06:40:56 发布

阅读量530

点赞数

分类专栏： SQL Sever2008 文章标签： c# sql dataset string 数据库

本文链接：https://blog.csdn.net/shanshan04132/article/details/7099275

版权

SQL Sever2008 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

一、查询两张表，从第一张表中按nutCode.id排出第二张表内已有的内容

方法一：

string selectstr =“select carType.carTypeName,nutCode.code,nutCode.nutCodeName,nutCode.id ”+

“from nutCode,carType ”+

“where nutCode.carTypeId=carType.id and nutCode.isPtest=1 and nutCode.id ”+

“not in(select taskContent.nutCodeid from taskContent,task where taskContent.taskId=task.id and task.cdatetime>='2011-12-12 08:08:08')”;

方法二：

string selectstr = "select carType.carTypeName,nutCode.code,nutCode.nutCodeName,nutCode.id " +
"from carType,nutCode " +
"where nutCode.carTypeId=carType.id and nutCode.isPtest=1 ";

SqlCommand selectcmd = new SqlCommand(selectstr , conn);
SqlDataAdapter selectsda = new SqlDataAdapter();
selectsda.SelectCommand = selectcmd;
DataSet ds = new DataSet();
selectsda.Fill(ds, "box");
//连接数据库
//查询几个表
string selectstr1 = "select carType.carTypeName,nutCode.nutCodeName,taskContent.completion,taskContent.nutCodeId " +
"from carType,nutCode,taskContent,task " +
"where taskContent.nutCodeId=nutCode.id and nutCode.carTypeId=carType.id and " +
"taskContent.taskId=task.id and task.cdatetime>='2011-12-12 08:08:08'";

SqlCommand selectcmd1 = new SqlCommand(selectstr1 , conn);
SqlDataAdapter selectsda1 = new SqlDataAdapter();
selectsda1.SelectCommand = selectcmd1;
DataSet ds1 = new DataSet();
selectsda1.Fill(ds1, "box");
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
for (int j = 0; j < ds1.Tables[0].Rows.Count; j++)
{
if (ds.Tables[0].Rows[i]["id"].ToString() == ds1.Tables[0].Rows[j]["nutCodeId"].ToString())
{
ds.Tables[0].Rows.RemoveAt(i); //删除ds与ds1中重复的
}
else
{
ds.Tables[0].Rows[i]["number"] = Convert.ToString(i + 1);
}
}
}