鎬庝箞鎶妔ql鏁版嵁搴撶殑淇℃伅 鎻愬彇鍒癱#閲岄潰 - 宸茶В鍐?- 鎼滄悳闂棶
鎬庝箞鎶?绗竴琛岀殑time 4 鏁版嵁 鎻愬彇鍒?c#
int time=select time.....?
鎬庝箞鎶?绗竴琛岀殑time 4 鏁版嵁 鎻愬彇鍒?c#
int time=select time.....?
答案:ExecuteReader鏂规硶锛屽弬鑰冧唬鐮佸涓?/p>using System;
using System.Data.SqlClient;
public class Test
{
public static void Main(string[] args)
{
string source="Server =192.168.1.100; User ID=xxx; Password=xxx; Initial CataLog=Account";//鏁版嵁搴撹繛鎺ュ瓧绗︿覆锛孶ser ID鏄敤鎴峰悕; Password鏄瘑鐮?/p>string select="select top 1 time from 琛ㄥ悕";
SqlConnection conn=new SqlConnection(source);
conn.Open();
SqlCommand cmd=new SqlCommand(select,conn);
SqlDataReader reader=cmd.ExecuteReader();//杩斿洖鍙兘璇诲彇,涓嶈兘鍐欏叆鐨凷qlDataReader瀵硅薄
if(reader.Read())
{
int time = (int)reader["time"];}
Console.WriteLine(time);
}
}stringbuilder str = new stringbuilder();
str.append("select count 1 time from table order by id ");
sqlconnection con = new sqlconnection("杩欓噷鏄暟鎹簱杩炴帴瀛楃涓?);
con.open();
sqlcommand cmd = new sqlcommand(con,str.tostring());
sqldatareader drs = cmd.ExecuteReader();
while(reader.Read())
{
Console.WriteLine(String.Format("time is {0}",
drs[2],]));
}drs.close();
con.close();
鎵嬪啓鐨?nbsp; 浼拌鏈夐敊璇?锛屼絾澶ф灏辨槸杩欐牱瀛?br>
鍒涘缓涓狶INQ TO SQL绫诲氨鍙互浜嗭紒锛佹妸鏁版嵁搴撶殑琛ㄦ媺杩涘幓锛宱k
鐢╝do.net 鍟?/pre>SQL璇彞鎷煎啓濂藉氨鍙互浜嗗晩锛屾嫾鍐欑殑SQL璇彞鍙鎷垮埌绗竴琛岀涓夊垪鐨勫€煎氨琛岋紝鎴栬€呰繑鍥濪ATATABLE锛岀劧鍚庢嬁闇€瑕佺殑琛屽垪灏辫鍟?/p>
鍦–#褰撲腑鐭ラ亾ID鍚楋紵
濡傛灉鐭ラ亾灏辩洿鎺ユ煡閭d竴鍒楀氨琛屼簡鍛楋紝鎴戣繖閲屽氨鍙啓鏌ヨ璇彞鍟?/p>
string sql="select time from Table_Name where Id="+杩欓噷鍐欐潯浠讹紝涔熷氨鏄幏鍙栫殑Id;
濡傛灉涓嶇煡閬揑d锛?閭e彲浠ラ€氳繃瀛愭煡璇㈡煡鍑烘潵鐨勶紝鍏蜂綋鎬庝箞鍐欐垜娌$湅杩囦綘鐨勮璁″浘锛屾墍浠?...
鍝︼紝杩樻湁涓€涓煡璇㈣鍙ワ細string sql="select top 1 Id, time from Table_Name where Id not in (select top 3 Id from Table_Name )";锛岃繖涓煡璇㈡槸姝荤殑锛屽簲璇ユ病浠€涔堢敤澶勶紝搴旇浣犻偅鏌ヨ閮芥槸鏈夋潯浠剁殑鍚э紝杩樻湁灏辨槸鏌ヨ鍑烘潵鍚庯紝瑕佹暟鎹浆鎹竴涓嬪氨Ok浜嗭紝鐢ㄤ竴涓猧nt 鍙橀噺鎺ユ敹灏辫浜?/p>SqlConnection cn = new SqlConnection("server=鏈嶅姟鍣ㄥ悕绉?user=鐢ㄦ埛鍚?password=瀵嗙爜;database=鏁版嵁搴撳悕绉?);
cn.Open();
string select="select time form 琛ㄥ悕";//鎸囧畾鏌ヨ琛ㄤ腑鐨則ime 鍒?br> SqlCommand cmd = new SqlCommand(select, cn);
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
Console.WriteLine(dr.GetValue(0));
}