C#客户端 TVP

private DataTable ToDataTable(IList<People> peopleList , bool insert) { DataTable dt = new DataTable(); dt.Columns.Add("PeopleID", typeof(long)); dt.Columns.Add("Name", typeof(string)); dt.Columns.Add("CityID", typeof(int)); dt.Columns.Add("ProvinceID", typeof(int)); dt.Columns.Add("CountryID", typeof(int)); int i = 0; foreach (People peopleInfo in peopleList) { DataRow row = dt.NewRow(); row["PeopleID"] = (insert) ? ++i : peopleInfo.PeopleID;

    `row["Name"] = peopleInfo.Name;`

    `row["CityID"] = peopleInfo.CityID;`

    `row["ProvinceID"] = peopleInfo.ProvinceID;`

    `row["CountryID"] = peopleInfo.CountryID;`

    `dt.Rows.Add(row);`
`}`
`return dt;`

}