且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

将数据行与字符串进行比较

更新时间:2023-01-07 12:51:09

为什么不运行查询:



Why not just run a query:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT COUNT(*) FROM players WHERE [name]=@AR1 AND lastname=@AR2 AND dob=@AR3", con))
        {
        com.Parameters.AddWithValue("@AR1", first);
        com.Parameters.AddWithValue("@AR2", second);
        com.Parameters.AddWithValue("@AR3", third);
        if( com.ExecuteScalar > 0)
            {
            // It exists already
            }
        }
    }