Question

用C#实现SQL查询

用C#将这段SQL查询实现
SELECT R.Name,C.name,st_Length(st_Intersection(R.Shape,C.Shape))
AS"Length"
FROM River3 R,Sheng C
WHERE st_Crosses(R.Shape,C.Shape)=True

Answer 1

using(sqlconnection conn=new sqlconnection("连接字符串")){
using(sqlcommand cmd=new conn.createcommand()){
conn.open();
cmd.commandtext="sql语句";
cmd.commandtype=commandtype.text
sqldatareader reader= cmd.executereader();//执行sql命令

}
}