摘要：update T_Product set amount=(case when quantity<10 then amount*(1-0.1)when quantity between 10 and 20 then amount*(1-0.2)else amount*(1-0.3)end) 阅读全文

摘要：using System;using System.Collections.Generic;using System.Linq;using System.Text;namespace RefAndOutAndParams{ class Program { /// <summary> /// 一个方法中可以动态传递多个参数的方法 /// </summary> /// <param name="list"></param> public static void MyTestParams(params Object [... 阅读全文

摘要：string connStr = "Server=178.88.1.121;initial catalog=test;User=sa;password=abc.DB"; using (SqlConnection conn = new SqlConnection(connStr)) { SqlCommand command = new SqlCommand("select top 4 * from h_emp_mstr", conn); conn.Open(); DataSet ds = new DataSet(); ds.DataSetName = &q 阅读全文