{"id":44,"date":"2014-06-12T15:51:00","date_gmt":"2014-06-12T20:51:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=44"},"modified":"2023-07-26T12:33:24","modified_gmt":"2023-07-26T17:33:24","slug":"net-create-dynamic-sqlcommand-parameters","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=44","title":{"rendered":"NET : Create Dynamic SqlCommand Parameters"},"content":{"rendered":"
\nstring<\/span> IDs = “2055,1644,5889”<\/span>;<\/o:p><\/span><\/div>\n
\nList<string<\/span>>
\nIDNumbers = IDs.Split(‘,’<\/span>).ToList<string<\/span>>();<\/o:p><\/span><\/div>\n
\n<\/div>\n
\nStringBuilder sb = new<\/span>
\nStringBuilder();<\/o:p><\/span><\/div>\n
\ncmd = conn.CreateCommand();<\/o:p><\/span><\/div>\n
\ncmd.CommandType = CommandType.Text;<\/o:p><\/span><\/div>\n
\n<\/div>\n
\nsb.Append(“SELECT
\n* FROM TABLE WHERE (“<\/span>);<\/o:p><\/span><\/div>\n
\n<\/div>\n
\n\/\/build parameters<\/span><\/o:p><\/span><\/div>\n
\nforeach<\/span> (string<\/span> idNumber in<\/span> IDNumbers)<\/o:p><\/span><\/div>\n
\n{<\/o:p><\/span><\/div>\n
\nsb.Append(“TABLE.ID
\n= “<\/span> + “:parm”<\/span> +
\nidNumber.ToString());<\/o:p><\/span><\/div>\n
\nsb.Append(” OR
\n“<\/span>);<\/o:p><\/span><\/div>\n
\n}<\/o:p><\/span><\/div>\n
\nsb.Remove(sb.Length – 3, 3);<\/o:p><\/span><\/div>\n
\nsb.Append(“)
\n“<\/span>);<\/o:p><\/span><\/div>\n
\n<\/div>\n
\nforeach<\/span> (string<\/span> idNumber in<\/span> IDNumbers)<\/o:p><\/span><\/div>\n
\n{<\/o:p><\/span><\/div>\n
\ncmd.Parameters.Add(new<\/span>
\nOracleParameter(“parm”<\/span> +
\nidNumber.ToString(), idNumber));<\/o:p><\/span><\/div>\n
\n}<\/o:p><\/span><\/div>\n
\n<\/div>\n
\ncmd.ExecuteNonQuery();<\/o:p><\/span><\/div>\n

<\/p>\n

\n<\/div>\n","protected":false},"excerpt":{"rendered":"

string IDs = “2055,1644,5889”; List<string> IDNumbers = IDs.Split(‘,’).ToList<string>(); StringBuilder sb = new StringBuilder(); cmd = conn.CreateCommand(); cmd.CommandType = CommandType.Text; sb.Append(“SELECT * FROM TABLE WHERE (“); \/\/build parameters foreach (string idNumber in IDNumbers) { sb.Append(“TABLE.ID = “ + “:parm” + idNumber.ToString()); sb.Append(” OR “); } sb.Remove(sb.Length – 3, 3); sb.Append(“) “); foreach (string idNumber in IDNumbers) … Continue reading “NET : Create Dynamic SqlCommand Parameters”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4,27],"tags":[39,53],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/44"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=44"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions"}],"predecessor-version":[{"id":173,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/44\/revisions\/173"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=44"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=44"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=44"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}