如何在MySQL选择查询中添加整数值? [英] How to add integer value in Mysql select query?

问题描述

你好
我正在研究ASP.NET C#项目.我的Mysql查询是"SELECT name FROM techer_reg LIMIT 3"，在这里我如何添加一个整数值而不是3.意味着此选择查询应类似于"SELECT Name FROM techer_reg LIMIT(我的整数值)"，请帮助我解决此问题问题 .在此先感谢您.

Hello
I am working on a ASP.NET C# project. My Mysql query is "SELECT Name FROM techer_reg LIMIT 3", Here how i can add a integer value instead of 3. Means This select query should be like "SELECT Name FROM techer_reg LIMIT (My integer value)" Please help me to fix this problem . Thanks in advance.

推荐答案

尝试使用以下参数:

Try using a parameter:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    int myLimit = 4;
    using (SqlCommand com = new SqlCommand("SELECT Name FROM techer_reg LIMIT @LM", con))
        {
        com.Parameters.AddWithValue("@LM", myLimit);
        using (SqlDataReader reader = com.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int)reader["iD"];
                string desc = (string)reader["description"];
                Console.WriteLine("ID: {0}\n    {1}", iD, desc);
                }
            }
        }
    }

这篇关于如何在MySQL选择查询中添加整数值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！