mysql execute 获取多个参数_vb.net调用mysql使用select命令查询数据时，比如查询学生分数在60分以上的有多少个时，会返回个数，如何用vb.net获取这个返回值？...

ExecuteScalar

例子

// Create Connection

MySqlConnection con = new MySqlConnection(_connectionString);

// Create Command

MySqlCommand cmd = new MySqlCommand();

cmd.Connection = con;

cmd.CommandText = "SELECT COUNT(*) FROM orchards WHERE OrchardName = @OrchardName";

cmd.Parameters.Add("@OrchardName", OrchardName);

// Return Count

con.Open();

Int32 NumRows = (Int32)cmd.ExecuteScalar();

return NumRows;

专注于.NET ERP/CRM开发框架，C/S架构，SQL Server + ORM(LLBL Gen Pro) + Infragistics WinForms