DataTable使用介绍:http://www.dotnetperls.com/datatable
取数据
SQL结果存到DataTable例子:http://stackoverflow.com/questions/6073382/read-sql-table-into-c-sharp-datatable
简要代码例子:
String conStr = @"server=stcvm-130;integrated security=true;database=RAADB";
SqlConnection con = new SqlConnection(conStr);
SqlParameter catName = new SqlParameter("@CatName", "洗发水");
SqlCommand com = new SqlCommand();
com.CommandType = System.Data.CommandType.StoredProcedure;
com.Connection = con;
com.Co