VB.NET和SQL Server等价 [英] VB.NET and SQL Server Equivalent

问题描述

有谁能请给我VB.NET或C＃+ SQL Server版本的代码片段？我从未使用过PHP。

Can anyone please give me the VB.NET or C# + SQL Server version of the code snippet?? I have never used php.

// An array containing the category ids as keys and the new positions as values
$display_order = array(
    1 => 4,
    2 => 1,
    3 => 2,
    4 => 3,
    5 => 9,
    6 => 5,
    7 => 8,
    8 => 9
);

$ids = implode(',', array_keys($display_order));
$sql = "UPDATE categories SET display_order = CASE id ";
foreach ($display_order as $id => $ordinal) {
    $sql .= sprintf("WHEN %d THEN %d ", $id, $ordinal);
}
$sql .= "END WHERE id IN ($ids)";
echo $sql;

推荐答案

display_order =数组（
1 => 4，
2 => 1，
3 => 2，
4 => 3，
5 => 9，
6 => 5，
7 => 8，
8 => 9
）;

display_order = array( 1 => 4, 2 => 1, 3 => 2, 4 => 3, 5 => 9, 6 => 5, 7 => 8, 8 => 9 );

ids = implode（' ，'，array_keys（

ids = implode(',', array_keys(

display_order））;

display_order));

这篇关于VB.NET和SQL Server等价的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！