string strConn = @"Data Source=.;Initial Catalog=DEMO2;User Id=sa;Password=Auto@sql;"; string sqlGetData = "SELECT *FROM dbo.T1"; SqlParameter[] parasGetData = new SqlParameter[]{}; DataSet ds = SqlHelper.ExecuteDataset(strConn, CommandType.Text, sqlGetData, parasGetData); string sqlInsertData = @"INSERT INTO dbo.T2(ID) SELECT ID FROM @vt as T"; SqlParameter dtPara = new SqlParameter("@vt", ds.Tables[0]); dtPara.SqlDbType= SqlDbType.Structured; dtPara.TypeName = "dbo.udt_T1"; SqlParameter[] parasInsertData = new SqlParameter[] { dtPara }; SqlHelper.ExecuteNonQuery(strConn, CommandType.Text, sqlInsertData, parasInsertData); Console.WriteLine("ok"); Console.ReadLine();